SQLite Magic 1.9.1 Apk

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.

1.8.0
-Added possibility of 'contrast colors'
-Added menu (exit, settings) to each view
-Added possibility to change width of columns
-Export data to CSV supports 'text separator'
-Changed system of reset application data. Now is possible to reset each kind of application data separately
-'Application size' renamed to 'Screen Zoom'
-Small design improvements
-Fixed table's parser

1.7.0
-Added possibility to change datagrid's page size
-Added possibility to load/save datagrid's filters
-Fixed SQLRun scroller for software keyboard
-Fixed a bug where application could crash if an old version, or no version of Google Play Services is installed on the device
-Fixed table parser and added types : LONG(int) and STRING(text)

1.6.1
-Fixed 'Scan for DB'

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

1.5.1
-Upgrade Adobe AIR SDK to 14.0.0.137

1.5.0
-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'

1.4.0
-Fixed 'Scan for DB' lags
-Small design improvements
-Improved data grid, add horizontal slider to change scale of data grid

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

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

1.1
-add possibility to create/restore backup of database
-updates internal android sdk to GooglePlay 4.4
-remove dependency on external adobe air download