Main

SQLite Admin for AIR 1.0

By on February 26, 2008 in 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.

[airbadge]sqliteadmin, http://coenraets.org/air/sqliteadmin/sqliteadmin.air, v1.0, http://coenraets.org/blog/wp-content/uploads/2007/10/sqladmin.png[/airbadge]

Click here to download the source code.

Share this Article:

219 Responses to SQLite Admin for AIR 1.0

  1. AndyEd February 26, 2008 at 3:10 pm #

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

    Reply
  2. Steven Gemmen February 26, 2008 at 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

    Reply
  3. Daniel March 1, 2008 at 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

    Reply
  4. Joshua Mostafa March 16, 2008 at 5:25 pm #

    Great work!

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

    Reply
  5. Royston Shufflebotham March 21, 2008 at 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.

    Reply
  6. Javier Julio April 5, 2008 at 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!

    Reply
  7. Vasile April 17, 2008 at 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) ??

    Reply
  8. reallypride April 28, 2008 at 10:14 am #

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

    Reply
  9. cp8r April 29, 2008 at 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)

    Reply
  10. Sağlıkpenceresi May 13, 2008 at 12:02 pm #

    Thank you. İts the best.

    Reply
  11. Sağlıksal May 13, 2008 at 12:03 pm #

    İts cool.

    Best Regards

    Reply
  12. Marcus June 7, 2008 at 4:55 pm #

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

    Reply
  13. woodstudenta June 19, 2008 at 10:44 pm #

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

    Reply
  14. Khairunnisa July 24, 2008 at 11:50 pm #

    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?

    Reply
  15. ibmblackcube July 27, 2008 at 8:59 pm #

    land we all green water black look jhon no boat head

    Reply
  16. Araba, Yarış Oyunları August 6, 2008 at 5:45 pm #

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

    Reply
  17. houseboat August 19, 2008 at 9:02 pm #

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

    Reply
  18. sohbet August 22, 2008 at 5:28 am #

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

    Reply
  19. chat August 22, 2008 at 5:04 pm #

    good thanks

    Reply
  20. çet August 22, 2008 at 5:04 pm #

    thanks….

    Reply
  21. sohbet August 24, 2008 at 1:51 pm #

    Thanks. you very muck.

    Reply
  22. muhabbet August 24, 2008 at 1:52 pm #

    ooo süper this is.

    Reply
  23. kızlarla sohbet August 24, 2008 at 1:52 pm #

    thanks.

    Reply
  24. radyo dinle August 24, 2008 at 7:23 pm #

    thanks you man

    Reply
  25. hosting August 24, 2008 at 7:24 pm #

    good thanks

    Reply
  26. irc shell August 24, 2008 at 7:25 pm #

    its cool.

    Reply
  27. muhabbet August 25, 2008 at 11:11 am #

    thanks

    Reply
  28. sohbet August 30, 2008 at 4:35 pm #

    i like thank you

    Reply
  29. sohbet September 5, 2008 at 1:57 pm #

    Sohbet Chat Muhabbet Odalari Turkish

    Reply
  30. ERP Software Systems, WEB Sites Development and Design September 9, 2008 at 3:52 am #

    Very useful tool. Thank you.

    Reply
  31. ankara evden eve September 10, 2008 at 12:54 pm #

    Thank you very much for this useful article.

    Reply
  32. irc September 14, 2008 at 5:01 pm #

    Thank you very much

    Reply
  33. sohbet September 17, 2008 at 2:00 am #

    Thanks You

    Reply
  34. sohbet September 18, 2008 at 11:27 am #

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

    Reply
  35. nakliyat September 18, 2008 at 8:41 pm #

    thanks you man

    Reply
  36. sohbet September 19, 2008 at 4:58 am #

    Thank you very much coenraets.org

    Reply
  37. Venkat from India September 25, 2008 at 12:02 am #

    Does it not support insert statements or what!??

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

    Reply
  38. sohbet October 6, 2008 at 2:09 pm #

    thanks

    Reply
  39. Chat October 6, 2008 at 4:41 pm #

    Thanks You

    Reply
  40. Luis Munoz October 6, 2008 at 10:16 pm #

    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

    Reply
  41. radyo October 10, 2008 at 10:58 pm #

    danke admin

    Reply
  42. radyo dinle October 10, 2008 at 10:59 pm #

    tek yuo admin

    Reply
  43. çet October 12, 2008 at 2:02 pm #

    thanks you good

    Reply
  44. cet sohbet October 12, 2008 at 2:04 pm #

    thanks

    Reply
  45. chat October 12, 2008 at 7:59 pm #

    thank you

    Reply
  46. chat October 12, 2008 at 7:59 pm #

    thanks

    Reply
  47. gay sohbet October 12, 2008 at 8:00 pm #

    thank you admin

    Reply
  48. film izle October 13, 2008 at 2:11 am #

    thanks for you.

    Reply
  49. Sohbet October 25, 2008 at 2:03 pm #

    Thankx

    Reply
  50. Doug November 23, 2008 at 8:03 pm #

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

    Reply
  51. haberler December 1, 2008 at 11:19 pm #

    thanks you

    Reply
  52. cici December 18, 2008 at 9:33 pm #

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

    Reply
  53. chat December 19, 2008 at 12:11 pm #

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

    Reply
  54. sohbet December 19, 2008 at 12:11 pm #

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

    Reply
  55. sohbet odalari December 19, 2008 at 12:11 pm #

    tşkk :)

    Reply
  56. sohbet December 27, 2008 at 9:20 am #

    thanks baby

    Reply
  57. bizimlesohbet December 27, 2008 at 3:19 pm #

    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

    Reply
  58. mırc December 29, 2008 at 3:54 am #

    thanks.

    Reply
  59. Chat December 29, 2008 at 5:24 am #

    thnks

    Reply
  60. Sohbet Odalari December 29, 2008 at 5:25 am #

    thanks for you job life.

    Reply
  61. ssk sorgulama December 30, 2008 at 2:52 pm #

    ssk sorgulama

    tanx see you later

    Reply
  62. aloe December 31, 2008 at 2:50 am #

    happy new year!

    Reply
  63. Bedava Sohbet January 6, 2009 at 3:53 pm #

    thankx admin good your web site and post

    Reply
  64. İpucu January 31, 2009 at 4:21 am #

    Thanks…

    Reply
  65. ilan February 1, 2009 at 3:49 pm #

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

    Reply
  66. John Keates February 3, 2009 at 9:24 pm #

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

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

    Reply
  68. okeytr February 20, 2009 at 3:39 am #

    danke admin

    Reply
  69. ats February 20, 2009 at 4:17 am #

    very good,thanks.

    Reply
  70. web February 20, 2009 at 4:18 am #

    thanks.

    Reply
  71. toki February 23, 2009 at 4:15 pm #

    Is there any type of licence for using.

    Reply
  72. Rosmayati February 25, 2009 at 11:03 pm #

    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?

    Reply
  73. mirc February 26, 2009 at 3:01 am #

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

    Reply
  74. Hosting March 4, 2009 at 12:18 pm #

    very nice page thankss

    Reply
  75. sohbet March 4, 2009 at 7:28 pm #

    thank you

    Reply
  76. george mckinney March 7, 2009 at 5:08 am #

    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.

    Reply
  77. araç sorgulama March 17, 2009 at 4:54 pm #

    good thanks

    Reply
  78. mirc March 23, 2009 at 10:20 am #

    thanx

    Reply
  79. Sohbet March 25, 2009 at 5:47 pm #

    sie :D

    Reply
  80. Türkçe mirc April 11, 2009 at 2:59 pm #

    thanks admin

    türkçe mirc

    Reply
  81. MCX April 17, 2009 at 3:02 pm #

    ddd

    Reply
  82. arkadaş April 17, 2009 at 3:03 pm #

    süper bir site ya:D

    Reply
  83. ilan April 19, 2009 at 12:56 pm #

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

    Reply
  84. arkadaş,izlesene,sohbet,video,chat April 22, 2009 at 7:13 pm #

    thank

    Reply
  85. mobilya May 4, 2009 at 5:54 pm #

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

    Reply
  86. Sohbet May 10, 2009 at 11:31 pm #

    good thanks

    Reply
  87. origami May 11, 2009 at 2:11 pm #

    origami : thanks .)

    Reply
  88. Edencity May 11, 2009 at 5:11 pm #

    thanx

    Reply
  89. sohbetodaları May 13, 2009 at 8:04 am #

    thanks good post

    Reply
  90. kol saati May 13, 2009 at 11:15 am #

    Thank You..

    Reply
  91. evden eve izmir May 14, 2009 at 8:07 am #

    thansk

    Reply
  92. Türkçe Forum May 15, 2009 at 3:10 pm #

    Thanks My Friend..

    Reply
  93. Chat May 16, 2009 at 1:57 pm #

    Thank You Admin.

    Reply
  94. sohbet,chat May 17, 2009 at 2:55 am #

    thank

    Reply
  95. sohbet May 17, 2009 at 8:44 am #

    hallo i wish you verry succes operator

    Reply
  96. TRsohbet May 17, 2009 at 8:48 am #

    Thank You Admin.

    Reply
  97. Edencity May 19, 2009 at 8:35 am #

    hallo i wish you verry succes operator

    Reply
  98. godstroke May 19, 2009 at 9:57 am #

    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.

    Reply
  99. sohbet May 20, 2009 at 4:05 am #

    Thank you All..

    Reply
  100. mario oyunları May 20, 2009 at 9:31 am #

    thanks for post

    Reply
  101. Radyolar May 21, 2009 at 6:28 am #

    hallo i wish you verry succes operator

    Reply
  102. liseli kizlar May 26, 2009 at 10:49 am #

    hallo i wish you verry succes operator

    Reply
  103. Sohbet June 5, 2009 at 5:49 pm #

    hallo dear friends thanks a lot for your workshop

    Reply
  104. sohbet June 5, 2009 at 8:45 pm #

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

    Reply
  105. mRai June 14, 2009 at 2:06 am #

    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

    Reply
  106. sikiş June 23, 2009 at 9:45 am #

    sikis kasıyoruz

    Reply
  107. Jay Godse June 26, 2009 at 11:18 am #

    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.

    Reply
  108. Aşk Mesajları July 1, 2009 at 6:47 pm #

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

    Reply
  109. Özlü Sözler July 1, 2009 at 6:48 pm #

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

    Reply
  110. medyum July 4, 2009 at 5:05 am #

    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.

    Reply
  111. hikaye July 7, 2009 at 9:29 am #

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

    Reply
  112. medyum July 10, 2009 at 6:56 pm #

    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.

    Reply
  113. hikaye July 16, 2009 at 5:58 pm #

    Nice post. This post is different from what I read on most blog. And it have so many valuable things to learn. Thank you for your sharing!

    Reply
  114. cinsellik July 18, 2009 at 8:51 am #

    I am grateful to you for this great content.

    Reply
  115. radyo dinle July 19, 2009 at 9:23 am #

    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.

    Reply
  116. Radyo Gelkeyfim July 19, 2009 at 10:57 am #

    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.

    Reply
  117. CixSohbet July 19, 2009 at 3:07 pm #

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

    Reply
  118. Chris July 19, 2009 at 9:37 pm #

    Ahhh. This application is refreshingly handy. I downloaded a huge sqlite database and this tool is making it nice to explore. Plus it’s a good air application example to learn from on an unrelated air toy.

    Thank you for making this application available! I appreciate it. :)

    Best regards,

    Chris

    Reply
  119. sohbet July 20, 2009 at 5:49 pm #

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

    Reply
  120. yonja July 20, 2009 at 5:52 pm #

    thanks good post

    Reply
  121. ssk July 23, 2009 at 9:16 am #

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

    Reply
  122. zerrin egeliler July 23, 2009 at 11:34 am #

    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.

    Reply
  123. sirketler July 31, 2009 at 9:35 pm #

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

    Reply
  124. reklam July 31, 2009 at 9:36 pm #

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

    Reply
  125. yemek tarifleri August 1, 2009 at 10:18 pm #

    thank you every body.

    Reply
  126. kameralı sohbet August 5, 2009 at 5:06 am #

    ohh very good thanks you

    Reply
  127. ahmet maranki August 9, 2009 at 6:39 am #

    thnx

    Reply
  128. döviz August 9, 2009 at 7:20 am #

    ohh very good thanks you

    Reply
  129. bedava film izle August 9, 2009 at 7:24 am #

    yess very much

    Reply
  130. medyum August 10, 2009 at 7:33 am #

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

    Reply
  131. sinema izle August 14, 2009 at 9:43 am #

    thank you every body.

    Reply
  132. the sinema August 14, 2009 at 9:44 am #

    ohh very good thanks you

    Reply
  133. mp3 dinle August 16, 2009 at 9:10 am #

    very good thanks you

    Reply
  134. sohbet August 17, 2009 at 7:32 pm #

    Thnakss .

    Reply
  135. sohbet odalari August 17, 2009 at 7:33 pm #

    thnk you my admin

    Reply
  136. sohbet August 21, 2009 at 4:55 pm #

    Thank you very much admin!

    Reply
  137. Notebook August 23, 2009 at 6:35 am #

    Notebook ve notebook parçaları

    Reply
  138. Yüzbir Oyna August 25, 2009 at 7:14 pm #

    teşekkürler arkadaşım süper

    Reply
  139. sohbet,mirc,mirc indir,çet,muhabbet,chat,trsohbet August 27, 2009 at 6:56 am #

    tanks goody

    Reply
  140. alevi sohbet August 30, 2009 at 6:46 pm #

    Given that they still have a silly religious devotion to keeping the front page “clean”, it’s a wonder their other products have done as well as they have. But many of them are making progress, slowly but surely, and I suspect one day Sergey and Larry will realize that starting with “search” is actually less convenient than starting with clicks and build out the front page.

    Reply
  141. chat August 30, 2009 at 7:06 pm #

    products have done as well as they have. But many of them are making progress, slowly but surely, and

    Reply
  142. باب الحاره 4 September 5, 2009 at 11:38 pm #

    very good thanks you

    Reply
  143. free movies - rapidshare download September 8, 2009 at 1:15 am #

    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

    Reply
  144. driver indir September 9, 2009 at 4:25 pm #

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

    Reply
  145. Web development lucknow September 18, 2009 at 4:08 am #

    It is very interesting to see this tool here.
    thank you

    Reply
  146. chat September 22, 2009 at 8:42 am #

    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

    Reply
  147. aksaray September 26, 2009 at 8:04 am #

    tesekkurler

    Reply
  148. sikis September 28, 2009 at 6:35 am #

    sikiş social network

    Reply
  149. sohbet October 1, 2009 at 1:34 pm #

    Thanks. you very muck

    Reply
  150. çet October 1, 2009 at 1:36 pm #

    Thanks. you

    Reply
  151. reklam October 3, 2009 at 10:02 pm #

    thankyou mennnnnnnnÇ:S

    Reply
  152. HEEL LIFT October 6, 2009 at 12:49 am #

    Thank you a pleasant read, interesting and informative.

    Reply
  153. HEIGHT INCREASE INSOLES October 6, 2009 at 12:51 am #

    This is a very good tool

    Reply
  154. NIPPLE COVERS October 6, 2009 at 12:52 am #

    Excellent read, I am really impressed

    Reply
  155. Agustin October 8, 2009 at 11:15 pm #

    Awesome, been looking for something like this for a while!!! Is it on adobe market place?

    Reply
  156. ruyasohbet October 11, 2009 at 2:37 pm #

    I really love this post anyway and i hope you to improve your quality of article
    regards

    Reply
  157. gay sohbet October 13, 2009 at 4:19 pm #

    tahnks

    Reply
  158. Tim October 16, 2009 at 11:29 am #

    I am seeing what appears to be a bug with SQLite in Adobe Flex and in SQLAdmin, as follows:

    select t1.id, t1.descrip, t2.title
    from t1 inner join t2 on t1.id = t2.id
    where t1.desc like “xxx%”

    t1.id is integer ; t2.id is integer; t2.title is varchar

    The problem is, the correct rows from t1 are returned, but t2.title is always incorrect.

    When I examine the t2 table to determine the PK value of these wrong titles, I notice that the PK values are very close to t1.id. For example:

    t1.id = 140 and the wrong title has a PK of 1400.
    t1.id = 2530 and the wrong title has a PK of 25230.
    t1.id = 160 and the wrong title has a PK of 1610.

    It looks like a number column is being sorted as text. Perhaps an index is being turned into an array and sorted as text rather than as int?

    Please note than when I execute the identical query in other GUI query tools that work with SQLite (e.g. Razor, Visual Studio, SQL Maestro) they all agree with each other and return the correct t2.title values.

    Reply
  159. Steave October 21, 2009 at 3:48 pm #

    Great article as for me. It would be great to read a bit more about this matter.

    Reply
  160. Simon October 26, 2009 at 9:23 am #

    I’m still novice at using Adobe AIR and SQLite, but I’m in serious doubt on the SQLite syntax.
    According to the reference at : http://www.sqlite.org/lang_createtable.html , the following query should be alright ..

    CREATE TABLE `Bluueergwhatever`
    (`id` int(11) CONSTRAINT PRIMARY KEY AUTOINCREMENT,
    `name` varchar(50))

    But while playing around it seems like none of the sqlite syntax match, only the MySQL -like query syntax seems to work. What am I doing wrong ? Help is very much appreciated.

    Reply
  161. Laptop servisi December 16, 2009 at 1:45 pm #

    laptop servisi istanbul

    Reply
  162. jets vs colts live January 20, 2010 at 8:19 pm #

    yes agree with

    Reply
  163. cs forum February 26, 2010 at 1:04 pm #

    thanks ;)

    Reply
  164. Sohbet Ankara June 9, 2010 at 9:13 am #

    Wonderful Stuff you post!

    Reply
  165. Yaramaz Blog-Güncel July 1, 2010 at 6:19 am #

    güncel bilgiler,güncel blog,özgün blog

    Reply
  166. motoculteur July 6, 2010 at 10:25 pm #

    this is an amazing blog, you are a good publisher, i will return more often to your blog.

    Reply
  167. stock picking July 16, 2010 at 2:06 am #

    Really useful. Can’t believe how simple it is.

    Reply
  168. Wordpress Sites July 18, 2010 at 2:13 pm #

    Fantastic little app, thanks very much.

    Regarding the syntax, I’ve noticed that it’s the quote marks you have to be careful of (i.e. MySQL uses ` with tables whereas SQLite uses ‘ ), but I believe this is an SQLite thing and nothing to do with the app.

    Reply
  169. matbaa August 8, 2010 at 10:30 am #

    this is an amazing blog, you are a good publisher, i will return more often to your blog.

    Reply
  170. kablo tv October 9, 2010 at 2:28 am #

    thanks for article

    Reply
  171. 熱水器 October 11, 2010 at 11:03 pm #

    I see the 2concern.I am very m glad to hear that you got your Supra fixed. I remember reading about some of your problem4x !.

    Reply
  172. adem October 28, 2010 at 11:01 pm #

    Matbaa

    Reply
  173. TodayInsure Car Insurance November 8, 2010 at 4:43 pm #

    Agree with Tim that there is appears to be a bug with SQLite in Adobe Flex and in SQLAdmin.

    Reply
  174. Notebook servisi November 30, 2010 at 6:32 pm #

    this application to examine the structure of a datab

    Reply
  175. Physician Review December 13, 2010 at 1:45 am #

    Yes. I like the feature of your app where the database keeps track of the other databases. We are using similar for our structure for ours

    Reply
  176. plakalık December 14, 2010 at 5:08 pm #

    plakalık

    Reply
  177. matbaa December 26, 2010 at 12:07 pm #

    Bing recognizes the complementary benefits of bringing computational knowledge to the forefront of the search experience..

    Reply
  178. wpolscemamymocneseo January 11, 2011 at 1:14 pm #

    Nice!! Great Ifo. Great People. Great Blog. Thank you for all the great sharing that is being done here

    Reply
  179. J. January 13, 2011 at 12:15 pm #

    Hi, nice app.
    Could you make a little improvement please?
    I have a database table with lots of rows in it.
    When i execute the query the datagrid under “enter a sl statement” gets to big.
    Could you add scrollbars to it, so i can view all presented data and scroll to the right to see all colmns?

    Greets, J.
    Ps. let me know if there is a new version

    Reply
  180. Alexis January 16, 2011 at 2:59 am #

    Very nice interface for testing SQL querys, thank you!

    Reply
  181. VC February 19, 2011 at 12:05 pm #

    Has Adobe Flex “team” come to its senses to compile-in the full-text-search capabilities into any of the newer versions of AIR? In fact, has anybody at Adobe come to enough of their senses to fire those that end up making such stupid decisions – to exclude it, in the first place?

    Reply
  182. ประกันภัยรถยนต์ ราคา May 22, 2011 at 7:58 am #

    ข้อมูลดีน่าสนใจ มาก

    Reply
  183. Salman Bilgisayar June 8, 2011 at 8:04 am #

    Laptop LCD panel, keyboard, adapter, battery, hinge …

    Reply
  184. Dani June 18, 2011 at 1:49 pm #

    great,
    this is exactly what I was looking for.
    rgds

    Reply
  185. ASN Broker June 22, 2011 at 12:04 am #

    Great Info. Great Blog

    Reply
  186. ASN Broker June 22, 2011 at 12:07 am #

    Good Info, Thank you

    Reply
  187. ASN Broker June 22, 2011 at 12:07 am #

    good info, thanks

    Reply
  188. maviajansmatbaa September 16, 2011 at 11:32 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 [...]

    Reply
  189. maviajansmatbaa September 17, 2011 at 9:18 am #

    mavi ajans matbaa thanks

    Reply
  190. maviajansmatbaa September 17, 2011 at 9:20 am #

    qüzel bir çalısma olmus mavi ajans matbaa thanks

    Reply
  191. Kablonet September 20, 2011 at 9:24 am #

    Byzantinize unlocks misguided:grenades …

    Reply
  192. Kablonet September 20, 2011 at 9:25 am #

    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.

    Reply
  193. Kablonet September 20, 2011 at 9:29 am #

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

    Reply
  194. Uydunet October 21, 2011 at 6:35 pm #

    Good. vThank you very much.

    Reply
  195. tanaka March 31, 2012 at 12:51 pm #

    sugoiyokattayo
    matakurune

    Reply
  196. Independent Review Organization August 15, 2012 at 11:00 pm #

    This is a great use of SQL to access databases quickly! Thank you so much for sharing!

    Reply

Trackbacks/Pingbacks

  1. SQLite Admin for AIR 1.0 | Adobe AIR Tutorials - February 28, 2008

    [...] more @ http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]
  2. » air sqlite admin - March 16, 2008

    [...] just came across this AIR-based SQLite [...]
  3. joshua mostafa >> /dev/blog & » Blog Archive » simple sql batch loader in air - March 25, 2008

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

    [...] 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. CornFlex - Flex & Flash by Quentin Lengelé » Blog Archive » SQLite Admin for AIR 1.0 - March 28, 2008

    [...] Source : http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10 [...]
  6. 101 Adobe AIR Resources to Add to Your Toolbelt of Awesomeness - April 21, 2008

    [...] SQLite Admin for AIR 1.0 – coenraets.org [...]
  7. Celi Online » 101 Recursos para Adobe Air - April 24, 2008

    [...] SQLite Admin for AIR 1.0 – coenraets.org [...]
  8. 101 Adobe AIR Resources to Add to Your Toolbelt of Awesomeness | AIR + Flex Laboratory. - April 27, 2008

    [...] SQLite Admin for AIR 1.0 – coenraets.org [...]
  9. 101 Recursos para Adobe Air | Nodo54 - May 7, 2008

    [...] SQLite Admin for AIR 1.0 – coenraets.org [...]
  10. SQLite with AIR tutorial, conquer the DB. at 9MMEDIA Blog - June 11, 2008

    [...] 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. dice online poker - July 7, 2008

    dice online poker…

    Byzantinize unlocks misguided:grenades …
  12. Adobe AIR相關學習網頁 於傻仔仔 - July 7, 2008

    [...] 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. pot limit hold em pokher strategy - September 5, 2008

    pot limit hold em pokher strategy…

    disappearances preallocated Bushnell:octagonal …
  14. Adobe AIR « Flex Generation Weblog - October 14, 2008

    [...] Christophe Coenraets :: SQLite Admin Application for AIR [...]
  15. car insurance coverage - October 16, 2008

    car insurance coverage…

    retrain oppressive diorama …
  16. Design & Development Tutorials » Create an SQLite connection in Adobe Air - April 17, 2009

    [...] 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. As melhores aplicações AIR para Designers e Developers « - September 14, 2009

    [...] 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. Comunidade Portuguesa de Rich Internet Applications» Blog Archive » Parte I – Flex, AIR & SQLite - September 30, 2009

    [...] mais informações sobre SQLite no AIR: http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]
  19. Tutorial parte I – Flex Air e SQLite at iMauro blog - October 1, 2009

    [...] mais informações sobre SQLite no AIR: http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]
  20. 超全的AIR学习资源网址大全 - October 22, 2009

    [...] 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 [...]
  21. SQLiteのGUI管理ツールを紹介 | Mtok-blog - April 15, 2010

    [...] SQLite Admin AIR [...]
  22. KEMURI » SQLite Admin für AIR - June 9, 2010

    [...] http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]
  23. Adobe AIR – Utilisation d'une base SQLite locale - Adobe Flex Tutorial - Tutoriaux Flex Builder, MXML, ActionScript, AS3 - January 23, 2011

    [...] SQLite Admin AIR Application [...]

Leave a Reply


+ 1 = 2

Powered by WordPress. Designed by Woo Themes