B4J Question Tool to build SQLite Queries

[Giacomo]

Hello,
I have the Personal Version of SQLite, which does not have the visual tool to build queries.
It is quite boring to build and test my queries.
Is there a tool or app (free) to create them?

Thanks to anyone who responds

 

[Swissmade]

DB Browser for SQLite

sqlitebrowser.org

Version 3.13.1 released - DB Browser for SQLite

sqlitebrowser.org

Nice this to use

 

[Swissmade]

I hope it helps.

 

[Swissmade]

I hope it helps.

Nice enjoy

 

[Giacomo]

I hope it helps.

Thank you,
It actually helps you.
I hoped for more.

 

[josejad]

Is there a tool or app (free) to create them?

have you tried to pass the sql create of your database to an AI, and ask it something like: "I need all the records from that table that meet this condition, but no... bla bla bla"

 

[Giacomo]

have you tried to pass the sql create of your database to an AI, and ask it something like: "I need all the records from that table that meet this condition, but no... bla bla bla"

Do you think it helps?

 

[aeric]

Check similar threads at the bottom.

[Class] [B4J] [SQLite] wmSQLiteSelectBuilder - a more or less graphical builder for SQLite SELECT statements

As I don't use SQLite (or any other SQL) all the time and am no database expert, it's always a bit of a challenge to get the SELECT syntax right, specifically when relationships between tables (JOINs) come into play. There's that, and the fact that it was fun to develop (and I wanted to have the...

www.b4x.com