AIR-based SQLite Admin updated for Beta 3

February 5, 2008 in Flex

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.

  • Pingback: New AIR SQLite Administration App (with Source Code) : Christophe Coenraets()

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

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

  • Pingback: Bug Fix in SQLite Admin : Christophe Coenraets()

  • Pingback: FlashGen.Com .: blog :. » Adobe AIR is officially released!()

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

  • Nisa K

    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.

  • Matias

    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″

  • Mike Hopkins

    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

  • Abhishek

    not supported in Air 1.1?

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

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

  • Pingback: gambling holdm web poker()

  • Pingback: site www freebingo com free bingo()

  • Pingback: calculate flood insurance north carolina()

  • Pingback: low price hiking watchs()

  • 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.

  • Raj

    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

  • foxchx

    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

  • arie

    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.

  • Ivan

    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

  • Pingback: Viewer for AIR Database (SQLite) » free icons download()

  • Formalarımızda kullandığımız kumaş; birinci sınıf mikro-interlok olup; esnek-fit, anti-bakteriyel, termo-balans ve hemen kuruma özelliğine sahiptir. Futbol maçlarınızda size hareket özgürlüğü sunan bu formalar; günlük olarak giyilebilecek kadar şık tasarlanmıştır. Forma Modellerimiz özel dikim ve Dijital baskılı olarak iki tür üretilmektedir. kaliteli,seri üretim ve uygun fiyatlarda burda.

css.php