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
1328
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.

Visit Website
User reviews of aSQLiteManager
Write the first review for this app!
Android Market Comments
A Google User
Sep 9, 2014
Phew... Not it's so easy
A Google User
Sep 2, 2014
Great database editor Easy.. very useful. Thanks
A Google User
Aug 24, 2014
Crashes Nexus 5, KitKat 4.4
A Google User
Aug 22, 2014
Great with minimal permissions Useful for examining database and correcting errors. Does not allow correction in some cases. Edit is per row instead of more complex SQL filtering. Would love per data editing by long click/touch of that data. Like the touch to copy data to clipboard feature. Perhaps, long click on data to bring up context menu eg edit data, edit row, etc. Await more customization.
A Google User
Aug 19, 2014
Good, fast execution, easy to use. Executes my legacy SQLite queries. Export to CSV is good, but does not export field names (heard that donate version does); does surround text with quotes making data easier to import to other applications. Font size, saving queries etc... all in Options. Would be good to be able to choose light/dark display. Good response from developer.