Apr 30
The SQLite Sorcerer, in its v1.2, now provides the ability to create and open encrypted databases. To reencrypt them also. Here is how the feature is addressed in the tool.
(No Ratings Yet)
Loading ...
(No Ratings Yet) Loading ...Apr 11
AIR provides additionnal SQL features to support local SQLite databases. For example: dates.
So you can store dates directly in your SQLite database with no formatting. I think that pure SQLite databases would store dates in a text field after a transformation (to ISO format for example).
This is great but I had real difficulties to define a query with dates in the WHERE clause in all SQLite AIR admin tools.
After a few googling sessions and some tries in my SQLite Sorcerer, I found a way that works well.
select * from orders where date(creationdate)>"2009-03-01"; |
Dates that are stored and retrieved by AIR have to be converted using the date function in the WHERE clause of the query. You can also add modifiers as localtime for instance.
This is maybe obviously obvious for SQL gurus but really not for me, so I wanted to share the information.
(No Ratings Yet) Loading ...
Apr 11
After huge spam attacks, my site has been closed by my stupid and lazy hoster…now back online, with no more comment. I have to restore my last backup but some comments will be lost… sorry Jeff, Kolian…
And sorry for all those who tried to connect and use my differents online apps as GradientCanvas Style Explorer for instance.
Regards
(No Ratings Yet) Loading ...
Apr 07
I am proud to publish today the first public version of the SQLite Sorcerer, a new administration tool for SQLite databases, written in Flex 3 for Adobe AIR.
(1 votes, average: 5 out of 5) Loading ...
