aSQLiteManager

aSQLiteManager Free App

Rated 4.41/5 (2,664) —  Free Android application by Andsen

Advertisements

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

How to Download / Install

Download and install aSQLiteManager version 4.7.1 on your Android device!
Downloaded 100,000+ times, content rating: Everyone
Android package: dk.andsen.asqlitemanager, download aSQLiteManager.apk

All Application Badges

Good rating
Free
downl.
Android
2.2+
Bug
buster
For everyone
Android app

App History & Updates

What's Changed
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
Version update aSQLiteManager was updated to version 4.7.1
Version update aSQLiteManager was updated to version 4.4.2
More downloads  aSQLiteManager reached 100 000 - 500 000 downloads
Version update aSQLiteManager was updated to version 4.4.1

What are users saying about aSQLiteManager

I70%
by I####:

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.

C70%
by C####:

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.

U70%
by U####:

Nice & simple. No eye candy, which is refreshing these days & presumably keeps this app light on resources. Feels like lots of questions on startup - could be streamlined I think. Not yet committed to it, but keep dabbling. Keep up the good work.

C70%
by C####:

But why does it have to be so dark? Plus I could not find how to edit the table, once created and how do i set PK or FK? When creating a table i can only change the field type.

C70%
by C####:

By far one of the best i have come across. I will keep this in my arsenal, to troubleshoot any obstruction i may encounter .

C70%
by C####:

This one in great that I can see the views also with tables, but it doesn't detects changes in previously opened database. I am opening the mediastore external database on a rooted phone using open option, but it doesn't detects changes in database even after closing and opening. If I copy the database to computer and check, I can see the changes.

K70%
by K####:

Getting syntax error while creating a table.

C70%
by C####:

When opening any database, the app returns a error: "-tmp-mksh: [...] no such file or directory". cp did not solved the problem and this phone does not have ext storage. Changing the temp path to "/sdcard/aSQLitemanager" fixed the error.

Z70%
by Z####:

This app doesn't work I tried. To edit my games and it said error Plz. Fix it and let me no win u do.

B70%
by B####:

Database manipulation come handy. Export to or import from CSV or SQL. Backup before processing and others great tools. And this app is function properly.. thanks dev..

C70%
by C####:

I may not be testing this thoroughly as i just wanted to edit some app databases, but it is the best and easiest to use db app that i have found.

H70%
by H####:

Only thing I would like is to be able to clone a field from the previous record in the database without going thru the whole "edit field, delete the data, type the new data, save" sequence. Something similar to the Ctrl" function in Microsoft products on my PC.

Z70%
by Z####:

When ever i *HACK* it some time doesn't work so fix it please *THANK YOU*

C70%
by C####:

Cannot open a reсent database if root access is required. Settings are inacсessible inside DB view so you need to close DB to change font or page size.

C70%
by C####:

But it has many bugs, I gave 4 stars just because others are worse

C70%
by C####:

I would give 5 if you done every app but on nebulousI am level 79000 thanks to you tysm

C70%
by C####:

I Use It For My Application Development And It Is A Very Big Help. Thank You So Much

C70%
by C####:

Good for intended purpose. But UI can be improved (it doesn't have issues, but should look good)

C70%
by C####:

I bought the paid version. It claims it can import csv files. I don't see how to do that with this app. (and if anyone is wondering, I know how to import csv files.)

C70%
by C####:

Great app, but. It would be nice if you could select all records for delete after applying filter.

H70%
by H####:

Bug. When I click OK in edit mode but i get delete my current selected record.

F70%
by F####:

Found it useful in its minimalistic approach of presenting and accessing database. In hasn't been updated for quite some time.

C70%
by C####:

Works well, but would be better if you could save multiple queries though.

R70%
by R####:

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.

R70%
by R####:

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

R70%
by R####:

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

R70%
by R####:

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

P70%
by P####:

Just a request, maybe you can enable loading a BLOB (images) on BLOB types if you create the entry yourself. By default it is null and you cannot edit it unless there is already an existing BLOB.

Q70%
by Q####:

Can you do something about scaling your views correctly for a tablet? I get micro fonts, and check boxes I can't set. Can't use the config screen. Can't do anything...very frustrating. One star for encouragement...

L70%
by L####:

"""Hello"" Dear",""Hello"" Dear,Hello ""Dear"" is imported as |Hello" Dear|Hello" Dear|Hello "Dear"| whereas desired is |"Hello" Dear|"Hello" Dear|Hello "Dear"| Also crashes when Large text exist in a cell that belongs to BLOB type.

R70%
by R####:

This app helps me, in trouble shooting app data very quickly.

R70%
by R####:

Mostly it does what it says on the tin. It's a lightweight db manager. However it lacks support for some features like creating a table with constraints. (It's still possible to achieve the same result using a raw query.) Also the interface can get annoying; for example the Edit button can be so small it's hard to press.

R70%
by R####:

Nice app. Helps me deal with my DB files.

R70%
by R####:

Works well and is open source too. Great work!

U70%
by U####:

Import and export functions with customizable options - I like best

V70%
by V####:

Best sqlite manager simply working great. Filters are not working

R70%
by R####:

Thus is what i was looking for. Thanks to the developers

R70%
by R####:

But UI is a bit dodgy. Not intuitive.

R70%
by R####:

And its FREE so give thanks

R70%
by R####:

simple and useful


Share The Word!


Rating Distribution

RATING
4.45
2,664 users

5

4

3

2

1