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.

SQLite Magic » SQLite Magic

SQLite Magic Rel. 1.6.1

[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

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

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

SQLite Magic rel. 1.0

[/expand]