SQLite Admin for AIR 1.0

Posted on February 26, 2008, 2:24 pm, by christophe, under Air, Flex, SQLite.

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
  • description
  • LinkedIn
  • Pownce
  • Slashdot
  • StumbleUpon
  • Technorati
  • TwitThis
Comment (RSS)  |  Trackback

147 Comments

  1. AndyEd Says:

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

    February 26th, 2008 at 3:10 pm
  2. Steven Gemmen Says:

    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

    February 26th, 2008 at 7:07 pm
  4. Daniel Says:

    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

    March 1st, 2008 at 1:24 pm
  5. Joshua Mostafa Says:

    Great work!

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

    March 16th, 2008 at 5:25 pm
  6. » air sqlite admin Says:

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

    March 16th, 2008 at 5:34 pm
  7. Royston Shufflebotham Says:

    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.

    March 21st, 2008 at 5:28 pm
  8. joshua mostafa >> /dev/blog & » Blog Archive » simple sql batch loader in air Says:

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

    March 25th, 2008 at 9:17 pm
  9. Koen.cz » AIR API - Introduction to the SQLite Database Says:

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

    March 28th, 2008 at 1:04 am
  11. Javier Julio Says:

    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!

    April 5th, 2008 at 1:44 pm
  12. Vasile Says:

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

    April 17th, 2008 at 11:24 pm
  13. 101 Adobe AIR Resources to Add to Your Toolbelt of Awesomeness Says:

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

    April 21st, 2008 at 11:28 pm
  14. Celi Online » 101 Recursos para Adobe Air Says:

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

    April 24th, 2008 at 4:39 pm
  16. reallypride Says:

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

    April 28th, 2008 at 10:14 am
  17. cp8r Says:

    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)

    April 29th, 2008 at 10:21 am
  18. 101 Recursos para Adobe Air | Nodo54 Says:

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

    May 7th, 2008 at 12:36 pm
  19. Sağlıkpenceresi Says:

    Thank you. İts the best.

    May 13th, 2008 at 12:02 pm
  20. Sağlıksal Says:

    İts cool.

    Best Regards

    May 13th, 2008 at 12:03 pm
  21. Marcus Says:

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

    June 7th, 2008 at 4:55 pm
  22. SQLite with AIR tutorial, conquer the DB. at 9MMEDIA Blog Says:

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

    June 11th, 2008 at 2:40 pm
  23. woodstudenta Says:

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

    June 19th, 2008 at 10:44 pm
  24. dice online poker Says:

    dice online poker…

    Byzantinize unlocks misguided:grenades …

    July 7th, 2008 at 1:12 am
  25. Adobe AIR相關學習網頁 於傻仔仔 Says:

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

    July 7th, 2008 at 10:20 am
  26. Khairunnisa Says:

    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?

    July 24th, 2008 at 11:50 pm
  27. ibmblackcube Says:

    land we all green water black look jhon no boat head

    July 27th, 2008 at 8:59 pm
  28. Araba, Yarış Oyunları Says:

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

    August 6th, 2008 at 5:45 pm
  29. houseboat Says:

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

    August 19th, 2008 at 9:02 pm
  30. sohbet Says:

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

    August 22nd, 2008 at 5:28 am
  33. sohbet Says:

    Thanks. you very muck.

    August 24th, 2008 at 1:51 pm
  34. muhabbet Says:

    ooo süper this is.

    August 24th, 2008 at 1:52 pm
  40. sohbet Says:

    i like thank you

    August 30th, 2008 at 4:35 pm
  41. pot limit hold em pokher strategy Says:

    pot limit hold em pokher strategy…

    disappearances preallocated Bushnell:octagonal …

    September 5th, 2008 at 2:27 am
  42. sohbet Says:

    Sohbet Chat Muhabbet Odalari Turkish

    September 5th, 2008 at 1:57 pm
  44. ankara evden eve Says:

    Thank you very much for this useful article.

    September 10th, 2008 at 12:54 pm
  45. irc Says:

    Thank you very much

    September 14th, 2008 at 5:01 pm
  47. sohbet Says:

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

    September 18th, 2008 at 11:27 am
  49. sohbet Says:

    Thank you very much coenraets.org

    September 19th, 2008 at 4:58 am
  50. Venkat from India Says:

    Does it not support insert statements or what!??

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

    September 25th, 2008 at 12:02 am
  53. Luis Munoz Says:

    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

    October 6th, 2008 at 10:16 pm
  56. çet Says:

    thanks you good

    October 12th, 2008 at 2:02 pm
  62. Adobe AIR « Flex Generation Weblog Says:

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

    October 14th, 2008 at 3:00 am
  63. car insurance coverage Says:

    car insurance coverage…

    retrain oppressive diorama …

    October 16th, 2008 at 12:54 pm
  65. Doug Says:

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

    November 23rd, 2008 at 8:03 pm
  67. cici Says:

    ı have followed your writing for a long time.really you have given very successful information.
    In spite of my english trouale,I am trying to read and understand your writing.
    And ı am following frequently.I hope that you will be with us together with much more scharings.
    I hope that your success will go on.

    December 18th, 2008 at 9:33 pm
  68. chat Says:

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

    December 19th, 2008 at 12:11 pm
  69. sohbet Says:

    I am also getting only 3115 error when attempting to insert.

    December 19th, 2008 at 12:11 pm
  72. bizimlesohbet Says:

    thenks http://www.BizimleSohbet.com - sohbet, chat, muhabbet, sohbet odaları,sohbet sakarya,sohpet,sohbet oyun radyo,İslami Sohbet, Dini Sohbet, İslami Site, Dini Site, İslami Chat, İslami Radyo, iSlami Sohbetler, Dini Sohbetler, DiniSohbet, iSlamiSite, Dini Chat, iSlami Arkadaşlık

    December 27th, 2008 at 3:19 pm
  75. Sohbet Odalari Says:

    thanks for you job life.

    December 29th, 2008 at 5:25 am
  77. aloe Says:

    happy new year!

    December 31st, 2008 at 2:50 am
  78. Bedava Sohbet Says:

    thankx admin good your web site and post

    January 6th, 2009 at 3:53 pm
  80. ilan Says:

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

    February 1st, 2009 at 3:49 pm
  81. John Keates Says:

    This is a fine piece of work! Love this killer app :-)

    February 3rd, 2009 at 9:24 pm
  82. Daniel Says:

    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

    February 16th, 2009 at 5:39 pm
  84. ats Says:

    very good,thanks.

    February 20th, 2009 at 4:17 am
  86. toki Says:

    Is there any type of licence for using.

    February 23rd, 2009 at 4:15 pm
  87. Rosmayati Says:

    I would like to know is there any possibility to integrate sqlite with other database management system such as oracle, db2, sql server etc? If yes, how?

    February 25th, 2009 at 11:03 pm
  88. mirc Says:

    El tema de los permisos es independiente al de los plugins
    Thanks admin

    February 26th, 2009 at 3:01 am
  89. Hosting Says:

    very nice page thankss

    March 4th, 2009 at 12:18 pm
  91. george mckinney Says:

    Error 3115 : make sure your syntax is SQLite friendly. Some commands will not to work.

    FOR EXAMPLE:
    INSERT INTO foo (first_id ,second_id) VALUES (’410′, ‘99′) ;
    will generate 3115.

    AND

    INSERT INTO foo (products_id ,categories_id) VALUES (”410″, “99″) ;
    will be okay.

    What’s difference? The first one uses apostrophes while the latter uses quotation marks.

    For a better idea, see http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql.

    March 7th, 2009 at 5:08 am
  95. Türkçe mirc Says:

    thanks admin

    türkçe mirc

    April 11th, 2009 at 2:59 pm
  96. Design & Development Tutorials » Create an SQLite connection in Adobe Air Says:

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

    April 17th, 2009 at 1:49 am
  98. arkadaş Says:

    süper bir site ya:D

    April 17th, 2009 at 3:03 pm
  99. ilan Says:

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

    April 19th, 2009 at 12:56 pm
  101. mobilya Says:

    SQLite database. I use SQLite administrator which is free to download. Another good application

    May 4th, 2009 at 5:54 pm
  103. origami Says:

    origami : thanks .)

    May 11th, 2009 at 2:11 pm
  105. sohbetodaları Says:

    thanks good post

    May 13th, 2009 at 8:04 am
  108. Türkçe Forum Says:

    Thanks My Friend..

    May 15th, 2009 at 3:10 pm
  109. Chat Says:

    Thank You Admin.

    May 16th, 2009 at 1:57 pm
  111. sohbet Says:

    hallo i wish you verry succes operator

    May 17th, 2009 at 8:44 am
  112. TRsohbet Says:

    Thank You Admin.

    May 17th, 2009 at 8:48 am
  113. Edencity Says:

    hallo i wish you verry succes operator

    May 19th, 2009 at 8:35 am
  114. godstroke Says:

    thanks, and i guess you have some spam-comments in this post if you havent noticed. After the one with “george mckinney Says:” all of em are likely spam, they are in turkish, with links to some sites.

    May 19th, 2009 at 9:57 am
  115. sohbet Says:

    Thank you All..

    May 20th, 2009 at 4:05 am
  117. Radyolar Says:

    hallo i wish you verry succes operator

    May 21st, 2009 at 6:28 am
  119. hiphop Says:

    very good sites

    May 24th, 2009 at 4:18 pm
  120. Forum Says:

    Thank You well

    May 25th, 2009 at 10:16 am
  122. liseli kizlar Says:

    hallo i wish you verry succes operator

    May 26th, 2009 at 10:49 am
  123. Sohbet Says:

    hallo i wish you verry succes operator

    May 31st, 2009 at 3:35 pm
  124. sikiş filmi Says:

    Feel free to check out my blog

    June 1st, 2009 at 4:25 am
  126. Sohbet Says:

    hallo dear friends thanks a lot for your workshop

    June 5th, 2009 at 5:49 pm
  127. sohbet Says:

    You should lose the Eclipse Flex Builder properties files ettings flexProperties etc from your ZIP thougr

    June 5th, 2009 at 8:45 pm
  128. dizi izle Says:

    thanks

    dizi izle, diziizle, online dizi

    June 12th, 2009 at 9:35 am
  129. mRai Says:

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

    June 14th, 2009 at 2:06 am
  130. sikiş Says:

    thnXX Admin.

    June 15th, 2009 at 11:08 am
  133. Sohpet Says:

    thankss adamım :D

    June 16th, 2009 at 2:05 pm
  137. Muhabbet Says:

    thank youuuuuuu

    June 20th, 2009 at 11:09 am
  138. sikiş Says:

    sikis kasıyoruz

    June 23rd, 2009 at 9:45 am
  140. Jay Godse Says:

    This is a good tool if you aren’t comfortable with the SQLite command line. It’s also nice that it works in the AIR environment.

    June 26th, 2009 at 11:18 am
  141. sohbet Says:

    hi good thank you After the one with “george mckinney Says:” all of em are likely spam, they are in turkish, wINSERT INTO foo (products_id ,categories_id) VALUES (”410″, “99″) ;
    will be okay.ith links to some sites.

    June 27th, 2009 at 7:50 am
  144. sohbet Says:

    thanks you very very

    July 1st, 2009 at 1:16 pm
  145. Aşk Mesajları Says:

    I am also getting only 3115 error when attempting to insert. It is driving me crazy.

    July 1st, 2009 at 6:47 pm
  146. Özlü Sözler Says:

    This is a good tool if you aren’t comfortable with the SQLite command line

    July 1st, 2009 at 6:48 pm
  147. motosiklet Says:

    Why should we be alarmed by the coming onslaught of 400′ wind turbines? For too many reasons to list in the comments section here.

    July 2nd, 2009 at 10:50 am

Leave a Comment

« Salesbuilder for AIR 1.0
Yahoo Maps Collaboration using Flex and BlazeDS »