Android Question Android SQLite Database Viewer

[DawningTruth]

I am looking for an Android Based or B4A (in App) sqlite viewer.

I see there is a very old thread from 2011 with one:

https://www.b4x.com/android/forum/threads/android-sqlite-viewer.9197/#content

Is this still current or is there another simple way to view my database?

 

[LucaMs]

It works well and is very useful. You can modify it according to your needs.
Perhaps there are apps on the market that do the same.

 

[asales]

I use this app:
https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager

 

[AnandGupta]

I use this app:
https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager

Me too !
And found it simple and useful.

Regards,

Anand

 

[DawningTruth]

Thx for all the suggestions, will investigate them. I'm going to add such a viewer to the wish list. Having an embedded database viewer in B4x will really make database development much for user friendly.

 

[DawningTruth]

I use this app:
https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager

@asales @AnandGupta Have downloaded it onto my phone. Any idea where to find the sqlite file on my phone?

 

[AnandGupta]

@asales @AnandGupta Have downloaded it onto my phone. Any idea where to find the sqlite file on my phone?

If you have saved your .db in File.DirRootExternal then you can open it in aSQLiteManager, i.e the .db file should be visible by any file explorer in your phone.

Regards,

Anand

 

[AnandGupta]

Thx for all the suggestions, will investigate them. I'm going to add such a viewer to the wish list. Having an embedded database viewer in B4x will really make database development much for user friendly.

You mean sqlite viewer/editor in B4X IDE, I think, but we are suggesting app for the phone.
For Win desktop there are many free sqlite viewer/editor and I use "HeidiSQL" free though there are many.

Regards,

Anand

 

[DawningTruth]

Thx for all the Help Anand .

 

[dlfallen]

Another suggestion is my Blue Sky Database program. https://www.b4x.com/android/forum/threads/bluesky-database.40341/#post-326937

It is based on Erel's SQLITE VIEWER but with several enhancement which I (and at least one other person) find useful, including the ability to store and reuse queries and queries with replacebile parameters. A more complete description can be found with the above link.

 

[DawningTruth]

Another suggestion is my Blue Sky Database program. https://www.b4x.com/android/forum/threads/bluesky-database.40341/#post-326937

It is based on Erel's SQLITE VIEWER but with several enhancement which I (and at least one other person) find useful, including the ability to store and reuse queries and queries with replacebile parameters. A more complete description can be found with the above link.

Thx, I'll check that out .