Thursday, May 8, 2008

Flex SQLite Example: AIR Application

Tried out this sample application withe Flex and adobe AIR integrated SQLite.
It has the Insert and Delete functionality.

Will post the updated one soon with the auto update functionality. Download it here.


Anonymous said...

Sorry I didn't look into code yet.
Could you please tell me if this SQLite is stored on the server side?

Tomas Sancio said...


No, since it's SQLite and file-based, it's stored wherever you point your file to. In this case, he wrote this line:

exampleDBFile = File.applicationStorageDirectory.resolvePath( "Person.db" );

So the database is stored in a file and runs with the SQL database engine included in Adobe Air. Look up "SQLite" in the Flex 3 Language Reference for more info.


sathya said...

Hi ,

I have downloaded the project and runned it, it was working perfectly but i didnt find the person.db file in the project will it be created automatically.

sholmes said...

Process terminated unexpectedly.

I tried to run this example,
but didn't get lucky.
The output was:

"C:\Program Files\Adobe\AdobeFlashBuilderBeta2\sdks\4.0.0\bin\adl.exe" C:\Users\Jussi\workspace\AIR\bin-debug\AIRSQLiteExample-app.xml C:\Users\Jussi\workspace\AIR\bin-debug

Output from command:

error while loading initial content

ed said...

So where exactly is the sqlite database stored after it is created? I am running os x. I am using the finder and can't see to find anything with *.db let alone the database created in this example. I know it is there since it is work. Just can't seem to find it at all?