Sep 08

With its version 1.2, the component Flex Notification can be stacked. This has been suggested by 2 of my visitors and I think this was a very good idea. So, this is now possible using a new property to use in the Notification.show() method. The property stackable is set to true by default, so by default, the Notification will be stacked.

Technical changes (you may have some compilation errors if you already use my Notification):

  • There is a new class called the NotificationStackManager which mainly count the Notifications
    • The NotificationStackManager is implemented as a Singleton.
    • You don’t need to deal with it, only the Notification sends counting information to the Manager
  • The 2 components (Notification and NotificationStackManager) have been placed in a package
  • The Notification.show() method changed as the stackable parameter can be set between the iconClass and the notificationParent parameters.

I hope this version will enjoy both current and futur users.

You can check an updated demo at the original post.

Have fun.

Flattr this

 

not goodquite goodgoodvery goodexcellent (2 votes, average: 4.5 out of 5)
Loading ... Loading ...

Written by Arnaud
Tags: , ,

Share/Save/Bookmark


Aug 28

The version 1.4 of the SQLite Sorcerer is just released !

Changes and more after the jump.

Continue reading »

not goodquite goodgoodvery goodexcellent (1 votes, average: 5 out of 5)
Loading ... Loading ...

Written by Arnaud
Tags: , , , ,

Share/Save/Bookmark


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.

Continue reading »

not goodquite goodgoodvery goodexcellent (No Ratings Yet)
Loading ... Loading ...

Written by Arnaud
Tags: , , ,

Share/Save/Bookmark


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.

dates in where clause query

 

This is maybe obviously obvious for SQL gurus but really not for me, so I wanted to share the information.

 

not goodquite goodgoodvery goodexcellent (No Ratings Yet)
Loading ... Loading ...

Written by Arnaud
Tags: , , ,

Share/Save/Bookmark


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.

Continue reading »

not goodquite goodgoodvery goodexcellent (1 votes, average: 5 out of 5)
Loading ... Loading ...

Written by Arnaud
Tags: , , , ,

Share/Save/Bookmark