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.

June 13, 2007 | Filed Under Flex 
These icons link to social bookmarking sites where readers can share and discover new web pages.
  • bodytext
  • del.icio.us
  • Facebook
  • Google
  • description
  • NewsVine
  • Slashdot
  • Technorati
  • StumbleUpon

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

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

  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

    Hi!! Good work!!

    blonde boob fucking tit
    blonde braces fucking galleries
    blonde brunette fucking
    blonde brunette fucking lesbian
    blonde busty clip fucking hardcore links movie
    blonde busty fucking hard milf
    blonde busty fucking mature
    blonde busty fucking teen
    blonde cheerleader fucking
    blonde chick fucking
    blonde chick fucking hot
    blonde chubby fucking
    blonde cock fucking
    blonde cock fucking hard
    blonde cock fucking hard hot
    blonde cock fucking hot
    blonde cock fucking huge
    blonde cock fucking monster
    blonde college fucking
    blonde couple fucking
    blonde cucumber eating fucking it
    blonde cute fucking teen
    blonde dick fucking
    blonde dirty fucking
    blonde face fucking
    blonde fine fucking
    blonde free fucking gay
    blonde free fucking legged long video
    blonde free fucking movie
    blonde free fucking video
    blonde fucking
    blonde fucking a black cock
    blonde fucking asian
    blonde fucking beauties
    blonde fucking black cock
    blonde fucking black dicks
    blonde fucking blonde
    blonde fucking clip
    blonde fucking dick
    blonde fucking dildo
    blonde fucking free video
    blonde fucking gallery
    blonde fucking guy shemale
    blonde fucking guys
    blonde fucking hair short
    blonde fucking haired short
    blonde fucking hairy
    blonde fucking hairy pussy
    blonde fucking hard
    blonde fucking hard hot

  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