aSQLiteManager

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 edit all databases on rooted phones.
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.
Import and export of CSV files
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
Now translated to:
Danish
English
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
Russian - thanks to Denis Bondarenko

Recent changes:
Better handling of editing of databases on rooted devices. You can now specify where to place temporary files. In some cases the path to the sdCard returned by Android is invalid in this case you can define it yourselves. In a few cases the ‘cat’ command fails to copy the database if this happens you can change the app to use ‘cp’ which is not always present.
Have added android.permission.ACCESS_SUPERUSER permission to allow super user access on newer version of Android.
Add to list
Free
89
4.5
User ratings
1479
Installs
100,000+
Concerns
0
File size
365 kb
Screenshots
Screenshot of aSQLiteManager Screenshot of aSQLiteManager Screenshot of aSQLiteManager Screenshot of aSQLiteManager Screenshot of aSQLiteManager
About 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 edit all databases on rooted phones.
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.
Import and export of CSV files
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
Now translated to:
Danish
English
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
Russian - thanks to Denis Bondarenko

Recent changes:
Better handling of editing of databases on rooted devices. You can now specify where to place temporary files. In some cases the path to the sdCard returned by Android is invalid in this case you can define it yourselves. In a few cases the ‘cat’ command fails to copy the database if this happens you can change the app to use ‘cp’ which is not always present.
Have added android.permission.ACCESS_SUPERUSER permission to allow super user access on newer version of Android.

User reviews of aSQLiteManager
Write the first review for this app!
Android Market Comments
A Google User
Dec 13, 2014
It does what it says.
A Google User
Dec 3, 2014
Superb Very nice program. Thanks for developing such a nice program. The vacuum command was useful to me.
A Google User
Nov 28, 2014
It does what it's supposed to do, could be better It works fine for casual editing, I like it a lot! But for development it lacks many features. The top most are: In table list there should be a number of records next to table name! In data view the row should be highlighted if I press my finger on the screen and trigger edit on long press. Or simply zoom the dataview (temporarily, I don't want to change font size to 25). Why? Because edit is a small target, with no hint I keep hitting one row up or down from my target. I also found a small bug: Open recent database doesn't work for databases needing root, it says can't find db.
A Google User
Nov 20, 2014
Very good for what it is! Excellent app to perform simple queries and db management. Thank you!
A Google User
Nov 17, 2014
Excellent SQL Manager I tried a couple of them and this one worked the best. It was easy to pinpoint what I was looking for. It works well for exploring & seeing the inner workings of the Android system.