SQLite Admin Application for AIR

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

I put together this SQL Admin application to help me manipulate my SQLite databases when working with AIR.

The application is based on the SQL Admin for Google Gears I posted recently.

This is an early version and is not fully functional. For example, because in this beta of AIR we don’t expose system tables, I cannot display a list of all tables in the database (In SQLite, this is normally done using SELECT * FROM SQLITE_MASTER). However, you can use the application to create a new database or open an existing one, and execute any type of SQL statement: You can create, alter and drop tables, select, insert, update, delete data, etc…

Guided tour:

To create a new database:

  1. Click New Database
  2. Navigate to a directory of your choice
  3. Specify a file name for the database. For example test.db

To open an existing database:

  1. Click Open Database
  2. Navigate to the database directory, select the database file, and click Open

To add a table, click New Query and type a create statement (or drag “CREATE” from the list of syntax hints in the lower left corner of the screen), and drop it in the Query window.

To insert, update, or delete data, type the corresponding statements in a query window, or drag-and-drop syntax hints from the lower left corner of the screen.

Click here to install the application.

Click here to download the source code.

59 Responses to SQLite Admin Application for AIR

  1. AJ June 13, 2007 at 10:09 am #

    Awesome! You just saved me a day of work. Keep up the great work :)

  2. Jim June 13, 2007 at 10:14 am #

    Is there any reason why the system tables are not exposed, do you know? Just curious (it’s stopping me from updating an old swhx project to AIR, but it can wait …)

  3. christophe June 13, 2007 at 10:26 am #

    Jim,
    The current idea is to expose an API to expose the schema, as opposed to relying on database specific syntax. That API didn’t make it into the beta.
    Christophe

  4. Tek June 13, 2007 at 12:04 pm #

    Awesome work, thank you very much !

    It seems to me the better way to start to learn SLQLite admin with Apollo. Like Jim, I’m waiting for the full support for system tables.

  5. Jim June 13, 2007 at 12:45 pm #

    thanks Christophe, the schema API seems like a better idea to me in the longer term (especially if other db support were ever to be added), I’ll look forward to seeing it.

  6. max June 13, 2007 at 1:03 pm #

    This application could not be installed or launched (AIR file D:\Eigene Dateien emotionslos\Eigene Downloads\airsqladmin.air is invalid: Unrecognized version namespace “http://ns.adobe.com/air/application/1.0.M4″.).

    Does someone have any idea whats going wrong? I’ve installed the flex3 beta, but isnt that required?

  7. Jorge Hernandez June 13, 2007 at 1:18 pm #

    Good work with this usage of the sqldb API. I’ll keep you posted on the schema API when I find out more.

  8. Jhecht June 16, 2007 at 5:02 pm #

    What’s the extension for a “database” file? I created a database file called test, but i didn’t give it an extension and now i can’t open it because it’s not a database file. Email me or something. Thanks

  9. Chris Turvey June 22, 2007 at 6:36 am #

    Jhecht,

    The extension for the database would be “.db” … It seems to work pretty well…I had initially not given an extension either… I just tried the “.db” extension… Had that not worked I would have probably read the code to see if I could figure it out.

  10. find valium buy August 4, 2007 at 12:38 pm #

    buy delivery valium from buy valium

  11. Mounstar August 27, 2007 at 5:22 pm #

    god bless the masters!!! really cool!

  12. watch replica October 15, 2007 at 9:36 am #

    Our watch replica price is cheaper than other website, and the watch replica is the good watch. you can choose any watch replica to placed order, Once we receive your payment, we will handle the watch replica shipment.

  13. Cyrille October 16, 2007 at 11:46 am #

    No release for AIR 2 ?

  14. fordmusta October 19, 2007 at 11:19 am #

    Hi!! This is my site.
    black bondage fucking

  15. hgfjkdlsiu October 19, 2007 at 1:02 pm #

    Hi!! This is my site.
    black bondage fucking

  16. gdskglotuy October 20, 2007 at 11:51 am #

    Hi!! This is my site.
    couple fucking pic

  17. XRumakTheBest November 6, 2007 at 5:08 pm #

    XRumer 4.0 is the perfect tool for promotion!
    It’s have CAPTCHA recognizer, email verificator, and a lot of other functions…

    But. I forgot link to it :(

    Can you give me URL to the xrumer description? screenshots, etc.

    Thanks

  18. flashcrobat December 19, 2007 at 4:09 pm #

    Hi, I always follow your blog and have got great help uot of it. somehow when I try to install your air application, I get an installation error message:
    ‘This application requires a version of Adobe AIR which is no longer supported. Please contact the application author for an updated version.’
    any advice?
    cheers

  19. Mehmet Mehmetoğlu April 14, 2008 at 7:55 am #

    thank’s. thats great.

    please un comment for bots..

  20. Mehmet Mehmetoğlu April 14, 2008 at 8:00 am #

    This application requires a version of Adobe AIR which is no longer supported. Please contact the application author for an updated version.

    this your program install error

  21. Benchiktovchik June 5, 2008 at 10:46 am #

    Приветствую всех!
    У меня такой вопрос,кто что интересное подскажет буду признателен.
    Мы с друзьями собираемся поехать в круиз по просторам России и ближнего зарубежья месяца на два на своих машинах,но не как не можем согласовать маршрут,если у кого уже был опыт такого путешествия,может,что посоветуете.Девчонок с собой не берем,думаем,что во все городах России с этим не будет проблем,если у кого будут рекомендации и в вопросе отдыха с девушками тоже буду признателен.

    С уважением Сеньчик

  22. alice August 5, 2008 at 6:18 am #

    d1PMZ1 xf78fg623fv0skghlq56fd

  23. chat August 22, 2008 at 6:37 am #

    Good work with this usage of the sqldb API. I’ll keep you posted on the schema API when I find out more.

  24. çet August 22, 2008 at 6:37 am #

    thank’s. thats great.

  25. sohbet August 22, 2008 at 6:38 am #

    Hi!! Good work!!

  26. lesbian bond licking August 24, 2008 at 10:12 pm #

    bond lesbian julia bond lesbian bound

  27. Assorscog September 3, 2008 at 2:01 am #

    cheap revolver hillcountryrifles lasers for pistols indoor pistol range construction highpower rifle sale

  28. Игорь August 18, 2009 at 7:08 pm #

    Весьма спорно, но как вариант имеет право на жизнь

  29. sxe May 20, 2010 at 5:57 pm #

    thanks your post admin…Good work.

  30. sxe indir June 21, 2010 at 2:10 pm #

    Thanks your good post admin.

  31. matbaa August 8, 2010 at 8:55 am #

    What’s the extension for a “database” file? I created a database file called test, but i didn’t give it an extension and now i can’t open it because it’s not a database file. Email me or something. Thanks

  32. pornoizle August 14, 2010 at 1:27 pm #

    but i didn’t give it an extension and now i can’t open it because it’s not a database file. Email me or something.

  33. diziizle August 14, 2010 at 1:28 pm #

    sion for a “database” file? I created a database file called test,

  34. free August 14, 2010 at 1:29 pm #

    Once we receive your payment, we will handle the watch replica shipment.

  35. canlı sohbet September 23, 2010 at 5:37 am #

    thx..

  36. chat February 19, 2011 at 10:55 am #

    thanks you for sharings very good posts chat
    chat sohbet siteleri

  37. sohbet February 19, 2011 at 10:58 am #

    chat sohbet yapan insanların girdiği bir site sizde chat yapmak için girmek zorunda değilsiniz keyfiniz bilir sohbet yapan insanlar genelde girerler chat yapmak istiyorsanız girin:)

  38. canlı sohbet February 19, 2011 at 10:59 am #

    bu siteye girmek chat yapmak canlı sohbet odalarında gezinmek sizin elinizde canlı sohbet için sitemizin sohbet alanına giriniz.

  39. porno sohbet August 9, 2011 at 11:55 am #

    nice admınnn 1

  40. maviajansmatbaa September 16, 2011 at 11:36 am #

    [...] Optionally start the AIR SQLite Admin tool. [...]

  41. Sohbet December 3, 2012 at 11:18 am #

    Bilgilendirme için teşekkürler sitenizdeki paylaşımlarınızı çok başarılı buluyorum başarılarınızın devamını dilerim.

  42. заработок в интернете February 14, 2013 at 5:54 am #

    Супермнеоченьулыбнуло.Язачастуюинтересуюсьценнуюинфу.большое спасибоза то,что вы естьволотили в жизнь.вдругзахотитеуделите вниманиевидео. вамуверенпонравится

  43. Как заработать в интернете самая стратегия начать заработок в интернете. любой может зарабатывать в интернете и я тут что бы каждый имел свой кусок

Trackbacks/Pingbacks

  1.   Super-simple SQLite example for Adobe AIR 1 Beta by Sean Moore: ActionScript Coder - June 14, 2007

    [...] Here is a very simplistic example that adds and removes records from a table in a local SQLite database. This is not a fully completed AIR project but this code can probably be reused by anyone wanting to get started with AIR+SQLite. There are a couple of other AIR+SQLite examples out there to check out and don’t forget the documentation on the adobe site. [...]

  2. Super-simple SQLite example for Adobe AIR 1 Beta « Flash Enabled - Get Ready With Flash… - June 15, 2007

    [...] Here is a very simplistic Flex Builder 3 and AIR example that adds and removes records from a table in a local SQLite database. This is not a fully completed AIR project but this code can probably be reused by anyone wanting to get started with AIR+SQLite. There are a couple of other AIR+SQLite examples out there to check out and don’t forget the documentation on the adobe site. Installer: AIRSQLiteExample.air [...]

  3. Christophe Coenraets » SalesBuilder on AIR: Local Database, Data Sync, and Native Drag-and-Drop - June 15, 2007

    [...] Optionally start the AIR SQLite Admin tool. [...]

  4. Dev::Info - June 15, 2007

    Pár tipů pro Adobe AIR…

    Drag and drop mezi AIR aplikací a desktopem, ukázka práce s databází SQLite a SQLite Admin pro AIR.

  5. Flex Fanatic » Blog Archive » SQLite Databases - Administration Tools - July 18, 2007

    [...] Most AIR developers already know about the AIR SQL Admin tool made with Flex/AIR by Christophe Coenraets but it’s not the only tool out there to help create, manipulate and control a local SQLite database…there are actually quite a few available and some are better than others IMO. [...]

  6. Buy valium with mastercard. - July 24, 2007

    Buy valium with mastercard….

    Buy valium with mastercard….

  7. SQLite Admin Application for AIR | Adobe AIR Tutorials - July 25, 2007

    [...] more @ http://coenraets.org/blog/2007/06/sqlite-admin-application-for-air/ [...]

  8. Surf*Mind*Musings » Adobe AIR Bus Tour inspired Mozilla thoughts - August 14, 2007

    [...] Given that I can’t get to session data yet in Firefox3, I’ll likely, ironically, try and recreate some of my visualizations with AIR, which can read the SQLite Firefox3 history/bookmarks/cookie dbs directly. [...]

  9. Anonymous - March 24, 2008

    Hard Suck Gay…

    Hard Suck Gay…

  10. Anonymous - March 24, 2008

    Cumonmarie Clips…

    Cumonmarie Clips…

  11. Anonymous - April 3, 2008

    Hermine Nude Sexy…

    Hermine Nude Sexy…

  12. Anonymous - April 3, 2008

    Horny Hairy Girls 3…

    Horny Hairy Girls 3…

  13. Anonymous - April 3, 2008

    Sara Stone Wet T Shirts…

    Sara Stone Wet T Shirts…

  14. Anonymous - April 3, 2008

    Lithle Girls Kds Bbs…

    Lithle Girls Kds Bbs…

  15. flash.data.SQL : cannot access sqlite_master table ??? » free icons download - March 24, 2012

    [...] http://coenraets.org/blog/2007/06/sqlite-admin-application-for-air/||| From Christophe’s blog: “The current idea is to expose an API to expose the schema, as opposed to relying on database specific syntax. That API didn’t make it into the beta.” Related posts: [...]

Leave a Reply