D DawningTruth Active Member Licensed User Aug 4, 2019 #1 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?
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 Expert Licensed User Longtime User Aug 4, 2019 #2 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. Upvote 0
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 Expert Licensed User Longtime User Aug 4, 2019 #3 I use this app: https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager Upvote 0
AnandGupta Expert Licensed User Longtime User Aug 6, 2019 #4 asales said: I use this app: https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager Click to expand... Me too ! And found it simple and useful. Regards, Anand Upvote 0
asales said: I use this app: https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager Click to expand... Me too ! And found it simple and useful. Regards, Anand
D DawningTruth Active Member Licensed User Aug 8, 2019 #5 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. Upvote 0
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.
D DawningTruth Active Member Licensed User Aug 8, 2019 #6 asales said: I use this app: https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager Click to expand... @asales @AnandGupta Have downloaded it onto my phone. Any idea where to find the sqlite file on my phone? Upvote 0
asales said: I use this app: https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager Click to expand... @asales @AnandGupta Have downloaded it onto my phone. Any idea where to find the sqlite file on my phone?
AnandGupta Expert Licensed User Longtime User Aug 8, 2019 #7 DawningTruth said: @asales @AnandGupta Have downloaded it onto my phone. Any idea where to find the sqlite file on my phone? Click to expand... 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 Upvote 0
DawningTruth said: @asales @AnandGupta Have downloaded it onto my phone. Any idea where to find the sqlite file on my phone? Click to expand... 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 Expert Licensed User Longtime User Aug 8, 2019 #8 DawningTruth said: 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. Click to expand... 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 Upvote 0
DawningTruth said: 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. Click to expand... 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
D dlfallen Active Member Licensed User Longtime User Aug 13, 2019 #10 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. Upvote 0
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.
D DawningTruth Active Member Licensed User Aug 13, 2019 #11 dlfallen said: 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. Click to expand... Thx, I'll check that out . Upvote 0
dlfallen said: 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. Click to expand... Thx, I'll check that out .
