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:
- Click New Database
- Navigate to a directory of your choice
- Specify a file name for the database. For example test.db
To open an existing database:
- Click Open Database
- 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.
35 Comments
Awesome! You just saved me a day of work. Keep up the great work :)
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 …)
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
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.
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.
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?
Good work with this usage of the sqldb API. I’ll keep you posted on the schema API when I find out more.
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
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.
buy delivery valium from buy valium
god bless the masters!!! really cool!
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.
No release for AIR 2 ?
Hi!! This is my site.
black bondage fucking
Hi!! This is my site.
black bondage fucking
Hi!! This is my site.
couple fucking pic
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
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
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
thank’s. thats great.
please un comment for bots..
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
Приветствую всех!
У меня такой вопрос,кто что интересное подскажет буду признателен.
Мы с друзьями собираемся поехать в круиз по просторам России и ближнего зарубежья месяца на два на своих машинах,но не как не можем согласовать маршрут,если у кого уже был опыт такого путешествия,может,что посоветуете.Девчонок с собой не берем,думаем,что во все городах России с этим не будет проблем,если у кого будут рекомендации и в вопросе отдыха с девушками тоже буду признателен.
С уважением Сеньчик
d1PMZ1 xf78fg623fv0skghlq56fd
Good work with this usage of the sqldb API. I’ll keep you posted on the schema API when I find out more.
thank’s. thats great.
Hi!! Good work!!
bond lesbian julia bond lesbian bound
cheap revolver hillcountryrifles lasers for pistols indoor pistol range construction highpower rifle sale
Весьма спорно, но как вариант имеет право на жизнь
thanks your post admin…Good work.
Thanks your good post admin.
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
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.
sion for a “database” file? I created a database file called test,
Once we receive your payment, we will handle the watch replica shipment.
14 Trackbacks
[...] 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. [...]
[...] 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 [...]
[...] Optionally start the AIR SQLite Admin tool. [...]
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.
…
[...] 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. [...]
Buy valium with mastercard….
Buy valium with mastercard….
[...] more @ http://coenraets.org/blog/2007/06/sqlite-admin-application-for-air/ [...]
[...] 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. [...]
Hard Suck Gay…
Hard Suck Gay…
Cumonmarie Clips…
Cumonmarie Clips…
Hermine Nude Sexy…
Hermine Nude Sexy…
Horny Hairy Girls 3…
Horny Hairy Girls 3…
Sara Stone Wet T Shirts…
Sara Stone Wet T Shirts…
Lithle Girls Kds Bbs…
Lithle Girls Kds Bbs…