| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| aSQLiteManagerBeta.zip | 2011-02-27 | 63.2 kB | |
| readme-aSQLiteManager-1.10-beta.txt | 2011-02-25 | 3.2 kB | |
| Totals: 2 Items | 66.5 kB | 0 | |
Version 1.1β
Select SQL history from query form
Size of icons changed to right sizes for different displays
Better detection of valid SQLite databases (based on first 16-byte sequence)
Begin transaction, Commit and Rollback can be selected from option menu.
Transactions can be nested as savepoints in SQLite (is the first transaction
rolled back all updates are rolled back). aSQLiteManager ensures that SQL
statements are stored in the database even if updates are rolled back.
See http://www.sqlite.org/lang_savepoint.html for savepoint specifications.
Export of databases (table structure, views and data) to SQL script
named databaseFileName.sql implemented -- seems to work
Restore of databases (table structure, views and data) from SQL script
named databaseFileName.sql implemented -- seems to work
Better file picker with different icons for folders, .sqlite, .db and non
aSQLiteManager files
Export of query result to ascii file databaseFileName.export
Working on:
Executing scripts, open scripts in "editor / runner", saving scripts
Planning for further development, feature request welcome, could be:
Sort data / query results by clicking on title
Data editing form use editing button at each row
Data entry - add post from option menu in table browser
Implement some of SQLites .commands (.dump, .read fn.ft, ...)
Version 1.0
First production release of aSQLiteManager
No known bugs
Version 0.81
aSQLiteManager can be opened if a .sqlite or .db file is clicked on in
OI File Manager, in Adao Teams File Manager and in Simplest File Manager
Insert into SQL builder mode
A few bug fixed
Version 0.80
The first beta version of aSQLiteManager
More advanced SQL builder (for Select, Create view, Create table, Drop table,
Drop view and Delete from)
The sqlite_master table now included in list of tables and sorted by name
Create new database and open it
Headers on query results
Don't save the same SQL more than one time (unique constraints on SQL)
Index viewer
Version 0.70
Query result in data grid
Executed statements can be saved in current database in a table named
aSQLiteManager (configuration)
A simple SQL builder where tables and fields from the "select fields from tables"
part can be selected from two lists
Paging on Table and View data viewer implemented. Numbers of records to return can be
configured form option menu at the main form
Clicking on a field in the data browser copy the content to the clip board
A help screen with a little help, links and mailto
Version 0.6
Simple execution of SQL and display of result (for the time being as comma
separated lines in list)
Version 0.50
Display view data
Display create script for tables and views
Enhanced file picker (sorted list - directories before files and icons)
Two way scrolling data grid
Can be moved to SDCard
Later:
See triggers
Version 0.11
New in this version:
Can now display table data
Version 0.1
Now able to:
Browse SDCard and open a database
See tables, views and index
See table structure