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).
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)
The app will not open a database file stored on external sd card (and instead of saying so, it gives the scary error message that the file is not a database). Once I copied the database to internal memory, it opened without any problem. User interface could use lots of improvement. Have to use PgUp and PgDn buttons instead of scrolling through all records in a table (looks like this is implemented this way for quickness when browsing through large tables). No pinch-to-zoom in or out. Ability to execute native sqlite dot commands (like .dump and .schema) would be a big improvement. But the app has a lot to recommend it - it's probably your best bet for editing sqlite databases on your android device.
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...
Excellent app but... User must switch tables or backout of the current database to force app to ask user to commit changes. If you back up to opening dialog or exit app before committing, changes are lost. App should provide a commit button or other proactive ui to commit and should warn user about losing changes before any action that would drop changes, e.g., exit, occurs. A minor improvement would be to increase the list font size or at least provide the option.
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