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).
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...
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!
Problems with saving changes Few day the sqlite won't save changes in the same folder where app installed, how to fix it ? Tel me if any setting required
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