New AIR SQLite Administration App (with Source Code)

UPDATE: This version is now obsolete. A new version is available here.

Here is an updated/rewritten version of my AIR SQLite Admin application. 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 new 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.

This new version uses synchronous database operations (AIR beta 1 only supported asynchronous database access), and uses the schema API (also new in beta 2) to show you the list of tables and columns available in your database.

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

Click here to install the application.

Click here to download the source code.

,

63 Responses to New AIR SQLite Administration App (with Source Code)

  1. Anonymous October 26, 2007 at 8:11 am #

    Sounds good. But what is AIR?

  2. JJ October 26, 2007 at 10:22 am #

    Adobe Integrated Runtime, a product that will allow you to create Flex applications for the desktop: http://labs.adobe.com/technologies/air/

  3. Theo October 27, 2007 at 9:15 am #

    Why doesn’t it let me open files other than those with a .db extension? Most SQLite databases I have encountered does not use any particular extension.

  4. Jason The Saj October 30, 2007 at 1:52 pm #

    Is there a means to create fields and field entry values?

  5. Dan Wilson October 31, 2007 at 9:52 am #

    It seems the application does not handle SQL statements with single quotes in it. I fixed this using prepared statements. The only file that needed modification was src/cache.as .

    More details (and the file) are here:
    http://www.nodans.com/index.cfm/2007/10/31/Fixed-error-in-SQLLite-Administration-tool

    Dan Wilson

  6. Francois Botha November 7, 2007 at 2:19 am #

    What’s that font in the screenshot? Love it! Want it!

  7. Eric December 1, 2007 at 2:18 am #

    Francois: The font is Myriad Web Pro and is included in the source code.

  8. jacob December 15, 2007 at 12:02 pm #

    hi, nice program you’ve made.

    But.. the refresh button does not always work.
    i discovered it by creating 1 table and after creating used drop tablename to delete it.
    when i use the refresh button, it shows me the same table… but if i restart the program it is gone as it should be.

    maybe a little bug, so i report it to you.

    Greetz, jacob

    ps. i hope you understand my english.. im from holland so my english is not so verry well.

  9. JJ January 1, 2008 at 11:36 am #

    It’s no more compatible with the new AIR

  10. Mike January 2, 2008 at 7:31 am #

    1 question: when you use sqladmindemo.db do you have to be administrator on Windows to be able to do CRUD operations?

  11. Will January 4, 2008 at 7:41 pm #

    Any plans to update it for the latest AIR builds? Im on beta3 at the moment and it says the install is not compatible

  12. Guneet January 16, 2008 at 9:23 pm #

    I have modified the code to make it compatible to Flex 3 Beta 3. The Following are the changes that I made.

    1. Changed File.applicationResourceDirectory to
    File.applicationStorageDirectory

    2. Changed all the instances of sqlConnection.getFile().nativePath to file.nativePath

    Hope this helps. Thanks

  13. Varun Shetty January 17, 2008 at 4:08 pm #

    hey.. the application is not installing.

    mebbe the AIR update isnt allowing me to install it.

    does this app run on the latest AIR player..?

  14. vinç February 17, 2008 at 4:50 pm #

    Hope this helps. Thanks.

    ysbostan

  15. Phil July 9, 2008 at 6:36 am #

    Looks like this needs to be updated for Air 1.1. Can you post a current build?? TIA!

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

    Güzel bilgiler teşkkürler…

  17. Savaş Oyunları August 7, 2008 at 6:34 am #

    Wowww…This is what i need..thanks…

  18. Kız Oyunları August 7, 2008 at 6:35 am #

    Congrulations for this nice web design..Usefull..

  19. chat August 22, 2008 at 5:48 am #

    It’s no more compatible with the new AIR

  20. sohbet August 22, 2008 at 5:49 am #

    Güzel bilgiler teşkkürler…

  21. radyo dinle August 22, 2008 at 5:49 am #

    Congrulations for this nice web design..Usefull..

  22. forum August 22, 2008 at 5:50 am #

    thanks ;)

  23. key ödemeleri August 28, 2008 at 3:34 pm #

    thank you for sharing this website

  24. lapto battery November 20, 2008 at 9:23 pm #

    I have modified the code to make it compatible to Flex 3 Beta 3. The Following are the changes that I made.

    1. Changed File.applicationResourceDirectory to
    File.applicationStorageDirectory

    2. Changed all the instances of sqlConnection.getFile().nativePath to file.nativePath

    Hope this helps. Thanks

  25. BedOrdeltdype December 27, 2008 at 8:45 am #

    Hi your website is cool
    I have a new band and we just had a live gig u can see here:
    http://tinyurl.com/7x2s6l

  26. sohbet January 7, 2009 at 1:10 pm #

    […] También existe un gestor de SQLite con código fuente icluido aquí […]

  27. araç sorgulama March 17, 2009 at 5:02 pm #

    banally Liverpool fidget …

  28. Raj May 21, 2009 at 2:44 am #

    Hi all,
    I’m new to AIR & Flex, I’m getting below error msg while compiling for

    sqlConnection = new SQLConnection(true); //cache.as

    plz help me.

    Error:

    1137: Incorrect number of arguments. Expected no more than 0. sqladmin Cache.as

  29. ssk July 23, 2009 at 9:27 am #

    hi, nice program you’ve made.

    But.. the refresh button does not always work.
    i discovered it by creating 1 table and after creating used drop tablename to delete it.
    when i use the refresh button, it shows me the same table… but if i restart the program it is gone as it should be.

    maybe a little bug, so i report it to you.

    Greetz, jacob

    ps. i hope you understand my english.. im from holland so my english is not so verry well.

  30. zerrin egeliler July 23, 2009 at 11:45 am #

    Congrulations for this nice web design..Usefull..

  31. Степан Кузнецов July 28, 2009 at 9:37 am #

    Читаю что Вы пишете – дом2 почему-то вспоминается :)

  32. Афанасий August 18, 2009 at 6:21 am #

    Занятно. Иногда такое бывает, что хоть стой хоть падай.

  33. Bebeshka August 21, 2009 at 1:09 pm #

    Ну и после такого, как говорится, хотелось бы заслушать начальника транспортного цеха ;)

  34. Araba Oyunları October 14, 2009 at 5:38 pm #

    And I t dfg

  35. Savaş Oyunları October 14, 2009 at 5:38 pm #

    And I t um

  36. chat odası November 24, 2009 at 6:25 am #

    how are you babyy

  37. chat December 4, 2009 at 7:07 am #

    hi…. the application is not installing.

    mebbe the AIR update isnt allowing me to install it.

    does this app run on the latest AIR player..?

  38. rottweiler July 16, 2010 at 9:13 pm #

    thanks for information

  39. cindy July 24, 2010 at 10:24 am #

    thanks for letting us know about the new version, very much appreciated

  40. matbaa August 8, 2010 at 9:26 am #

    Francois: The font is Myriad Web Pro and is included in the source code.

  41. canlı sohbet September 23, 2010 at 5:38 am #

    thx.

  42. kablo tv October 9, 2010 at 3:28 am #

    thanks for article

  43. sohbet siteleri October 22, 2010 at 10:32 am #

    thhhh

  44. Chat February 20, 2011 at 11:27 am #

    Thank you for sharing your article I would always follow.

  45. Cheap DG Shoes June 13, 2011 at 4:24 am #

    Cheap DG Shoes Make your first step from Gucci outlet, you will definitely be the most vogue! Follow Gucci, follow the fashion!

  46. porno sohbet August 9, 2011 at 11:44 am #

    thank you admınn .1

  47. Cheap Gucci Shoes for Mens August 20, 2011 at 2:49 pm #

    Real gucci shoes for cheap re-interpreting signature styles with a fresh eye and a contemporary approach..

  48. Dolce Gabbana Clothing August 22, 2011 at 9:14 pm #

    one is high-end professional-grade headphones, which are mostly used by people make a career in music; the other type is best quality high-end headphones, what fanciers pursue

  49. maviajansmatbaa September 16, 2011 at 11:35 am #

    kareena nude totally…

  50. maviajansmatbaa September 17, 2011 at 9:23 am #

    mavi ajans matbaa kendi alanında uzman kadrosuyla ve yaptıkları çalışmalarıyla bir adım önde baslayın mavi ajans matbaa

  51. Evering2010 September 19, 2011 at 3:50 am #

    discount coach site

  52. jorje June 26, 2013 at 1:32 am #

    Take a look on a free tool — Valentina Studio. Amazing product! This is excellent tool for PostgreSQL database administration and development. http://www.valentina-db.com/en/valentina-studio-overview

