4 stars Useful, unique. But the hardest to use compared to SQLite Editor, SQLite Debugger, SQLite Manager. Term is my daily driver but this feels a bit like the learning curve for Linux back in 1996, its that hard :) Also, choosing Menu→Exit three times when done is exhausting. The shell is a bit slow too. At 1st, I got errors then found in settings that its not recommended to use /emulated/0, thay fixed it. Overall, this one is quite good but usually I'll use better ones (and easier, faster).
Jeff is right, this drives me mad... Great DB app, but the Commit is broke when editing data on Tables. I have to edit the table, back out of the app. No changes are saved. Then go back into the app, make the changes again, and this time it prompts me to commit the changes. So 50% of changes are not commtted. Its a horrible bug. Please fix. Otherwise great app. 3 stars till commit is fixed...
Well it has worked wonder for me. Great. Couple of things. How do I add photos in it? When I used this app on 9.7inch screen the drop down selection does not work. How to edit an existing database fields? Please assist. BIG THANKS
Very Good Does virtually everything I need! Paging performance is slow with 200 rows taking about 4 seconds per page. Could do with a 'jump to row' option when viewing large tables (120K rows)
Found a bug tho that gave me headache. Scenario: 1.) View unfiltered table records and thrn go "page down" or next page 2.) apply some filtering that will result in only having a few records 3.) result returns empty Conclusion: I found out later that i only had to go "page up" to see my result set. All this time i thought there was something wrong with my data... wew. But theres nothing wrong. ITS A BUG. The page should auto reset to page 1 when filtered. :) please fix thank you!
Mostly it does what it says on the tin. It's a lightweight db manager. However it lacks support for some features like creating a table with constraints. (It's still possible to achieve the same result using a raw query.) Also the interface can get annoying; for example the Edit button can be so small it's hard to press.
Fixed the open SQL file bug.
Edit system database from other file managers
Views included in query builder
Send link to database to home screen
Run script when opening database
Enhanced export functionality - export to CSV / HTML table (select all / none / revert)
Configure which commands to show as buttons or in menu
Display BMP-files stored in blob fields
And much more.
For a complete list of improvements check http://aaa.andsen.dk/aSQLiteManager.html