AAA - Andsens Android Applications


aSQLiteManager

Google+ fora for aSQLiteManager

aSQLiteManger is my open source SQLite manager for Android. You can find the latest production version on Google Play and be notified when new versions is available.

If you like this app and find it useful you can support it by donating and help keeping it free and free of adds ;-)

If you have wishes for new functionality - send me a mail. Some of the suggestions I see on the comments I receive when the app is rated have been implemented or I might need to ask some questions to understand exactly what is needed.

All comments and request for new functionality are wellcome!

News

27 June 2014 - Version 4.5 released as donate version

  • Refresh data the table view
  • Queries and other potential time consuming tasks now run in thread
  • Can now display BMP-files stored in blob fields
  • Can be set up to ask for confirmation before copy cell value to the clip board
  • Open last (non system) database opened from the recent database list when app is opened
  • A few bug fixes as:
  • Create table wizard now allows editing of fields
  • Views now sorted

19 January 2014 - Version 4.4 released both as donate and standard version

  • Better handling of super users
  • Added android.permission.ACCESS_SUPERUSER as the app if granted super user privileges on rooted phones allow the user to modify system databases. This has no effect on not rooted phones.

10 December 2013 - Version 4.3 of the donate version is released on SlideMe to make it available for those of you who does not use GooglePlay. In the near future my other app's will appear there as well

20 nevember 2013 - Version 4.3 of aSQLiteManager released on Google Play as the donate version.

  • Now the record editor works with "primary key autoincrement not null"
  • Explore bitmaps BLOBS (png, jpeg, gif87a or gif89a)
  • CSV export now works with filters
  • Option to include field names in CSV exports
  • Filter now includes the "is null" and "is not null" operators
  • Editor can now be configured to use false/true or 0/1 for boolean values. Note that if this option is changed and you edit a database where boolean values are stored otherwise data becomes mixed. So use with care!
  • If you tap on a system catalogue from the standard file picker on a rooted device you are asked if you want to open it with the root file picker

13 october 2013 - Version 4.2 of aSQLiteManager released as the donate version

  • Now system databases can be opened from recent files
  • User defined colours in data grid
  • Reset data grid colours to default
  • Root file picker works with symbolic links to catalogues

28 August 2013 - Today aSQLiteManager has been downloaded more than 100,000 times (and the donate version more than 100 times).

12 may 2013 - Version 3.6 released on Google Play

  • New file picker with:
    1. Show file names, sizes, dates and icons
    2. Sorting (name, extension, size, date - ascending, descending, ignore case) and filtering of files (e.g. .sqlite;.db) in file picker
    3. Favorites directories for fast navigation to often visited places
  • Now the user dictionary are updated with your words
  • CSV export wizards that allows export of user selected fields
  • CSV import wizards that allows the user select a CSV file and which column from the CSV file to import into which fields in the current table.
  • Bug fixes - I think all reported bugs have been fixed. The support for editing views with on update triggers is better but the sloppy handling of field types makes this difficult as it is hard to figure out whether or not a field must be hyphenated during comparison. Thanks to all of you reporting and helping solve bugs!

4 april 2013 - Now it is possible to translate the app online. I am using the PHP Android String Translation Tool (PASTT) so now it is easy to enhance and update the translations. To update a translation or stat a new translagetin go to the aSQLiteManger translation page!

13 october 2013 - Version 4.2 of aSQLiteManager released on Google Play as the donate version. If you buy this version you will:

  • Support the development of aSQLiteManger
  • Get more frequent updates
  • Be among the first to get the new features implemented in aSQLiteManager
  • Support editing of system databases on rooted phones
  • New file picker with:
    1. Show file names, sizes, dates and icons
    2. Sorting (name, extension, size, date - ascending, descending, ignore case) and filtering of files (e.g. .sqlite;.db) in file picker
    3. Favorites directories for fast navigation to often visited places
  • Export wizards that allows export of user selected fields
  • Import wizards that allows the user select a CSV file and which column from the CSV file to import into which fields in the current table
  • Now the user dictionary are updated with your words
  • Bug fixes:
    1. CSV export - nulls and special table names are now handled correctly

14 March 2013 - Now more than 80,000 downloads of aSQLiteManager

28 february 2013 - Version 3.5.1 of the donate version released on Google Play. The donate versions differs from the open source version by:

  • Better support for small devices
  • Bug fixes

3 february 2013 - A donate version of aSQLiteManager 3.5 released If you buy this version you will:

  • Support the development of aSQLiteManger
  • Get more frequent updates
  • Be among the first to get the new features implemented in aSQLiteManager