Trackbacks/Pingbacks

  1. AIR SQLite Administration APP (sourcecode included) by Christophe Coenraets « Cyberspace Nova - October 26, 2007

    […] Published October 26th, 2007 AIR – ex Apollo , Actionscript 3.0 , Applications Christophe Coenraets built interesting and very usefull app in AIR that allows you to admin your SQLite databases… Could prove very usefull if you are […]

  2. Burmeseked.Com » New AIR SQLite Administration App (with Source Code) - October 28, 2007

    […] Fogg wrote an interesting post today on New AIR SQLite Administration App (with Source Code)Here’s a quick […]

  3. IL.Blog » Blog Archive » SQLite + Air - October 29, 2007

    […] También existe un gestor de SQLite con código fuente icluido aquí […]

  4. guaranteed school loans - February 9, 2008

    guaranteed school loans…

    anchored volatilities:swimmer!butcher complaints?profusion …

  5. help my credit - February 9, 2008

    help my credit…

    reversal elaborating?solely pelican shareholders …

  6. guaranteed unsecured visa credit cards - February 14, 2008

    guaranteed unsecured visa credit cards…

    domesticate conditioners.purring!twined:villas …

  7. Anonymous - March 24, 2008

    kareena nude totally…

    kareena nude totally…

  8. Anonymous - April 3, 2008

    heidi cortez nude gallery…

    heidi cortez nude gallery…

  9. Anonymous - April 3, 2008

    family guy hentai porn…

    family guy hentai porn…

  10. Anonymous - April 3, 2008

    ghost in shell hentai porn…

    ghost in shell hentai porn…

  11. Solution Hacker » Adobe Air with SQLite database - July 2, 2009

    […] Another SQLite admin tool by Christophe Coenraets (10/2007) […]

Leave a Reply

css.php