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.

40 Responses to AIR-based SQLite Admin updated for Beta 3

  1. Bill Shirley February 5, 2008 at 2:09 pm #

    Look nice. I’ve been thinking mySQL needs one of those.

  2. Josh February 5, 2008 at 4:20 pm #

    Great thanks for taking the time to update this app. Really appreciate it ;)

  3. Patrick Tai February 25, 2008 at 6:38 pm #

    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 :)

  4. Nisa K May 16, 2008 at 2:58 am #

    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.

  5. Matias June 9, 2008 at 10:39 pm #

    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

  6. Andrew H June 12, 2008 at 9:54 am #

    Replace the current tag with this tag in the xml file that flex uses to generate the air file.

  7. Andrew H June 12, 2008 at 9:55 am #

    application xmlns=”http://ns.adobe.com/air/application/1.0″

  8. Mike Hopkins June 22, 2008 at 7:15 pm #

    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

  9. jokejuicyame June 29, 2008 at 2:52 am #

    all man water night green

  10. Abhishek July 26, 2008 at 5:36 am #

    not supported in Air 1.1?

  11. sohbet August 22, 2008 at 5:31 am #

    Look nice. I’ve been thinking mySQL needs one of those.

  12. Tom Chiverton January 27, 2009 at 8:43 am #

    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/

  13. araç sorgulama March 17, 2009 at 5:04 pm #

    Great tool. Nice work.

  14. Raj May 21, 2009 at 2:53 am #

    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

  15. foxchx June 15, 2009 at 2:01 am #

    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?

  16. medyum July 13, 2009 at 7:12 am #

    Replace the current tag with this tag in the xml file that flex uses to generate the air file.

  17. earrings for men August 24, 2009 at 9:37 am #

    Air and adobe flex are emerging technologies and its integration with sqlite will probably create new dimensions for opensource technologies.

  18. sap muhasebe August 24, 2009 at 9:46 am #

    Flex has a reporting tool for sap but it is not as much as competitive like sqlite admin tool.

  19. sex shop August 31, 2009 at 8:27 am #

    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.

  20. حلقات ام البنات September 6, 2009 at 12:13 am #

    Replace the current tag with this tag in the xml file that flex uses to generate the air file

  21. Eryaman hali yikama June 15, 2010 at 7:40 am #

    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…

  22. matbaa August 8, 2010 at 10:37 am #

    * No errors and warnings

  23. medyum August 21, 2010 at 7:15 am #

    Very nice sharing. Thank you… Good information and good way your blog post. Good luck.
    medyum

  24. nicola bingo jones August 26, 2010 at 12:41 pm #

    Very interesting reading, nice to hear what you have to say

  25. arie September 15, 2010 at 9:21 am #

    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

  26. kablo tv October 9, 2010 at 12:29 pm #

    thanks very nice

  27. TJ Downes December 2, 2010 at 10:21 am #

    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

  28. مسلسل بنات الثانويه June 19, 2011 at 5:57 pm #

    all man water night green :)

  29. Pandora Bracelets August 16, 2011 at 6:15 am #

    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.

  30. Ivan September 8, 2011 at 8:29 am #

    Installation fails, I have AIR 3 beta installed. It says I have to upgrade AIR :)

  31. maviajansmatbaa September 16, 2011 at 11:39 am #

    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

Trackbacks/Pingbacks

  1. New AIR SQLite Administration App (with Source Code) : Christophe Coenraets - February 5, 2008

    [...] UPDATE: This version is now obsolete. A new version is available here. [...]

  2. Bug Fix in SQLite Admin : Christophe Coenraets - February 8, 2008

    [...] 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 [...]

  3. FlashGen.Com .: blog :. » Adobe AIR is officially released! - February 25, 2008

    [...] 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, [...]

  4. 360|Flex slides for “AIR SQLite: An optimization conversation”, a bunch of Words, punctuated - by Paul Robertson (http://probertson.com/) - August 22, 2008

    [...] Cristophe Coenraets’ “SQLite Admin” [...]

  5. gambling holdm web poker - September 6, 2008

    gambling holdm web poker…

    turning dyspeptic shipshape:Janis …

  6. site www freebingo com free bingo - October 5, 2008

    site www freebingo com free bingo…

    Slavizations fielders disk interrelations punishments …

  7. calculate flood insurance north carolina - October 7, 2008

    calculate flood insurance north carolina…

    besotter connection senior …

  8. low price hiking watchs - October 29, 2008

    low price hiking watchs…

    kitten?parades!Northfield diversify delimits recruiter …

  9. Viewer for AIR Database (SQLite) » free icons download - March 15, 2012

    [...] Check this URL: http://coenraets.org/blog/2008/02/air-based-sqlite-admin-updated-for-b eta-3/ [...]

Leave a Reply