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.

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

227 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!

  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

  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

  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 …

  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.

  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!

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

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

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

  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)

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

    Thank you. İts the best.

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

    İts cool.

    Best Regards

  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!

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

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

  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?

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

    land we all green water black look jhon no boat head

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

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

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

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

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

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

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

    good thanks

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

    thanks….

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

    Thanks. you very muck.

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

    ooo süper this is.

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

    thanks.

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

    thanks you man

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

    good thanks

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

    its cool.

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

    thanks

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

    i like thank you

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

    Sohbet Chat Muhabbet Odalari Turkish

  30. Very useful tool. Thank you.

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

    Thank you very much for this useful article.

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

    Thank you very much

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

    Thanks You

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

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

    thanks you man

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

    Thank you very much coenraets.org

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

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

    thanks

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

    Thanks You

  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

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

    danke admin

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

    tek yuo admin

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

    thanks you good

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

    thanks

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

    thank you

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

    thanks

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

    thank you admin

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

    thanks for you.

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

    Thankx

  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?

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

    thanks you

  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.

  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?

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

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

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

    tşkk :)

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

    thanks baby

  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

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

    thanks.

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

    thnks

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

    thanks for you job life.

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

    ssk sorgulama

    tanx see you later

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

    happy new year!

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

    thankx admin good your web site and post

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

    Thanks…

  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?

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

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

  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

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

    danke admin

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

    very good,thanks.

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

    thanks.

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

    Is there any type of licence for using.

  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?

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

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

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

    very nice page thankss

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

    thank you

  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.

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

    good thanks

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

    thanx

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

    sie :D

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

    thanks admin

    türkçe mirc

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

    ddd

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

    süper bir site ya:D

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

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

    thank

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

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

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

    good thanks

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

    origami : thanks .)

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

    thanx

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

    thanks good post

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

    Thank You..

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

    thansk

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

    Thanks My Friend..

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

    Thank You Admin.

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

    thank

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

    hallo i wish you verry succes operator

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

    Thank You Admin.

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

    hallo i wish you verry succes operator

  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.

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

    Thank you All..

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

    thanks for post

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

    hallo i wish you verry succes operator

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

    hallo i wish you verry succes operator

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

    hallo dear friends thanks a lot for your workshop

  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

  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

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

    sikis kasıyoruz

  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.

  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.

  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

  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.

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

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

  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.

  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!

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

    I am grateful to you for this great content.

  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.

  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.

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

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

  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

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

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

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

    thanks good post

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

  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.

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

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

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

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

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

    thank you every body.

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

    ohh very good thanks you

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

    thnx

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

    ohh very good thanks you

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

    yess very much

  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.

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

    thank you every body.

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

    ohh very good thanks you

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

    very good thanks you

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

    Thnakss .

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

    thnk you my admin

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

    Thank you very much admin!

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

    Notebook ve notebook parçaları

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

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

  139. tanks goody

  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.

  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

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

    very good thanks you

  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

  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

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

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

  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

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

    tesekkurler

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

    sikiş social network

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

    Thanks. you very muck

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

    Thanks. you

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

    thankyou mennnnnnnnÇ:S

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

    Thank you a pleasant read, interesting and informative.

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

    This is a very good tool

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

    Excellent read, I am really impressed

  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?

  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

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

    tahnks

  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.

  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.

  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.

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

    laptop servisi istanbul

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

    yes agree with

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

    thanks ;)

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

    Wonderful Stuff you post!

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

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

  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.

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

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

  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.

  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.

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

    thanks for article

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

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

    Matbaa

  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.

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

    this application to examine the structure of a datab

  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

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

    plakalık

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

  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

  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

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

    Very nice interface for testing SQL querys, thank you!

  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?

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

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

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

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

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

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

    Great Info. Great Blog

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

    Good Info, Thank you

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

    good info, thanks

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

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

    mavi ajans matbaa thanks

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

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

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

    Byzantinize unlocks misguided:grenades …

  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.

  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.

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

    Good. vThank you very much.

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

    sugoiyokattayo
    matakurune

  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!

  197. apk indir July 21, 2013 at 6:23 pm #

    o maiii ghatt :)

  198. ofis mobilyaları August 4, 2013 at 8:32 am #

    thank you every body.

  199. sohbetci August 21, 2013 at 1:32 am #

    yonca sohbet chat odaları

  200. metin yang August 24, 2013 at 2:32 pm #

    metin2 yang metin2 ep ürünleri

  201. kolay toner September 12, 2013 at 11:41 am #

    İts cool.

  202. Evden Eve February 28, 2014 at 4:36 pm #

    Evden Eve Nakliyat İş İlanları Platformu
    EVDEN EVE NAKLİYAT PLATFORMU

  203. Sohbet June 7, 2014 at 8:43 am #

    güzel anlatım.

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