Jun/100
7 rules to work with highest performance in SQLite databases in Adobe AIR/Flex
This article shows 7 rules how to get out the most of your SQLite application in AIR:
- Create VO’s (value objects or classes) for each query extending a VO with contains at least the “ROWID”
- Always use SQLStatement.itemClass and to query for an object – it automatically casts the
- Use the “AS” alias in your SQL queries (e.g. SELECT count(name) AS “numberOfNames”) to fit it to your value object.
- Use SQLConnection.columnNameStyle = SQLColumnNameStyle.SHORT as possible.
- Try to avoid the same name in different tables (which has to be joined at one point)
- Use SQL transactions: Start with sqlConnection.begin(); continue with “INSERT INTO (‘firstName’) VALUES (‘:firstName’) and SQLStatement.parameters[':firstName'] = VOList[numberOfVO][firstName]; and end with SQLConnection.commit();
- If you want to get the current database Schema (‘SELECT * FROM sqlite_master WHERE type = “table”‘) open the database in read mode SQLConnection(_sqlFile, SQLMode.READ), load the Schema sqlConnection.loadSchema() and push SQLConnection.getSchemaResult() into an Array
Jun/100
NativeMenu and CMD-Backspace #AS3
If you are using var the NativeMenu on Mac and don’t know how to assign the backspace key, then you are here completely right.
This is how it works:
You just to set keyEquivalent = ‘\b’ (On German Keyboard: Alt Gr – Shift – 7)
Example:
menuItem:NativeMenuItem = nativeMenu.addItem(new NativeMenuItem(“MyMenuItem”));
menuItem.keyEquivalentModifiers = [Keyboard.COMMAND];
menuItem.keyEquivalent = ‘\b’;
menuItem.enabled = false;
menuItem.addEventListener(Event.SELECT, eventHandler);
Jun/102
Firefox Plugin: SqliteManager as Standalone app!
Do you also like Firefox and it’s powerful addons?
Are you also working with the powerful SQLiteManager (by Tarakant Tripathy, Mrinal Kant) addons?
But sometimes your Firefox is crashing – or you have just too many tabs – or it just takes forever to open up that thing?
So, before about half a year I figured out how you can run this plugin without the Firefox at all!
Like a real application!
How it works?
- You need the XULRunner (an environment which can bootstrap XUL+XPCOM applications)
- You need the searched plugin as XULRunner application (SQLiteManager)
So check out:
http://code.google.com/p/sqlite-manager/wiki/XulrunnerApplication
May/100
The Stand-sit-dynamic effect saves money
17 employees participate in a survey over five year to work additionally with a high desk to increase the time of standing during the work and also to decrease the time of sitting, as the bad habit while writing. Through that period the health status and health behavior was observed.
The question on this study was:
- whether the stand-sit-dynamics is lived permanently
- if the satisfaction and welfare of employees will improve
The result was:
- up to 60% of those polled where satisfied to work on a standing desk
- 3% increased their productivity on a high level
- the overall job satisfaction got over 60%, for about 5% and substantiall
(Source: http://translate.google.de/translate?js=y&prev=_t&hl=de&ie=UTF-8&layout=1&eotf=1&u=http%3A%2F%2Fwww.officeplus.de%2Fergonomiewissen%2Flangzeitstudie%2F&sl=de&tl=en)
May/100
Combine states and transitions #flex
The version of flex builder offers many new features.
One really useful combination is the combination of states and transition.
Comparing to the normal development process, complicated bit shifting for setting one pixel to another place – Flex shows how easy it could go:
Dec/090
Work & fun
On this very nice example you can figure out that work is just something hard & exhausting when it makes no fun:
Sep/090
First release of the ieservices-logo
After hours and hours, finally the first release of the ieservices-logo is out:
Jul/090
Interesting Videos
The world changes for a moment:
Is there someone to be able to present something small, really big?
Yes. they can:
And if you wake up, check your oil:
audi_horsehead