SQLite Admin for AIR 1.0

By Christophe Coenraets | Published: February 26, 2008

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.

  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • DZone
  • LinkedIn
  • StumbleUpon
  • Twitter
This entry was posted in Air, Flex, SQLite. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

164 Comments

  1. AndyEd
    Posted February 26, 2008 at 3:10 pm | Permalink

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

  2. Steven Gemmen
    Posted February 26, 2008 at 7:07 pm | Permalink

    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. Daniel
    Posted March 1, 2008 at 1:24 pm | Permalink

    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

  4. Joshua Mostafa
    Posted March 16, 2008 at 5:25 pm | Permalink

    Great work!

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

  5. Royston Shufflebotham
    Posted March 21, 2008 at 5:28 pm | Permalink

    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.

  6. Javier Julio
    Posted April 5, 2008 at 1:44 pm | Permalink

    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!

  7. Vasile
    Posted April 17, 2008 at 11:24 pm | Permalink

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

  8. reallypride
    Posted April 28, 2008 at 10:14 am | Permalink

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

  9. cp8r
    Posted April 29, 2008 at 10:21 am | Permalink

    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)

  10. Sağlıkpenceresi
    Posted May 13, 2008 at 12:02 pm | Permalink

    Thank you. İts the best.

  11. Sağlıksal
    Posted May 13, 2008 at 12:03 pm | Permalink

    İts cool.

    Best Regards

  12. Marcus
    Posted June 7, 2008 at 4:55 pm | Permalink

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

  13. woodstudenta
    Posted June 19, 2008 at 10:44 pm | Permalink

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

  14. Khairunnisa
    Posted July 24, 2008 at 11:50 pm | Permalink

    I tried your SQLite Admin application on Vista with UAC (User Access Control) on it doesn’t seem to want to retrieve data from tables.
    I can open your sqladmindemo.db but NOT querying from it.
    However, retrieval/writing of data on your SalesBuilder application works fine on Vista with the same settings.
    I realize both are using synchronous connection – so what’s the difference between these two applications in terms of calling data?
    My application is facing the same problem as your sqlite admin – not able to read data on Vista with UAC on. However works perfectly when UAC is off.

    Can Enlighten?

  15. ibmblackcube
    Posted July 27, 2008 at 8:59 pm | Permalink

    land we all green water black look jhon no boat head

  16. Araba, Yarış Oyunları
    Posted August 6, 2008 at 5:45 pm | Permalink

    Güzel bilgiler..Teşekkürler…

  17. houseboat
    Posted August 19, 2008 at 9:02 pm | Permalink

    frog university me free head clean ibm this busy woman home juicy

  18. sohbet
    Posted August 22, 2008 at 5:28 am | Permalink

    Güzel bilgiler..Teşekkürler…

  19. chat
    Posted August 22, 2008 at 5:04 pm | Permalink

    good thanks

  20. çet
    Posted August 22, 2008 at 5:04 pm | Permalink

    thanks….

  21. sohbet
    Posted August 24, 2008 at 1:51 pm | Permalink

    Thanks. you very muck.

  22. muhabbet
    Posted August 24, 2008 at 1:52 pm | Permalink

    ooo süper this is.

  23. kızlarla sohbet
    Posted August 24, 2008 at 1:52 pm | Permalink

    thanks.

  24. radyo dinle
    Posted August 24, 2008 at 7:23 pm | Permalink

    thanks you man

  25. hosting
    Posted August 24, 2008 at 7:24 pm | Permalink

    good thanks

  26. irc shell
    Posted August 24, 2008 at 7:25 pm | Permalink

    its cool.

  27. muhabbet
    Posted August 25, 2008 at 11:11 am | Permalink

    thanks

  28. sohbet
    Posted August 30, 2008 at 4:35 pm | Permalink

    i like thank you

  29. sohbet
    Posted September 5, 2008 at 1:57 pm | Permalink

    Sohbet Chat Muhabbet Odalari Turkish

  30. ERP Software Systems, WEB Sites Development and Design
    Posted September 9, 2008 at 3:52 am | Permalink

    Very useful tool. Thank you.

  31. ankara evden eve
    Posted September 10, 2008 at 12:54 pm | Permalink

    Thank you very much for this useful article.

  32. irc
    Posted September 14, 2008 at 5:01 pm | Permalink

    Thank you very much

  33. sohbet
    Posted September 17, 2008 at 2:00 am | Permalink

    Thanks You

  34. sohbet
    Posted September 18, 2008 at 11:27 am | Permalink

    tenksk you very
    It’s really a great artical and really helped me. One question from myside is..

    Is there anyway of copressing .tiff files by using mod_gzip??

  35. nakliyat
    Posted September 18, 2008 at 8:41 pm | Permalink

    thanks you man

  36. sohbet
    Posted September 19, 2008 at 4:58 am | Permalink

    Thank you very much coenraets.org

  37. Venkat from India
    Posted September 25, 2008 at 12:02 am | Permalink

    Does it not support insert statements or what!??

    I tried inserting something into the demo db and all I get is “Error #3115″?

  38. sohbet
    Posted October 6, 2008 at 2:09 pm | Permalink

    thanks

  39. Chat
    Posted October 6, 2008 at 4:41 pm | Permalink

    Thanks You

  40. Luis Munoz
    Posted October 6, 2008 at 10:16 pm | Permalink

    Hi there,
    Is there any documentation on how to install the SQLiteAdmin tool and how to use it. I am running Flex 3 on a iMac.
    I am trying to learn adobe Air and using above tool should make working with SQLite easier.Very much appreciated.

    Thanks

  41. radyo
    Posted October 10, 2008 at 10:58 pm | Permalink

    danke admin

  42. radyo dinle
    Posted October 10, 2008 at 10:59 pm | Permalink

    tek yuo admin

  43. çet
    Posted October 12, 2008 at 2:02 pm | Permalink

    thanks you good

  44. cet sohbet
    Posted October 12, 2008 at 2:04 pm | Permalink

    thanks

  45. chat
    Posted October 12, 2008 at 7:59 pm | Permalink

    thank you

  46. chat
    Posted October 12, 2008 at 7:59 pm | Permalink

    thanks

  47. gay sohbet
    Posted October 12, 2008 at 8:00 pm | Permalink

    thank you admin

  48. film izle
    Posted October 13, 2008 at 2:11 am | Permalink

    thanks for you.

  49. Sohbet
    Posted October 25, 2008 at 2:03 pm | Permalink

    Thankx

  50. Doug
    Posted November 23, 2008 at 8:03 pm | Permalink

    I am also getting only 3115 error when attempting to insert. It is driving me crazy. What’s the deal?

