SQLite Magic

SQLite Magic Free App

Rated 3.62/5 (192) —  Free Android application by iPoint Slovakia

Advertisements

About SQLite Magic

The real SQLite Editor.
This applications allows you view/modify data and structure of SQLite Database on Android. Create and modify structure of tables, views, indexes, triggers, table’s constraints and foreign keys in SQLite database, edit and delete records in SQLite database. This application does not support root access.

In more detail using this application user can:
-create, modify, delete, rename, dump tables,
-display tables’ s and views’s data in scrollable grid,
-create, modify, delete, export records,
-support multiselect on records,
-sort and filter records on any field value,
-export filtered data to CSV files (included custom separators),
-create, modify, delete columns in table (including columns’s constraints and foreign keys),
-create, modify, delete table’s constraints (including foreign keys),
-create, modify, delete table’s indexes,
-create, modify, delete table’s triggers,
-create, modify, delete views,
-execute SQL scripts,
-export database to SQL script,
-restore database from SQL script,
-store executed statements to history,
-browse and edit databases on SD card,
-scan SD card for existing databases,
-configurable application’s size,
-remember recently opened databases.

How to Download / Install

Download and install SQLite Magic version 1.9.1 on your Android device!
Downloaded 10,000+ times, content rating: Everyone
Android package: air.SQLite.Magic, download SQLite Magic.apk

All Application Badges

Free
downl.
Android
2.3+
Bug
buster
For everyone
Android app

App History & Updates

What's Changed
-Added 'Application size' for screen DPI more like 400
-Updated Adobe AIR SDK to 21.0.0
-Fixed CVS import
Version update SQLite Magic was updated to version 1.9.1
Version update SQLite Magic was updated to version 1.9.0
Version update SQLite Magic was updated to version 1.8.0
More downloads  SQLite Magic reached 10 000 - 50 000 downloads

What are users saying about SQLite Magic

A70%
by A####:

This is an almost perfect app for constructing, reading, updating, and deleting SQLite databases and tables. This app DOES NOT USE MATERIAL DESIGN, so it is a but ugly, but it works well. Very little typing is required to build tables and columns. Only the names of columns require typing. There is also a built-in query builder, wtih all SQL keywords appearing as buttons that you press to enter. So if you know SQL, you can perform absolutely any kind of SQL query, regardless of how complex it may be. Entering information into tables is much like entering data into a spreadsheet. Your tables are saved in ordinary SQLite files, so you can move them from device to device freely. You can really create very complex databases. It is good for experimenting with ideas in your free time, if you are a SQL software developer.

X70%
by X####:

Unable to browse db. It is just showing pds directory in root (/) directory. Unable to go to parent directory (..). Though using scan db I can open my db. But scanning also skips external sdcard.

P70%
by P####:

Best looking of the SQL managers, but refuses to open tables with spaces in the name, and doesn't parse column names that include spaces properly.

B70%
by B####:

Might be cool for development. Nut im mot looking for that

X70%
by X####:

Why does it need phone id & call log permission?

Q70%
by Q####:

Unable to browse db. It is just showing pds directory in root (/) directory. Unable to go to parent directory (..). Though using scan db I can open my db.

Y70%
by Y####:

It has slow and ugly UI. But the functionality is good.

A70%
by A####:

Nice app, but column width of the displayed table canmot be resized individually.

Q70%
by Q####:

extremely clumsy as form doesn't auto-scroll as fields are added (that's a deal killer for me). Otherwise, shows promise, will check out future versions.

Q70%
by Q####:

Can't recognise I'm rooted so can't view system dB. Really? In this day?

Q70%
by Q####:

Wher is sql statmentes Between, join . Inner join...... and more are not found

Q70%
by Q####:

Very slow interface

Q70%
by Q####:

Doesn't allow me root privileges to my data folder

L70%
by L####:

1. CSV import is limited to 102 columns only. Rest of the columns are simply ignored. 2. In edit mode BLOB data should be available as "upload or download BLOB as file". Waiting to give 5 stars after these changes.

O70%
by O####:

Ok good

I70%
by I####:

I like everything except one item, in which makes this app totally unusable for me. I am 56 years old, and when I cannot read text at 150% size, then this app is not meant to be used on a phone or small tablet. 300% might make the command screen readable, maybe.

Q70%
by Q####:

This is one of the best sqlite tools available. But I need one that supports root to work with the app that I am building. So it does not work for me :(

Q70%
by Q####:

Tried DOUBLE, DOUBLE PRECISION, FLOAT, and REAL. Can't use a minus sign in the value for any of them. Using SwiftKey keyboard, if that makes any difference. In fact, it crashes as soon as I enter a minus sign in a new row.

R70%
by R####:

It works but had to uninstall because the text was so small it was risky to use. If there is a setting to change the font size it needs to be in seeable too.

Q70%
by Q####:

Doesn't allow me root privileges to my data folder

Q70%
by Q####:

Thank you..

K70%
by K####:

Ok good

C70%
by C####:

I really wish more app developers (including this one) would offer a theme that is friendly to old, tired, eyes (e,g. bold white or yellow on black or dark gray).

C70%
by C####:

I like the app and the interface seems promising. It works as expected. How ever I don't like the part where you have to clear the whole query just to repair simple mistake in the text editor. I am on nexus 7 and the app query editor interferes with android screen keyboard(kind of not user friendly). Overall its OK 4/5 :-)

S70%
by S####:

Can't handle large number of rows. :-( Say,50k

Z70%
by Z####:

Ki ii. I .. Bariiiik aaaa a aa

R70%
by R####:

Why does it need phone id & call log permission?


Share The Word!


Rating Distribution

RATING
3.65
192 users

5

4

3

2

1