New AIR SQLite Administration App (with Source Code)

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

Here is an updated/rewritten version of my AIR SQLite Admin application. 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 new version uses synchronous database operations (AIR beta 1 only supported asynchronous database access), and uses the schema API (also new in beta 2) 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.

October 25, 2007 | Filed Under Air, Flex, SQLite 
These icons link to social bookmarking sites where readers can share and discover new web pages.
  • bodytext
  • del.icio.us
  • Facebook
  • Google
  • description
  • NewsVine
  • Slashdot
  • Technorati
  • StumbleUpon

Comments

25 Responses to “New AIR SQLite Administration App (with Source Code)”

  1. AIR SQLite Administration APP (sourcecode included) by Christophe Coenraets « Cyberspace Nova on October 26th, 2007 1:29 am

    [...] Published October 26th, 2007 AIR - ex Apollo , Actionscript 3.0 , Applications Christophe Coenraets built interesting and very usefull app in AIR that allows you to admin your SQLite databases… Could prove very usefull if you are [...]

  2. Anonymous on October 26th, 2007 8:11 am

    Sounds good. But what is AIR?

  3. JJ on October 26th, 2007 10:22 am

    Adobe Integrated Runtime, a product that will allow you to create Flex applications for the desktop: http://labs.adobe.com/technologies/air/

  4. Theo on October 27th, 2007 9:15 am

    Why doesn’t it let me open files other than those with a .db extension? Most SQLite databases I have encountered does not use any particular extension.

  5. Burmeseked.Com » New AIR SQLite Administration App (with Source Code) on October 28th, 2007 12:23 pm

    [...] Fogg wrote an interesting post today on New AIR SQLite Administration App (with Source Code)Here’s a quick [...]

  6. IL.Blog » Blog Archive » SQLite + Air on October 29th, 2007 2:16 am

    [...] También existe un gestor de SQLite con código fuente icluido aquí [...]

  7. Jason The Saj on October 30th, 2007 1:52 pm

    Is there a means to create fields and field entry values?

  8. Dan Wilson on October 31st, 2007 9:52 am

    It seems the application does not handle SQL statements with single quotes in it. I fixed this using prepared statements. The only file that needed modification was src/cache.as .

    More details (and the file) are here:
    http://www.nodans.com/index.cfm/2007/10/31/Fixed-error-in-SQLLite-Administration-tool

    Dan Wilson

  9. Francois Botha on November 7th, 2007 2:19 am

    What’s that font in the screenshot? Love it! Want it!

  10. Eric on December 1st, 2007 2:18 am

    Francois: The font is Myriad Web Pro and is included in the source code.

  11. jacob on December 15th, 2007 12:02 pm

    hi, nice program you’ve made.

    But.. the refresh button does not always work.
    i discovered it by creating 1 table and after creating used drop tablename to delete it.
    when i use the refresh button, it shows me the same table… but if i restart the program it is gone as it should be.

    maybe a little bug, so i report it to you.

    Greetz, jacob

    ps. i hope you understand my english.. im from holland so my english is not so verry well.

  12. JJ on January 1st, 2008 11:36 am

    It’s no more compatible with the new AIR

  13. Mike on January 2nd, 2008 7:31 am

    1 question: when you use sqladmindemo.db do you have to be administrator on Windows to be able to do CRUD operations?

  14. Will on January 4th, 2008 7:41 pm

    Any plans to update it for the latest AIR builds? Im on beta3 at the moment and it says the install is not compatible

  15. Guneet on January 16th, 2008 9:23 pm

    I have modified the code to make it compatible to Flex 3 Beta 3. The Following are the changes that I made.

    1. Changed File.applicationResourceDirectory to
    File.applicationStorageDirectory

    2. Changed all the instances of sqlConnection.getFile().nativePath to file.nativePath

    Hope this helps. Thanks

  16. Varun Shetty on January 17th, 2008 4:08 pm

    hey.. the application is not installing.

    mebbe the AIR update isnt allowing me to install it.

    does this app run on the latest AIR player..?

  17. guaranteed school loans on February 9th, 2008 5:08 am

    guaranteed school loans…

    anchored volatilities:swimmer!butcher complaints?profusion …

  18. help my credit on February 9th, 2008 4:53 pm

    help my credit…

    reversal elaborating?solely pelican shareholders …

  19. guaranteed unsecured visa credit cards on February 14th, 2008 10:30 pm

    guaranteed unsecured visa credit cards…

    domesticate conditioners.purring!twined:villas …

  20. vinç on February 17th, 2008 4:50 pm

    Hope this helps. Thanks.

    ysbostan

  21. Anonymous on March 24th, 2008 7:47 am

    kareena nude totally…

    kareena nude totally…

  22. Anonymous on April 3rd, 2008 2:31 am

    heidi cortez nude gallery…

    heidi cortez nude gallery…

  23. Anonymous on April 3rd, 2008 10:10 pm

    family guy hentai porn…

    family guy hentai porn…

  24. Anonymous on April 3rd, 2008 10:11 pm

    ghost in shell hentai porn…

    ghost in shell hentai porn…

  25. Phil on July 9th, 2008 6:36 am

    Looks like this needs to be updated for Air 1.1. Can you post a current build?? TIA!

Leave a Reply