Profile cover photo
Profile photo
aSQLiteManager
52 followers -
News and info about aSQLiteManager
News and info about aSQLiteManager

52 followers
About
aSQLiteManager's interests
aSQLiteManager's posts

Version 5.0 of the donate version now on Google Play. I have been rather busy but now I have some time again. Next step i to update the standard version to version 5.0.
/Martin

The app can't edit empty BLOB field (as they are just treated as any other empty fields) but by defining the BLOB field with a default value at X’’ SQLite will see the field as a size 0 BLOB field with no data and you can edit the content of it.

CREATE TABLE BlotTest (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
BlobField BLOB DEFAULT X’’,
BlobType TEXT)

/Martin


Post has attachment
Version 3.5.1 of the donate version has been released on Google Play. It has better support for small devices and a few bug fixes.
Right now I am implementing a new file picker showing the files size and data and with support for sorting and filtering. 
On the screen dump you see databases (*.sqlite and *.db) sorted after date descending.
Hope to have it out soon!
/Martin
Photo

A donate version has also been released. Buy it to support the development - and to be among the first to receive updates. 

Version 3.5 have now been released on Google Play.
You can now:
Change the content of BLOB fields by tapping on them.
A more advanced filter builder.
The SQL editor fields now scrinks when you execute the query and allows you to see the data grid.
Simple import / export of data to CSV files. The number of fields in the CSV file must not be larger than the number of fields.
/Martin

Post has shared content
Hi,
What phone and Android are you using? I have tried the app on HTC Desire, Samsung XCover, Samsung Siii, Samsung Tab (I+II), Samsung Note (I+II) and Asus eeePad Transformer. Android 2.2, 2.3, 4.1 and 4.2.On all none of  them I get thevertical black line between the columns. It looks like the space between the columns becomes black lines not space...
/Martin
Some feature requests:

1) Improve the clarity by adding some spacing between columns (as shown in the image below)

2) Make the table header fixed so scrolling doesn't lose the header, similar to Excel's fixed headers (a non-trivial problem to implement :-) )

3) Improve the performance when using page sizes of 100+  It takes a while to draw the page using page up/page down.

Also, it might be worth thinking about a paid/premium version as I see SQLite Editor has 50K downloads at $4 a pop. Your version is much better and you should be rewarded.  (https://play.google.com/store/apps/details?id=com.speedsoftware.sqleditor)
Photo

Spatial data.
If you work with spatial data and Android you might want to try this app:
https://play.google.com/store/apps/details?id=dk.andsen.aspatialite
It is an experimental version of aSQLiteManager with SpatiaLite support. You can do spatial queries from the Query Viewer.
Martin

Save data from BLOB field to sdCard

Load data from sdCard to BLOB field

Support for spatial queries using spatialite
Make it possible to handle spatial data and do spatial queries from aSQLiteManager
Wait while more posts are being loaded