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
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:
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
Jul/090
Motivation
Welcome and thank you for visiting this page.
Once upon a time the Brooklyn Bridge has connected Brooklyn and Manhatten. The bridge was built under the direction of the German origin John Augustus Roebling. With the same chance as a German, I am looking forward with the same chance of reaching limits and connecting the world.
You are looking for a proactive person, including this attributes?
Nothing happens by itself.
Everything needs a trigger.
For example think of the Domino effect:
One idea triggers many more in continuation, until the last domino has fallen. Only then, the chain of ideas is complete.
Don’t think too much, I am your man!
As a thinking practician who likes to activate and not as a practical thinker who answers just impulsively, I am used to think out of the box.
While my technical apprenticeship, working for three years in business, I got my background. After that, continuing my educational opportunities, I began my college education. Through my early business experiences – unlike most other students, I have a purpose in my studies and the possibilities in future. I have collected great experiences in my life and mentionable knowledge in the IT field.
I became in April 2006 entrepreneur with my own company, called ieServices.
My idea how business will run? Three questions should be asked:
1. Why should a customer do business with you?
2. Why should he pay for your work?
3. How could the client come back, not the product?
I think the basic of every business is the win-win-situation.
How does one get there?
1. Initiate
2. Meet expectations
3. Get done.
But so far, why exactly you?
My aim is to learn how to bring customers dreams become reality. As an enthusiastic and young entrepreneur, it is a perfect opportunity for me to know how your business runs with your marketing solutions.
In my free time I am often experiencing with media and solutions, recently with video encoding I used also to play Underwater Rugby, which is more than a 360 degree sport.
Sincerely yours,
Martin Wörz