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.
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
sorry 4 my bad english..
I can install it on my comp,
it always getting error, the text goes like this :
“This application requires an update to Adobe AIR that is not available for your system.”
My AIR version is 2.0.3.13070
what I have to do?
thx
thanks very nice
Hey Chris,
I realize this is low priority, but the previous posters are correct that the installer fails on AIR 2.5.
I’ll likely build from source, I’m sure its an app.xml issue.
Thanks!
TJ
all man water night green :)
I intended to draft you a very small note to finally say thanks as before just for the precious thoughts you have shown on this page. It’s really pretty open-handed of you to offer extensively all many of us could possibly have sold as an e book in order to make some bucks on their own, most notably seeing that you might well have tried it in case you desired. These techniques also served to be a easy way to recognize that someone else have the identical fervor just like my very own to learn very much more concerning this issue. I’m sure there are several more pleasurable opportunities up front for many who read carefully your site.
Installation fails, I have AIR 3 beta installed. It says I have to upgrade AIR :)
really liked your presentation on QCON a few weeks ago. I could really tell you are very good at what you do. My compliment for that.
I have a question though: I some environments like banks etc Flash plugin is disabled in the browser (security wise). How can we still use this technology wit