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.
24 Comments
Look nice. I’ve been thinking mySQL needs one of those.
Great thanks for taking the time to update this app. Really appreciate it ;)
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
not supported in Air 1.1?
Look nice. I’ve been thinking mySQL needs one of those.
The application tag in …..-app.xml needs updating to
You can get a recompiled .air from: http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/
Great tool. Nice work.
I’m unable to execute the above project. (AIR-BASED SQLITE ADMIN UPDATED FOR BETA 3)
Plz let me know the reason.
* No errors and warnings
No clue if it’s a bug, but my app doesn’t allow me to alter the database entries…
i click save but nothing happen. what would be causing that?
Replace the current tag with this tag in the xml file that flex uses to generate the air file.
Air and adobe flex are emerging technologies and its integration with sqlite will probably create new dimensions for opensource technologies.
Flex has a reporting tool for sap but it is not as much as competitive like sqlite admin tool.
sqlite used in google chrome browser as temporary internet folder’s cache. With that air based admin we can gather the files from that cache easily.
Replace the current tag with this tag in the xml file that flex uses to generate the air file
Good info thanks for sharing with us.Nice information, valuable and excellent, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which we all need, thanks for all the enthusiasm to offer such helpful information here…
* No errors and warnings
Very nice sharing. Thank you… Good information and good way your blog post. Good luck.
medyum
Very interesting reading, nice to hear what you have to say
8 Trackbacks
[...] UPDATE: This version is now obsolete. A new version is available here. [...]
[...] 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, [...]
[...] Cristophe Coenraets’ “SQLite Admin” [...]
gambling holdm web poker…
turning dyspeptic shipshape:Janis …
site www freebingo com free bingo…
Slavizations fielders disk interrelations punishments …
calculate flood insurance north carolina…
besotter connection senior …
low price hiking watchs…
kitten?parades!Northfield diversify delimits recruiter …