Potential - but improvable I got this to see if I could see / edit the contents of the Firefox Stylish plugin db. This will let me ... but: The font size is ridiculously small for anything but a phone. On a 10" device, the main page takes up 1/24th of the display. Any listings are so tiny that it takes me several tries to get the one I want. The file navigation needs help. Hundreds of files and folders mixed together in a tiny column squished to the left side - in addition to larger font, a search feature and a filter feature are needed. Let the user search for a name pattern in the huge list, or let the user filter out anything except SqlLite files. I can't comment on the data editing yet, but I'll pass on the same comments: Larger font for larger devices, easy editing, and maybe a search or search/replace feature.
My Choice Of Mobile Editors I primarily use this for prototyping databases I'm using in desktop and mobile applications. I find it very useful in that capacity. Can't honestly speak to its other features, as I haven't really used them, but for easily generating table creation statements on my tablet, it's excellent.
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.
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...
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.
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