3 february 2013 - Version 3.5 released on Google Play

  • Load and extract data from BLOB fields from / to file
  • Simple export of data on CSV format from table viewer
  • Simple import of data on CSV formatted file from table viewer
  • New and more advanced (I know - it don't say much) filter builder to filter data in the TableViewer
  • SQL Editor in Query viewer now shrinks to a configurable number of lines when not in focus

7. january 2012 - Now more than 70,000 downloads of aSQLiteManager

5. january 2013 - Published a experimental build of aSQLiteManager aSpatiaLiteManager on Google Play. If you work with spatial data try it and let me know what you think. In aSpatiaLiteManager the Query Viewer allows you to do all the SpatiaLite supported spatial queries.

28. december 2012 - Have created a Google+ fora for aSQLiteManager. Here you can get news about aSQLiteManager, ask questions and request new features

24 november 2012 - Version 3.4 released on Google Play

  • Default values also works from the record editor when the field is NOT NULL
  • Better handling of views with with instead of insert, update and delete triggers
  • Special table names now works with the record editor during updates and insert
  • Trigger and index definitions now exported when table dumped and database exported
  • Now also wrapping of long texts in queries
  • Remember path to last new database, last opened database and last opened SQL file

25 october 2012 - More than 60,000 downloads from GooglePlay

19 august 2012 - Version 3.3.1 released on Google Market

I am sory to say it but I introduced a bug in version 3.3. When I made it possible to insert text with quotation marks the app no longer could handle field names with spaces and field names like "on". This is solved in this release. There have also been time for a few extra features / enhancements, and a few other bug fixes.

  • In record editor table name are moved above the edit field
  • In record editor the back button are now ignored to prevent discard of data by accident
  • Maximal width of fields in data grid can now be configured to wrap long text to several lines. If max width is set to 0 (default) long fields will not be wrapped

Currently aSQLiteManager is translated to English, Danish, German, French, Italian, Catalan, Brazilian, and Spanish. More translations welcome!

Known problems

If you experience problems with aSQLiteManager please report it from the phone or by sending me a mail.

aSQLiteManager screen dumps!

The following screen dumps shows what is possible on the aSQLiteManger. Click on a image to see it in full size. This includes images from a not yet released version.

Read more about SQLites savepoints here.

And all about the SQL understod by SQLite here.

Implemented functionality

The following functionality has been implemented in the SQLite manager (with indication of from which version the functionality was introduced):

  • Open databases from within aSQLiteManager and from some file managers (at least from OI File Manager, in Adao Teams File Manager and in Simplest File Manager) (1.0)
  • List tables, views and indexes (1.0)
  • Display data from tables and views (1.0)
  • The content of any cell clicked on are copied to the clip board (1.0)
  • Execute any SQL including 'Drop' / 'Create' statements (1.0)
  • Store all executed statements in the opened database (in a table called aSQLiteManager) (1.0)
  • Select SQL history from query form (1.1)
  • Begin transaction, Commit and Rollback (1.1)
  • Export database to SQL script and restore databases from script (1.1)
  • Export to ASCII file of query results (1.1)
  • Configuration of open database without question and reset of configuration (1.1)
  • Execute SQL scripts, full script or single lines (1.2)
  • Better error handeling during export and restore (1.2)
  • Data editing form table browser from Edit button at each row (1.2)
  • Data entry add record from button on title at data browser (1.2)
  • SQLite does not validata data types during data entry. aSQLiteManager translates this string into the following types and se 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)
    • BLOB - for the time beeing the aSQLiteManager editor does not handle BLOB fields
  • Dump table from table view to file named Database.Table.sql- can be loaded by execute file as script (2.0)
  • Remember recently opened databases for quick access to often used databases (2.0)
  • BLOB fields no longer causes exceptions. But BLOB fields can not be added / altered (2.0)
  • SQL now saved in Query view (2.1)
  • Now works from aShell (2.2)
  • Database info (2.3)
  • Support table names and field names with spaces (2.4)
  • Fields in the table viewer are now colored based on the type of the field. As SQLite doesn't has field type validation the field type can differ from field type given with the create table statement (2.4).
  • Tables containing BLOB fields can be exported but NOT importet (2.4)
  • Now you get a SQL error if you enter invalid data during edithng of records (2.4)
  • Backup and restore of tables with BLOB fields (2.5)
  • Easy delete of records from the table viewer - press Edit(2.5)
  • Backup and restore of tables with BLOB fields (2.5)
  • List of implemented functionality on the Help screen (2.5)
  • First / last page in table viewer (menu First / Last) (2.6)
  • Simple filter option in table viewer (menu Filter) planning to extend this with a filter builder (2.6)
  • Editing FK using selections list of FK values (2.7)
  • Logging can be turned on / of to collect log data to help me locating bugs (2.7)
  • Orientation of main screen can be configured (2.7)
  • Tool to create new databases with PK, ASC / DESC, AUTOINCREMENT, not null, unique, default values, foreign keys and check for field type (3.0)
  • Easy deletion of tables, views and indexes from lists in database viewer by "long clicking" the table / view / index (3.0)
  • Foreign key constraint checking can be turned on (Android default is off) (3.0)
  • Now works in landscape mode (3.0)
  • Go directly to favourite view in table viewer (Fields or Data) (3.1)
  • Configurable font size in data lists (3.1)
  • Easy editing of databases located in a "Dropbox" folder (3.1) Doesn't work with DropBox versions > 2.1.7 ;-( Works again with DropBox version 2.2.1 ;-)
  • Select where to create a new database using a directory picker – thanks to Malte Heizelmann (3.2)
  • You get tips about what is possible in the different parts of the program (3.2)
  • Foreign key selection lists now show a string representation of the records not just the FK fields. The field that the foreign key refers to MUST be the primary key in the referenced table (3.2)
  • Select where to create a new database using a directory picker – thanks to Malte Heizelmann (3.2)
  • You get tips about what is possible in the different parts of the program (3.2)
  • Foreign key selection lists now show a string representation of the records not just the FK fields.
  • The field that the foreign key refers to MUST be the primary key in the referenced table (3.2)
  • A new CREATE TABLE wizard where entered fields can be edited / deleted (3.3)
  • Data entry / editor tool allow insert, update and delete on views with instead of insert, update and delete triggers (3.3)
  • Sort data in table viewer by clicking on title of column (3.3)
  • Font size in directory and table lists follow the font size of data grids (3.3)
  • Check if database exists before trying to open recently opened databases and removes deleted databases from the list (3.3)
  • Default values also works from the record editor when the field is NOT NULL (3.4)
  • Special table names now works with the record editor during updates and insert (3.4)
  • Trigger and index definitions now exported when table dumped and database exported (3.4)
  • Wrapping of long texts in queries (3.4)
  • Remember path to last new database, last opened database and last opened SQL file (3.4)
  • Load and extract data from BLOB fields from / to file (3.5)
  • Simple export of data on CSV format from table viewer (3.5)
  • Simple import of data on CSV formatted file from table viewer (3.5)
  • New and more advanced (I know - it don't say much) filter builder to filter data in the TableViewer (3.5)
  • SQL Editor in Query viewer now shrinks to a configurable number of lines when not in focus (3.5)
  • Support editing of system databases on rooted phones (4.0)
  • File picker sorting, filtering and favorites (4.0)
  • Extract / load BLOB data to / from mand file (4.0)
  • Export wizards that allows export of user selected fields (4.0)
  • Import wizards that allows the user select a CSV file and which column from the CSV file to import into which fields in the current table (4.0)
  • Import and export of tables with triggers (4.1)
  • Better handling of triggers during update with record editor (4.1)
  • Now system databases can be opened from recent files (4.2)
  • User defined colours in data grid(4.2)
  • Reset data grid colours to default(4.2)
  • Root file picker works with symbolic links to catalogues(4.2)
  • Now the record editor works with "primary key autoincrement not null"(4.2)
  • Explore bitmaps BLOBS (png, jpeg, gif87a or gif89a)(4.2)
  • CSV export now works with filters(4.2)
  • Option to include field names in CSV exports(4.2)
  • Filter now includes the "is null" and "is not null" operators(4.2)
  • Editor can now be configured to use false/true or 0/1 for boolean values. Note that if this option is changed and you edit a database where boolean values are stored otherwise data becomes mixed. So use with care!(4.2)
  • If you tap on a system catalogue from the standard file picker on a rooted device you are asked if you want to open it with the root file picker (4.2)
  • Explore bitmaps BLOBS (png, jpeg, gif87a or gif89a) (4.3)
  • CSV export now works with filters (4.3)
  • Option to include field names in CSV exports (4.3)
  • Filter now includes the "is null" and "is not null" operators (4.3)
  • Refresh data the table view (4.5)
  • Can now display BMP-files stored in blob fields (4.5)
  • Can be set up to ask for confirmation before copy cell value to the clip board (4.5)
  • Open last (non system) database opened from the recent database list when app is opened (4.5)

Unsorted idea's for the future versions:

  1. Better validation on data entry
  2. Implementation of some of SQLites . commands:
    • .import FILE TABLE - import data from file to table
  3. A script editor - with external editor?
  4. Searching
  5. Select where to save / load exports and dumps
  6. Create view wizards
  7. Real DropBox integration
  8. Google Drive integration

Any wishes for coming versions of aSQLiteManager? Drop me a mail!

Who is using aSQLiteManager (active installs 24. November 2012)

United States29.01% 5,229
Germany6.73% 1,210
Spain3.89% 699
United Kingdom3.68% 661
Brazil3.56% 640
France3.30% 593
Italy3.09% 555
Thailand2.74% 493
Russia2.63% 472
Others41.31% 7,426

When the aSQLiteManager binaries was on SourceForge India was the most downloading country. Now India is outside top 10 - I wonder why.

Old news

  1. 15 august 2012 - Reached 50,021 user installs from Google Play

  2. 8 ugust 2012 - Version 3.3 released on Google Market

    • 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
    • Bug fixes:
      • Welcome and Tip screens now works with with with change in orientation
      • Table definitions shows triggers regardless of case
      • Data entry / editor tool now handle strings with quotation marks
      • Paging and filter are no longer reset during rotation of device
  3. 17 july 2012 - Now more than 45,000 total user installs from Google Market

  4. 11 june 2012 - Now more than 40,000 total user installs from Google Market

  5. 30 may 2012 - Version 3.2 released on Google Market
    • Select where to create a new database using a directory picker – thanks to Malte Heizelmann
    • You get tips about what is possible in the different parts of the program
    • Foreign key selection lists now show a string representation of the records not just the FK fields. The field that the foreign key refers to MUST be the primary key in the referenced table
    • More checking in create table wizard
    • Hopefully back on the French version of Google Play (I had placed an unfinished French translation in a wrong place)
    • French translation – thanks to Jean-Luc Rostini + Nicolas Gourdon
    • Italian translation – thanks to Giuseppe Tumino
    • Catalan translation – thanks to Paco Rivière
    • Brazilian translation – thanks to Leandro Lopes
    • Spanish translation – thanks to Gonzalo Rodriguez
    • Several bug fixes – thanks for reporting!
  6. 15 April 2012 - Version 3.1 released
    • Get table definitions mowed to option menu and replaced with “New” record button for easier data entry
    • 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
    • Better database handling
    • Bug fixes
  7. 25 January 2012 - Version 3.0 released
    • A tool to create new databases with PK, ASC / DESC, AUTOINCREMENT, not null, unique, default values, foreign keys and check for field type.
    • Easy deletion of tables, views and indexes from lists in database viewer by "long clicking" the table / view / index
    • Foreign key constraint checking can be turned on (Android default is off)
    • Better database handling hopefully giving fewer errors / force closes
    • Now works in landscape mode
    • Better testing of databases on opening
    • Bug fixes
  8. 7 December 2011 - Version 2.7 released
    • Bug fixes (including create table problems on Android 3 devices) and a few new features:
    • Main screen orientation can be configured
    • Editing foreign key fields using selection list based on foreign key values (experimental and must be turned on in configuration)
    • Logging can be turned on to collect informations about bugs (use aLogViewer and filter for aSQLMan)
  9. 18 October 2011 - Version 2.6 released
    • Quite a few includes bug fixes and a few new features:
    • Main screen now always in portrait
    • First / last page in table viewer (menu First / Last)
    • Simple filter option tin table viewer (menu Filter) planning to extend this with a filter builder
  10. 12 September 2011 - Version 2.5 released.
    • Export and restore tables with BLOB fields
    • Now records can be deleted (or edited ;-) ) by pressing Edit in the table viewer
    • Most of the functions are listed at the Help screen
    • Bug fixes
  11. 25 August 2011 - Version 2.4 released
    • Now support table and field names with spaces
    • Colours in table viewers data grid showing the type of the fields (SQLite's dynamic type system)
    • Tables with BLOB fields can be exported (but not imported).
    • Catch errors on updates and inserts and tell what went wrong
    • Quite a few bug fixes
    • I can see in the crash reports I get that some of you have problems with showing tables with BLOB fields. I can't reproduce that error so please send me more information about the problem!
  12. 3 August 2011 - Version 2.3 released Progress bar during export of databases, New Database info menu in Database viewer. Bug fixes.
  13. 13 July 2011 - Version 2.2 release Minor change to be able to work with aShell.
  14. 8 July 2011 - Version 2.1 release Quite a few bug fixes and SQL in query builder now saved on exit and reloaded on start.
  15. 12 June 2011 - Version 2.0 Better error handling, remenber recently opened databases and dump of single table to SQL file
  16. 9 June 2011 - aSQLiteManager now available from Google Market
  17. 27 May 2011 - The homepage has been updated with a lot of screen dump showing how to use the aSQLiteManger.
  18. 22 May 2011 - Version 1.2.2 released. This version solves the problems with displaying data from views. This version also includes a welcome screen with news about current version.
  19. 8 May 2011 - Version 1.2 has been released. This includes scripts and editing of records in table mode (including a preliminary validation).
  20. 19 April 2011 - a β of version 1.2 has been released. This includes scripts and editing in table mode. The β is available from the file section at SourceForge

aSQLiteManager is hosted by SourceForge.net QR CodeAndroid

This Andsen page was last updated in october 2013