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

[AndreyPozdnyakov]

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.

 

[Mahares]

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

No, it does not need to be in a loop in B4A . You can do it like this if you do not want to use rs.RowCount

Dim rs As ResultSet    
    rs= SQL.ExecQuery("SELECT count(*)  FROM table1 ")
    If rs.NextRow Then 
        Log($"My row count is: ${rs.GetInt2(0)}"$)
    End If

 

[Magma]

@mcqueccu @klaus @Mahares

"as long as you live you learn"

@Mahares ...rs.NextRow not in loop... but need an if
@mcqueccu position... right !!!

I ll take klaus suggested ---> one for all ---> i want to fix my brain for B4X setup !!!

 

[RichardN]

+1 for SQLite Expert Professional

 

[aeric]

Just installed sqlitebrowser v3.13.x-rc1
It is now supporting unixepoch().

DBeaver is good too. I can use it to open Firebird db.

 

[RB Smissaert]

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.

Never seen any problem with DB Browser for SQLite after extensive use.
There is also DB Browser for SQLCipher, which works equally fine.

RBS