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.

Comments

42 Responses to “SQLite Admin Application for AIR”

  1. AJ on June 13th, 2007 10:09 am

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

  2. Jim on June 13th, 2007 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 on June 13th, 2007 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 on June 13th, 2007 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 on June 13th, 2007 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 on June 13th, 2007 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 on June 13th, 2007 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.   Super-simple SQLite example for Adobe AIR 1 Beta by Sean Moore: ActionScript Coder on June 14th, 2007 6:27 am

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

  9. Super-simple SQLite example for Adobe AIR 1 Beta « Flash Enabled - Get Ready With Flash… on June 15th, 2007 7:39 am

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

  10. Christophe Coenraets » SalesBuilder on AIR: Local Database, Data Sync, and Native Drag-and-Drop on June 15th, 2007 8:50 am

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

  11. Dev::Info on June 15th, 2007 12:37 pm

    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.

  12. Jhecht on June 16th, 2007 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

  13. Chris Turvey on June 22nd, 2007 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.

  14. Flex Fanatic » Blog Archive » SQLite Databases - Administration Tools on July 18th, 2007 11:41 am

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

  15. Buy valium with mastercard. on July 24th, 2007 5:28 pm

    Buy valium with mastercard….

    Buy valium with mastercard….

  16. SQLite Admin Application for AIR | Adobe AIR Tutorials on July 25th, 2007 8:14 am
  17. find valium buy on August 4th, 2007 12:38 pm

    buy delivery valium from buy valium

  18. Surf*Mind*Musings » Adobe AIR Bus Tour inspired Mozilla thoughts on August 14th, 2007 11:56 am

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

  19. Mounstar on August 27th, 2007 5:22 pm

    god bless the masters!!! really cool!

  20. watch replica on October 15th, 2007 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.

  21. Cyrille on October 16th, 2007 11:46 am

    No release for AIR 2 ?

  22. fordmusta on October 19th, 2007 11:19 am

    Hi!! This is my site.
    black bondage fucking

  23. hgfjkdlsiu on October 19th, 2007 1:02 pm

    Hi!! This is my site.
    black bondage fucking

  24. gdskglotuy on October 20th, 2007 11:51 am

    Hi!! This is my site.
    couple fucking pic

  25. ldhgjjhkf on October 21st, 2007 2:03 am
  26. XRumakTheBest on November 6th, 2007 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

  27. flashcrobat on December 19th, 2007 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

  28. Anonymous on March 24th, 2008 4:59 am

    Hard Suck Gay…

    Hard Suck Gay…

  29. Anonymous on March 24th, 2008 5:00 am

    Cumonmarie Clips…

    Cumonmarie Clips…

  30. Anonymous on April 3rd, 2008 2:29 am

    Hermine Nude Sexy…

    Hermine Nude Sexy…

  31. Anonymous on April 3rd, 2008 2:29 am

    Horny Hairy Girls 3…

    Horny Hairy Girls 3…

  32. Anonymous on April 3rd, 2008 8:47 pm

    Sara Stone Wet T Shirts…

    Sara Stone Wet T Shirts…

  33. Anonymous on April 3rd, 2008 8:47 pm

    Lithle Girls Kds Bbs…

    Lithle Girls Kds Bbs…

  34. Mehmet Mehmetoğlu on April 14th, 2008 7:55 am

    thank’s. thats great.

    please un comment for bots..

  35. Mehmet Mehmetoğlu on April 14th, 2008 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

  36. Benchiktovchik on June 5th, 2008 10:46 am

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

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

  37. alice on August 5th, 2008 6:18 am

    d1PMZ1 xf78fg623fv0skghlq56fd

  38. chat on August 22nd, 2008 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.

  39. çet on August 22nd, 2008 6:37 am

    thank’s. thats great.

  40. sohbet on August 22nd, 2008 6:38 am

    Hi!! Good work!!

  41. lesbian bond licking on August 24th, 2008 10:12 pm

    bond lesbian julia bond lesbian bound

  42. Assorscog on September 3rd, 2008 2:01 am

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

Leave a Reply