1 2 3 4

20 Trackbacks

  1. By SQLite Admin for AIR 1.0 | Adobe AIR Tutorials on February 28, 2008 at 6:09 am

    [...] more @ http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]

  2. By » air sqlite admin on March 16, 2008 at 5:34 pm

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

  3. By joshua mostafa >> /dev/blog & » Blog Archive » simple sql batch loader in air on March 25, 2008 at 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 [...]

  4. By Koen.cz » AIR API - Introduction to the SQLite Database on March 28, 2008 at 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 [...]

  5. By CornFlex - Flex & Flash by Quentin Lengelé » Blog Archive » SQLite Admin for AIR 1.0 on March 28, 2008 at 5:14 am

    [...] Source : http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10 [...]

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

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

  7. By Celi Online » 101 Recursos para Adobe Air on April 24, 2008 at 4:39 pm

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

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

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

  9. By 101 Recursos para Adobe Air | Nodo54 on May 7, 2008 at 12:36 pm

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

  10. By SQLite with AIR tutorial, conquer the DB. at 9MMEDIA Blog on June 11, 2008 at 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. [...]

  11. By dice online poker on July 7, 2008 at 1:12 am

    dice online poker…

    Byzantinize unlocks misguided:grenades …

  12. By Adobe AIR相關學習網頁 於傻仔仔 on July 7, 2008 at 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 [...]

  13. By pot limit hold em pokher strategy on September 5, 2008 at 2:27 am

    pot limit hold em pokher strategy…

    disappearances preallocated Bushnell:octagonal …

  14. By Adobe AIR « Flex Generation Weblog on October 14, 2008 at 3:00 am

    [...] Christophe Coenraets :: SQLite Admin Application for AIR [...]

  15. By car insurance coverage on October 16, 2008 at 12:54 pm

    car insurance coverage…

    retrain oppressive diorama …

  16. By Design & Development Tutorials » Create an SQLite connection in Adobe Air on April 17, 2009 at 1:49 am

    [...] SQLite database. I use SQLite administrator which is free to download. Another good application is SQLite admin which was maid by Christophe Coenraets. This is an Air application and can by used on a mac. I’ll [...]

  17. By As melhores aplicações AIR para Designers e Developers « on September 14, 2009 at 6:15 pm

    [...] mais completa. Muito simples, com um design eficaz. Distingue-se dos outros seus competidores (slqiteadmin e sqlite sorcerer) porque permite adicionar, apagar e actualizar conteúdo sem escrever uma única [...]

  18. By Comunidade Portuguesa de Rich Internet Applications» Blog Archive » Parte I – Flex, AIR & SQLite on September 30, 2009 at 6:57 pm

    [...] mais informações sobre SQLite no AIR: http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]

  19. By Tutorial parte I – Flex Air e SQLite at iMauro blog on October 1, 2009 at 8:23 am

    [...] mais informações sobre SQLite no AIR: http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]

  20. By 超全的AIR学习资源网址大全 on October 22, 2009 at 9:46 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 [...]

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>