SQLite Admin for AIR 1.0

Here is a new version of my AIR-based SQLite Admin application updated for AIR 1.0. 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 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.

The UI is still simple, but uses some new AIR and Flex 3 features such as the AdvancedDataGrid and Native Windows.

Please upgrade your Flash Player This is the content that would be shown if the user does not have Flash Player 9.0.115 or higher installed.


Click here to download the source code.

Comments

25 Responses to “SQLite Admin for AIR 1.0”

  1. AndyEd on February 26th, 2008 3:10 pm

    Thanks! You fixed the file extension restriction to allow opening of .sqlite files!

  2. Steven Gemmen on February 26th, 2008 7:07 pm

    Thanks for posting the source. I added a button to QueryWindow.mxml to let you Save your SQL to a file. Its no frills, but if you want to add it in the AS3 code is here:

    http://initapp.privatepaste.com/e51RE2la3g

  3. SQLite Admin for AIR 1.0 | Adobe AIR Tutorials on February 28th, 2008 6:09 am
  4. Daniel on March 1st, 2008 1:24 pm

    Hey Christophe,
    a very nice tool! I just started using Flex with Air and your tool makes it a lot easier working with sqlite, thanks.

    Greets,

    Daniel

  5. Joshua Mostafa on March 16th, 2008 5:25 pm

    Great work!

    You should lose the Eclipse / Flex Builder properties files (.settings/*, .flexProperties, etc) from your ZIP, though …

  6. » air sqlite admin on March 16th, 2008 5:34 pm

    [...] just came across this AIR-based SQLite [...]

  7. Royston Shufflebotham on March 21st, 2008 5:28 pm

    Hi there,

    Thanks very much for the useful app and helpful source code. I was actually wondering about your source code distribution: it contains a copy of Adobe’s Myriad Web Pro font .ttf files.

    Is it permissible to redistribute these files generally? They seem to be something that you can purchase a licence for from Adobe, so I’m slightly confused as to whether you should be redistributing them, and whether I may?

    Cheers,
    Royston.

  8. joshua mostafa >> /dev/blog & » Blog Archive » simple sql batch loader in air on March 25th, 2008 9:17 pm

    [...] like, but be aware that it’s a very basic and untested app, and Christopher Coenraets’ SQLite Admin for AIR does everything my little app does, and more [...]

  9. Koen.cz » AIR API - Introduction to the SQLite Database on March 28th, 2008 1:04 am

    [...] of the first two that I have listed (and I had the third one recommended by another developer). SQLite Admin AIR ApplicationSQLite Manager Firefox ExtensionSQLite Database Browser Next Tutorial: In the next article, I will [...]

  10. CornFlex - Flex & Flash by Quentin Lengelé » Blog Archive » SQLite Admin for AIR 1.0 on March 28th, 2008 5:14 am
  11. Javier Julio on April 5th, 2008 1:44 pm

    Christophe,

    Thanks for sharing this as its a great AIR application! I know you’ve made the source available but I wanted to verify with you first. I’d like to expand the interface so devs can create easy things like columns and tables without needing to write any SQL. Would you be alright with me expanding on the source you’ve released and then making it available for others? Again thanks for such a helpful app!

  12. Vasile on April 17th, 2008 11:24 pm

    Cool!!!
    Is there any type of licence for using. I would like to add some features as syntax highlighting and a graph to show database structure (using spring graph component) ??

  13. 101 Adobe AIR Resources to Add to Your Toolbelt of Awesomeness on April 21st, 2008 11:28 pm

    [...] SQLite Admin for AIR 1.0 - coenraets.org [...]

  14. Celi Online » 101 Recursos para Adobe Air on April 24th, 2008 4:39 pm

    [...] SQLite Admin for AIR 1.0 - coenraets.org [...]

  15. 101 Adobe AIR Resources to Add to Your Toolbelt of Awesomeness | AIR + Flex Laboratory. on April 27th, 2008 8:36 am

    [...] SQLite Admin for AIR 1.0 - coenraets.org [...]

  16. reallypride on April 28th, 2008 10:14 am

    Thanks,a very nice and useful tool
    I like it very very much.

  17. cp8r on April 29th, 2008 10:21 am

    Thank you for this inspiring AIR application!

    As I am developping with Flex and AIR for my diploma degree I would like to ask two questions:

    1.
    Also described I do not understand how the local database receives its initially data - or from where! Where is the initial data written when one installs the application? I could not find anything in the XML files under /data.

    2.
    In an earlier post regarding the first version of salesbuilder you wrote you “removed the server component (to avoid having to watch all the bad things that can happen to a shared demo database)” and that an “XML document plays the role of server data.” So this means it’s also possible to access a remote database e.g. on a webserver? I try to do this for a while but cannot find out how this works. Do you have any hints?

    I would be very thankful for any answer, maybe via email. I would have emailed you, too, but could not find any address :-(

    Best regards,

    Christian (Wolfsburg, Germany)

  18. 101 Recursos para Adobe Air | Nodo54 on May 7th, 2008 12:36 pm

    [...] SQLite Admin for AIR 1.0 - coenraets.org [...]

  19. Sağlıkpenceresi on May 13th, 2008 12:02 pm

    Thank you. İts the best.

  20. Sağlıksal on May 13th, 2008 12:03 pm

    İts cool.

    Best Regards

  21. Marcus on June 7th, 2008 4:55 pm

    Haha this is so sweet. Thanks for your time and effort–it’s definitely saved me some pain. I appreciate it!

  22. SQLite with AIR tutorial, conquer the DB. at 9MMEDIA Blog on June 11th, 2008 2:40 pm

    [...] I recommend downloading a SQLite browser which will enable you to see and test your database. There are two that I know of: Firefox plugin And SQLite-Admin-for-Air, developed in Air. [...]

  23. woodstudenta on June 19th, 2008 10:44 pm

    places the wild and eat and climb with box decay year from raspberries, places

  24. dice online poker on July 7th, 2008 1:12 am

    dice online poker…

    Byzantinize unlocks misguided:grenades …

  25. Adobe AIR相關學習網頁 於傻仔仔 on July 7th, 2008 10:20 am

    [...] RichFLV - adobe.com SearchCoders Dashboard - adobe.com Spazan - Twitter client - adobe.com SQLite Admin for AIR 1.0 - coenraets.org StockQ: A Stock Quotes application, built for Adobe AIR - adobe.com StudioCloud PSG [...]

Leave a Reply