SQLite Magic

Main description of SQLite Magic:

This applications allows you view/modify 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.

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.

Screenshots

SQLite Magic

SQLite Magic

Main screen

List of tables (menu)

List of indexes

List of views

List of triggers

Table info (menu)

List of columns

Column info

Edit / New column

Table constraint info

Edit / new constrain

View info

Edit / new view

Trigger info

Edit / new trigger

Data grid (menu)

Edit / new record

Data filter

Export data

Data grid (sorted, multiselect)

SQLite versions

SQLite Magic Rel. 1.6.1

• fixed ‘Scan for DB’

[expand title=””]SQLite Magic Rel. 1.6.0

• added possibility to import from CSV
• updated Adobe AIR SDK to 14.0.0.178
• fixed fonts in Start view
• updated ‘Application size’ range from 50% to 150%
• updated dump table, dump database, export CSV and import CSV. Shows dialog ‘Working’ now
• small design improvements
• fixed minor bugs

SQLite Magic Rel. 1.5.1

• upgrade Adobe AIR SDK to 14.0.0.137

SQLite Magic Rel. 1.5

• optimalized history of sql commands in ‘SQL Run’
• added button ‘Delete All’ to ‘SQL Logs’
• updated AIR SDK to 14.0.0
• removed permission : READ_PHONE_STATE
• fixed datatime type, now is possible to set NULL value
• fixed hardware button Back in ‘Scan for DB’
• fixed ‘Dump database’ and ‘Dump table’. Remember settings after come back from ‘Directory browser’ now
• fixed Load file in ‘SQL Run’

SQLite Magic Rel. 1.4

• fixed ‘Scan for DB’ lags
• small design improvements
• improved data grid, add horizontal slider to change scale of data grid

SQLite Magic Rel. 1.3

• add possibility to show basic types on new/edit column dialog
• small design improvements
• improved dialog for creating backup file
• add button : Inform Author in case of parser failed : send sql to author by email
• improved ‘Scan for DB’
• fixed new/edit ‘Foreign Key’ dialog
• fixed ‘Select column’ dialog
• fixed new/edit record dialog
• fixed index parser
• fixed parsers for column type : LONGVARCHAR

SQLite Magic Rel. 1.2

• improved modal dialogs
• improved Settings : Add possibility to switch on/off question of creating backup
• optimalized Data Export : Change extension to CSV
• improved SQL Logs : Add COPY to Clipboard
• improved SQL Browser : Add PASTE from Clipboard, add possibility to create CSV, add history, add sql extensions
• optimalized backups
• optimalized search of file
• optimalized application size
• resolved an issue where some ads may not be able to display on some android devices

SQLite Magic Rel. 1.1

• add possibility to create/restore backup of database
• updates internal android sdk to Google Play 4.4
• remove dependency on external adobe air download

SQLite Magic rel. 1.0

• The SQLite Magic release 1.0 was published and downloadable on Google play.

[/expand]