AIR-based SQLite Admin updated for Beta 3
Updated on Feb 8th 2008: If you downloaded this application before this date, make sure you download the new version (AIR file + source code) for the latest bug fixes.
I’m in the process of updating some of the applications I wrote for earlier versions of Flex and AIR. Here is a new version of my AIR-based SQLite Admin application updated for Beta 3. You can use this application to examine the structure of a database, create a new database or open an existing one, execute any type of SQL statement, etc.
An interesting aspect of this new version is that the application itself uses a database (sqladmincache.db) to keep track of the databases you opened and the statements you executed. This is useful if you want to quickly re-open a recently accessed database, or re-execute a recently executed statement.
This version uses synchronous database operations, and uses the schema API to show you the list of tables and columns available in your database.
The UI is still simple, but uses some new AIR and Flex 3 features such as the AdvancedDataGrid and Native Windows.
Click here to install the application.
Click here to download the source code.
Comments
12 Responses to “AIR-based SQLite Admin updated for Beta 3”
Leave a Reply
[...] UPDATE: This version is now obsolete. A new version is available here. [...]
Look nice. I’ve been thinking mySQL needs one of those.
Great thanks for taking the time to update this app. Really appreciate it ;)
[...] you downloaded the SQLite Admin AIR application I posted on Tuesday, make sure you download the last version. The new version fixes a problem where [...]
[...] System Access, Network Detection, Notifications, Application Update, Drag and Drop, Local Database) Christophe Coenraets’s very cool SQLite Admin Application (Source included) And Christophe’s equally cool SalesBuilder (As with the SQLite Admin app, [...]
Just what I needed to debug a query that stopped functioning after the multiples AIR updates during the beta period. You saved me a lot of time and the source is very educative to understand the SQLLite API. I have just modified line 40 of QueryWindow.mxml to get more detailed info on queries error:
Alert.show(error.message +”: “+ error.details, “Error”, 4.0, box);
The “error.message” only gives an error code.
Thanks a lot Christophe :)
Hi, Sorry.. now I’m confused.
I tried to install the version in this page it says:
“This application requires a version of Adobe AIR which is no longer supported. Please contact the application author for an updated version.”
And I’ve installed the latest AIR. Hmm.
Nisa K,
I had the same problem. What i did was just to create a new Proyect, create de same files that are inside sqliteadmin.zip, copy & paste and it worked.
Great tool. Nice work.
Regards,
Matias
Replace the current tag with this tag in the xml file that flex uses to generate the air file.
application xmlns=”http://ns.adobe.com/air/application/1.0″
Christophe:
I just downloaded your SQLite AIR Admin package (used your install link) but when trying to install with AIR beta 3, AIR Application Install throws this error: “Sorry, an error has occurred. The application could not be installed because the AIR file is damaged. Try obtaining a new AIR file from the application author.”
Downloaded another copy just to be sure, but no joy. Curious if the AIR file you have published may possibly be broken for some reason.
Thanks,
Mike
all man water night green