Android Question What is the best SQLite data browser to use?

AndreyPozdnyakov · Feb 21, 2022

Hello!
Can you please tell me which SQLite data browser is preferable to use today?
My database consists of several tables with a fairly complex structure with not very many records.

I see a lot of bad reviews for the classic ""DB Browser for SQLite"", but maybe users didn't explore it well enough.

Thank you very much in advance.

Heuristx · Feb 21, 2022

SQLite Studio is pretty good.

SQLiteStudio

sqlitestudio.pl

Spavlyuk · Feb 21, 2022

Where are the bad reviews? It has 16k stars on github and I've had no issues using it a couple of times.

AndreyPozdnyakov · Feb 21, 2022

Heuristx said:
SQLite Studio is pretty good.

SQLiteStudio

sqlitestudio.pl

Thank you!

Shelby · Feb 21, 2022

I love the ease of use of the DB Browser. I discovered that if I change the word False to True in the following line, I then have easy and fast editing/updating of any text in the DB Browser. It's also free.

If File.Exists(DBFileDir, DBFileName) = False Then ......

That line is from module: B4XMainPage.

Guenter Becker · Feb 21, 2022

Hi, DBWeaver (free) or the best I think SQLite Expert Professional.

asales · Feb 21, 2022

Heuristx said:
SQLite Studio is pretty good.

SQLiteStudio

sqlitestudio.pl

I use this one too.

musaso · Feb 21, 2022

DB Browser It allows reading files with pwd from previous and current versions of SQlite, it is also free.

https://sqlitebrowser.org/

watesoft · Feb 22, 2022

SQLiteManager

Magma · Feb 22, 2022

SQLiteStudio... i think is one of the best...

makis_best · Feb 28, 2022

I use HeidiSQL is free software and can connect to any database from everywhere.

epiCode · Feb 28, 2022

I've been using SQL DB Browser for quite sometime but after some recent updates it stopped allowing import of empty cells from csv files and replaces them with NULL, which is additional work to convert them from NULL to empty.
Which led me to switch to SQL Studio which is equally amazing with better UI and better import/export of csv files.

Martin Larsen · Mar 2, 2022

I use DBeaver Community Edition. It is awesome. Also for MySQL, MSSQL and whatever. It's fantastic. And crossplatform.

mcqueccu · Mar 2, 2022

Downloads - DB Browser for SQLite

sqlitebrowser.org

Mahares · Mar 8, 2022

All the above mentioned PC SQLite browsers are good. I use one of them occasionally. I prefer to do all the CRUD commands on the device. It gives me a better feel of how the CRUD (Create, Read, Update, Delete) commands really work.
The dilemma comes when the PC browser program has a later version that that of the device used (Tablet/Phone), which is most of the case. For instance the IIF function works well on a PC browser with version 3.36 because the IIF fumction was released in version 3.32.0. But if you try to use it on a device with version SQLite prior to 3.32, you are out of luck and start scratching your head why it is working on PC, but not device.

Magma · Mar 8, 2022

Mahares said:
All the above mentioned PC SQLite browsers are good. I use one of them occasionally. I prefer to do all the CRUD commands on the device. It gives me a better feel of how the CRUD (Create, Read, Update, Delete) commands really work.
The dilemma comes when the PC browser program has a later version that that of the device used (Tablet/Phone), which is most of the case. For instance the IIF function works well on a PC browser with version 3.36 because the IIF fumction was released in version 3.32.0. But if you try to use it on a device with version SQLite prior to 3.32, you are out of luck and start scratching your head why it is working on PC, but not device.

You have right..
Also when you want get total rows, at PC works sql count... but on android... not

Mahares · Mar 8, 2022

Magma said:
when you want get total rows, at PC works sql count... but on android... not

What exactly do you mean. You can get the row (record) count on the device easily with rs.RowCount and with other ways. Give an example with code.

Magma · Mar 8, 2022

Mahares said:
What exactly do you mean. You can get the row (record) count on the device easily with rs.RowCount and with other ways. Give an example with code.

sorry i was talking about pc - b4j... in b4a ofcourse rowcount works... but in b4j (not exists):

So a way getting row count is:

B4X:

            cursordb=datadb.ExecQuery("SELECT count(*) FROM " & SQLtable)
            rec=(cursordb.GetInt2(0))

...but this code not works on B4A !!!!

work only with this way:

B4X:

        cursordb=datadb.ExecQuery("SELECT count(*) FROM " & SQLtable)
            Do While cursordb.NextRow
            rec=(cursordb.GetInt2(0))
            Log(rec)
            Loop

need to be in a loop... why that ?

mcqueccu · Mar 8, 2022

Magma said:
...but this code not works on B4A !!!!

You are missing cursor position

B4X:

 cursordb=datadb.ExecQuery("SELECT count(*) FROM " & SQLtable)
 cursordb.position = xx '<-------------replace xx with 0 or loop counter
 rec=(cursordb.GetInt2(0))

klaus · Mar 8, 2022

Simple way to get the row count, works on all three platforms:

B4X:

RowCount = SQL1.ExecQuerySingleResult("SELECT count(*) FROM " & SQLtable))

Android Question What is the best SQLite data browser to use?

Member

Active Member

Active Member

Member

Well-Known Member

Active Member

Expert

Active Member

Active Member

Expert

Well-Known Member

Active Member

Active Member

Well-Known Member

Expert

Expert

Expert

Expert

Well-Known Member

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency