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.

  • Digg
  • del.icio.us
  • Facebook
  • Google
  • description
  • LinkedIn
  • Pownce
  • Slashdot
  • StumbleUpon
  • Technorati
  • TwitThis

147 Comments

  1. AndyEd Says:

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

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

  4. Great work!

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

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

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

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

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

  9. 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!

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

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

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

  13. reallypride Says:

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

  14. 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)

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

  16. Thank you. İts the best.

  17. İts cool.

    Best Regards

  18. Marcus Says:

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

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

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

  21. dice online poker…

    Byzantinize unlocks misguided:grenades …

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

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

  24. land we all green water black look jhon no boat head

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

  26. houseboat Says:

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

  27. sohbet Says:

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

  28. sohbet Says:

    Thanks. you very muck.

  29. muhabbet Says:

    ooo süper this is.

  30. sohbet Says:

    i like thank you

  31. pot limit hold em pokher strategy…

    disappearances preallocated Bushnell:octagonal …

  32. sohbet Says:

    Sohbet Chat Muhabbet Odalari Turkish

  33. Thank you very much for this useful article.

  34. irc Says:

    Thank you very much

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

  36. sohbet Says:

    Thank you very much coenraets.org

  37. 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″?

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

  39. çet Says:

    thanks you good

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

  41. car insurance coverage…

    retrain oppressive diorama …

  42. Doug Says:

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

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

  44. chat Says:

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

  45. sohbet Says:

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

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

  47. thanks for you job life.

  48. aloe Says:

    happy new year!

  49. thankx admin good your web site and post

  50. ilan Says:

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

  51. John Keates Says:

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

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

  53. ats Says:

    very good,thanks.

  54. toki Says:

    Is there any type of licence for using.

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

  56. mirc Says:

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

  57. Hosting Says:

    very nice page thankss

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

  59. thanks admin

    türkçe mirc

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

  61. arkadaş Says:

    süper bir site ya:D

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

  63. mobilya Says:

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

  64. origami Says:

    origami : thanks .)

  65. thanks good post

  66. Thanks My Friend..

  67. Chat Says:

    Thank You Admin.

  68. sohbet Says:

    hallo i wish you verry succes operator

  69. TRsohbet Says:

    Thank You Admin.

  70. Edencity Says:

    hallo i wish you verry succes operator

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

  72. sohbet Says:

    Thank you All..

  73. Radyolar Says:

    hallo i wish you verry succes operator

  74. hiphop Says:

    very good sites

  75. Forum Says:

    Thank You well

  76. hallo i wish you verry succes operator

  77. Sohbet Says:

    hallo i wish you verry succes operator

  78. Feel free to check out my blog

  79. Sohbet Says:

    hallo dear friends thanks a lot for your workshop

  80. sohbet Says:

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

  81. dizi izle Says:

    thanks

    dizi izle, diziizle, online dizi

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

  83. sikiş Says:

    thnXX Admin.

  84. Sohpet Says:

    thankss adamım :D

  85. Muhabbet Says:

    thank youuuuuuu

  86. sikiş Says:

    sikis kasıyoruz

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

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

  89. sohbet Says:

    thanks you very very

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

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

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

Leave a Comment