SQLite Admin for AIR 1.0

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.

169 Comments

  1. haberler
    Posted December 1, 2008 at 11:19 pm | Permalink

    thanks you

  2. cici
    Posted December 18, 2008 at 9:33 pm | Permalink

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

  3. chat
    Posted December 19, 2008 at 12:11 pm | Permalink

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

  4. sohbet
    Posted December 19, 2008 at 12:11 pm | Permalink

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

  5. sohbet odalari
    Posted December 19, 2008 at 12:11 pm | Permalink

    tşkk :)

  6. sohbet
    Posted December 27, 2008 at 9:20 am | Permalink

    thanks baby

  7. bizimlesohbet
    Posted December 27, 2008 at 3:19 pm | Permalink

    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

  8. mırc
    Posted December 29, 2008 at 3:54 am | Permalink

    thanks.

  9. Chat
    Posted December 29, 2008 at 5:24 am | Permalink

    thnks

  10. Sohbet Odalari
    Posted December 29, 2008 at 5:25 am | Permalink

    thanks for you job life.

  11. ssk sorgulama
    Posted December 30, 2008 at 2:52 pm | Permalink

    ssk sorgulama

    tanx see you later

  12. aloe
    Posted December 31, 2008 at 2:50 am | Permalink

    happy new year!

  13. Bedava Sohbet
    Posted January 6, 2009 at 3:53 pm | Permalink

    thankx admin good your web site and post

  14. İpucu
    Posted January 31, 2009 at 4:21 am | Permalink

    Thanks…

  15. ilan
    Posted February 1, 2009 at 3:49 pm | Permalink

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

  16. John Keates
    Posted February 3, 2009 at 9:24 pm | Permalink

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

  17. Daniel
    Posted February 16, 2009 at 5:39 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

  18. okeytr
    Posted February 20, 2009 at 3:39 am | Permalink

    danke admin

  19. ats
    Posted February 20, 2009 at 4:17 am | Permalink

    very good,thanks.

  20. web
    Posted February 20, 2009 at 4:18 am | Permalink

    thanks.

  21. toki
    Posted February 23, 2009 at 4:15 pm | Permalink

    Is there any type of licence for using.

  22. Rosmayati
    Posted February 25, 2009 at 11:03 pm | Permalink

    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?

  23. mirc
    Posted February 26, 2009 at 3:01 am | Permalink

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

  24. Hosting
    Posted March 4, 2009 at 12:18 pm | Permalink

    very nice page thankss

  25. sohbet
    Posted March 4, 2009 at 7:28 pm | Permalink

    thank you

  26. george mckinney
    Posted March 7, 2009 at 5:08 am | Permalink

    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.

  27. araç sorgulama
    Posted March 17, 2009 at 4:54 pm | Permalink

    good thanks

  28. mirc
    Posted March 23, 2009 at 10:20 am | Permalink

    thanx

  29. Sohbet
    Posted March 25, 2009 at 5:47 pm | Permalink

    sie :D

  30. Türkçe mirc
    Posted April 11, 2009 at 2:59 pm | Permalink

    thanks admin

    türkçe mirc

  31. MCX
    Posted April 17, 2009 at 3:02 pm | Permalink

    ddd

  32. arkadaş
    Posted April 17, 2009 at 3:03 pm | Permalink

    süper bir site ya:D

  33. ilan
    Posted April 19, 2009 at 12:56 pm | Permalink

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

  34. arkadaş,izlesene,sohbet,video,chat
    Posted April 22, 2009 at 7:13 pm | Permalink

    thank

  35. mobilya
    Posted May 4, 2009 at 5:54 pm | Permalink

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

  36. Sohbet
    Posted May 10, 2009 at 11:31 pm | Permalink

    good thanks

  37. origami
    Posted May 11, 2009 at 2:11 pm | Permalink

    origami : thanks .)

  38. Edencity
    Posted May 11, 2009 at 5:11 pm | Permalink

    thanx

  39. sohbetodaları
    Posted May 13, 2009 at 8:04 am | Permalink

    thanks good post

  40. kol saati
    Posted May 13, 2009 at 11:15 am | Permalink

    Thank You..

  41. evden eve izmir
    Posted May 14, 2009 at 8:07 am | Permalink

    thansk

  42. Türkçe Forum
    Posted May 15, 2009 at 3:10 pm | Permalink

    Thanks My Friend..

  43. Chat
    Posted May 16, 2009 at 1:57 pm | Permalink

    Thank You Admin.

  44. sohbet,chat
    Posted May 17, 2009 at 2:55 am | Permalink

    thank

  45. sohbet
    Posted May 17, 2009 at 8:44 am | Permalink

    hallo i wish you verry succes operator

  46. TRsohbet
    Posted May 17, 2009 at 8:48 am | Permalink

    Thank You Admin.

  47. Edencity
    Posted May 19, 2009 at 8:35 am | Permalink

    hallo i wish you verry succes operator

  48. godstroke
    Posted May 19, 2009 at 9:57 am | Permalink

    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.

  49. sohbet
    Posted May 20, 2009 at 4:05 am | Permalink

    Thank you All..

  50. mario oyunları
    Posted May 20, 2009 at 9:31 am | Permalink

    thanks for post

22 Trackbacks

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>