Android SQLite Manager / News: Recent posts

Version 3.3 released

A new CREATE TABLE wizard where entered fields can be edited / deleted
Data entry / editor tool allow insert, update and delete on views with instead of insert, update and delete triggers
Sort data in table viewer by clicking on title of column
Font size in directory and table lists follow the font size of data grids
Now check if database exists before trying to open recently opened databases and removes deleted databases from the list... read more

Posted by Martin Hansen 2012-08-03

Version 3.1

Version 3.1 submitted on Google Market
New features:
Go directly to favourite view in table viewer (Fields or Data)
Configurable font size in data lists
Easy editing of databases located in a "Dropbox" folder

Number of developers doubled - now two

Posted by Martin Hansen 2012-04-15

Version 2.1 released

Bug fix release:
NumberFormatException When displaying and editing records where rowId can not be stored in a Java int.
SQLiteException when trying to create new database in nonexistent path.
SQLiteException when trying to edit sqlite_master (can't be updated manually).
Minor improvements:
SQL in query viewer is now saved on exit and restored on load.
And the binary is here:
http://market.android.com/details?id=dk.andsen.asqlitemanager
Martin ;-)

Posted by Martin Hansen 2011-07-11

Version 2.0 released

Posted by Martin Hansen 2011-06-12

Version 2.0 released

This version is released on Google Market this allows automatic informations about updates and allows me to recieve informations about crashes.
News in version 2.0:
Tables can be dumped from "Table view" to SQL file (that can later be loaded by execute script)
Recent files - easy open recently opened databases (cleared on reset)
Number of recent files configurable
Bug when displaying and querying tables with BLOB fields fixed BLOB fields set to editable = false
Reset also restores the welcome screen
Export (to ASCII file) now don't throw exception if missing or invalid SQL but gives error
Messages after export and restore and better error handling in places

Posted by Martin Hansen 2011-06-12

Version 1.2.2 released

This release fix the paging problen when displaying data from views.
A news screen to displays news about current version on start up is added.

Posted by Martin Hansen 2011-05-22

Version 1.2.1 released

This version fixes a bug with displaying data from views. To those who has downloaded version 1.2 I am sorry for the inconvenient.
Martin

Posted by Martin Hansen 2011-05-08

Version 1.20 released

Version 1.20 includes:
Correctly scaling on the Galaxy Tab and hopefully on other large displays.
Open SQL files (from database view) and executed all or single line.
Error messages during restore and execution of scripts and statements.
Data editing form table viewer by using "Edit" button at each row.
New records can be added by using the "New" button in the table heading.
Input mode during editing and insert depends on the fields data type. SQLite uses a dynamic type system where field types can be given as any string aSQLiteManager translates this string into the following types and use this to set input mode (SQLite types i parenthesis). The translation is NOT case sensitive:
STRING (string, text), INTEGER (integer), FLOAT (real, float, double), DATE (date), TIME (time), DATETIME (datetime), BOOLEAN (boolean, bool), PHONENO (phoneno). aSQLiteManager does not handle BLOB.
Martin

Posted by Martin Hansen 2011-05-04

Version 1.20 beta available

Version 1.2β released
New features in this version:
Open SQL files (from database view) and executed all or single lines
Error messages during restore and execution of scripts and statements
Data editing form table viewer by using "Edit" button at each row
New records can be added by using the "New" button in the table heading
Input mode during editing and insert depends on the fields data type. SQLite uses a dynamic type system where field types can be given as any string aSQLiteManager translates this string into the following types and use this to set Android input mode to integer, double, string, date, time, date-time or phone number.
Download the beta here:
http://sourceforge.net/projects/asqlitemanager/files/aSQLiteManager/Version%201.20%20beta/aSQLiteManager.apk/download
Martin

Posted by Martin Hansen 2011-04-19

1,000 downloads of aSQLiteManager

To day - just after lunch danish time - aSQLiteManager was downloaded for the 1,0000 time and as one of the downloads was the Philippines aSQLiteManager has now been downloaded from 99 countries.
See the stats here:
https://sourceforge.net/projects/asqlitemanager/files/stats/map?dates=2010-10-15%20to%202011-03-22
Martin

Posted by Martin Hansen 2011-03-22

Version 1.10 released

aSQLiteManager has been has been extended with the following functionality;
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.
Restore of databases (table structure, views and data) from SQL script named databaseFileName.sql implemented.
Better file picker with different icons for folders, .sqlite, .db and non aSQLiteManager files.
Export of query result to ascii file databaseFileName.export.
Configuration of: Open databases from file managers and aSQLiteManager without question and Reset configurations to default.
Martin

Posted by Martin Hansen 2011-03-16

Version 1.10 beta available

Now a beta version of aSWLiteManager is available.
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. Download the beta here: http://sourceforge.net/projects/asqlitemanager/files/aSQLiteManager/Version%201.10%20beta/aSQLiteManagerBeta.zip/download
Martin

Posted by Martin Hansen 2011-02-27

Version 1.0 released first production version

Version 1.0
First production release of aSQLiteManager. No known bugs.
Planning further development, feature request welcome, could be:
Select SQL history from query form
Sort data / query results by clicking on title
Data entry and editing form - use editing button at each row

Posted by Martin Hansen 2011-02-06

Homepage updated

The project homepage http://asqlitemanager.sourceforge.net is updated to reflect version 0.81

Posted by Martin Hansen 2011-01-20

Version 0.81 released

In this version aSQLiteManager open 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 implemented

Posted by Martin Hansen 2011-01-17

Version 0.80 released

First beta version of aSQLiteManager released with the following improvements:
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

Posted by Martin Hansen 2010-12-27

Version 0.70 released

In this version the folowing features have been implemented:
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

Posted by Martin Hansen 2010-12-16

Version 0.60 released

This version allows you to execute any SQL scripts against the open database. This include drop table so handle with care - no regrets other than restore form backup possible.

Posted by Martin Hansen 2010-12-05

Homepage updated

Now the homepage contains informations about the current release. If you want the aSQLiteManager in your language translate this file (http://asqlitemanager.svn.sourceforge.net/viewvc/asqlitemanager/aSQLiteManager/res/values/strings.xml?view=log) and mail it to me.
Martin

Posted by Martin Hansen 2010-11-28

Version 0.50 released

Going fast foreward to version 0.50. You can now see tables, views, create script, and display data in tables and views.
Martin

Posted by Martin Hansen 2010-11-27

Version 0.11 released

Now able to display table data on a two way scrollable form
Otherwise like version 0.10

Posted by Martin Hansen 2010-11-21

First version released

Using this version you can open a database, se lists tables, views and index. For the tables you can see the followinginformations about the fields: name, type, not null, pk, default value.

Posted by Martin Hansen 2010-11-10