aSQLiteManager
aSQLiteManger is my SQLite manager for Android.
Support development by buying the donate version (and be the first to get the new features).
You can
Open databases from within aSQLiteManager and from a number of file managers.
List tables, views and indexes.
Display data, structure and definitions SQL for tables and views.
Execute any SQL including 'Drop' / 'Create' statements (simple SQL builder included).
Add and edit records from data browser (Add button at title / Edit button at each row).
Copy the content of any cell to the clip board by clicking at it
Store all executed statements in the opened database (in a table called aSQLiteManager).
Select SQL history from query form.
Begin transaction, Commit and Rollback.
Export database to SQL script and restore databases from script.
Export to ASCII file of query results.
Execute SQL scripts, full script or single lines.
SQLite does not validate data types during data entry but aSQLiteManager set the Android input mode reflecting the field types.
Create database wizard.
Configurable font size in data lists.
Easy editing of databases located in a "Dropbox" folder
Secure editing of all databases on rooted phones with the donate version or through aShell.
Now translated to
German - thanks to Denis Dogan
French – thanks to Jean-Luc Rostini + Nicolas Gourdon
Italian – thanks to Giuseppe Tumino https://play.google.com/store/apps/developer?id=Giuseppe+Tumino
Catalan – thanks to Paco Rivière
Brazilian – thanks to Leandro Lopes
Spanish – thanks to Gonzalo Rodriguez
Permissions
- modify or delete the contents of your USB storage
- test access to protected storage
Comments
- I tried several of the SQLite database tools available on Google Play, and this one (aSQLiteManager) was my favourite. It makes it surprisingly easy to edit large database tables on a tiny screen. It has a very useful feature to save any SQL queries that you run so that you can re-run them again in the future (you can even edit those queries since they're stored in their own SQLite table).
- Very useful for updating a database on the go. However, i often want to tweak the schema of my database or do other edits best done in a text editor on the SQL dump file, so i export and restore my database a lot. Restore is very slow for me, so it would be great to see a progess indicator for it instead of a simple exhortation to be patient...
- Worked perfectly on my Tmo version of Samsung Gallaxy Note. Downloaded it to edit delete and remove the useless factory loaded and protected bookmarks (like the Tmo store) in the Adroid web browser. Had to also download the Ashell addon app for this to edit a system file and of course phone had to be rooted.
- I was surprised by the good support. I've asked for a bug fix and got a fixed version later the day!
- This app is very useful for android developers when they are testing data functions. Well done.
- This is by far the best sqlite app for people who love to use databases on the move.Well done!
- This enables me to inspect and fix databases used by other apps.
- Comes in handy. Wish I could sort the output.
- Works very well for my needs. LG Vortex CM7
- Excellent tool. Needs a tasker plugin :)
Related apps
aSQLiteManager
Price:FreeDownloads:50,000-100,000Rating:4.5 (680)aSQLiteManger is my SQLite manager for Android. Support development by buying the donate version (and be the first to get the new features). You can: Open databases from within ...
aSQLiteManager Donate Version
Price:kr 9,98Downloads:10-50Rating:4.8 (6)This is the donate version of aSQLiteManager my Android SQLite database Manager / front end. If you buy this version you will: 1) Support the development of aSQLiteManger 2) Get ...
aSpatiaLiteManager
Price:FreeDownloads:100-500Rating:5 (7)This an experimental build of aSQLiteManager 3.5 (I know that version aren't out yet) with some SpatiaLite support. From the Query Viewer you can do spatial queries. It can be ...
aShell
Price:FreeDownloads:10,000-50,000Rating:4 (87)aShell only allows you to edit any SQLite database on your ROOTed Android device with aSQLiteManager. aShell has NO use without aSQLiteManager With the donate version of ...
