New AIR SQLite Administration App (with Source Code)

By Christophe Coenraets | Published: October 25, 2007

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.

This entry was posted in Air, Flex, SQLite and tagged Air, SQLite. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

40 Comments

Anonymous

Posted October 26, 2007 at 8:11 am | Permalink

Sounds good. But what is AIR?
JJ

Posted October 26, 2007 at 10:22 am | Permalink

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

Posted October 27, 2007 at 9:15 am | Permalink

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.
Jason The Saj

Posted October 30, 2007 at 1:52 pm | Permalink

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

Posted October 31, 2007 at 9:52 am | Permalink

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
Francois Botha

Posted November 7, 2007 at 2:19 am | Permalink

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

Posted December 1, 2007 at 2:18 am | Permalink

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

Posted December 15, 2007 at 12:02 pm | Permalink

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.
JJ

Posted January 1, 2008 at 11:36 am | Permalink

It’s no more compatible with the new AIR
Mike

Posted January 2, 2008 at 7:31 am | Permalink

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

Posted January 4, 2008 at 7:41 pm | Permalink

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

Posted January 16, 2008 at 9:23 pm | Permalink

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
Varun Shetty

Posted January 17, 2008 at 4:08 pm | Permalink

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..?
vinç

Posted February 17, 2008 at 4:50 pm | Permalink

Hope this helps. Thanks.

ysbostan
Phil

Posted July 9, 2008 at 6:36 am | Permalink

Looks like this needs to be updated for Air 1.1. Can you post a current build?? TIA!
Araba, Yarış Oyunları

Posted August 6, 2008 at 5:41 pm | Permalink

Güzel bilgiler teşkkürler…
Savaş Oyunları

Posted August 7, 2008 at 6:34 am | Permalink

Wowww…This is what i need..thanks…
Kız Oyunları

Posted August 7, 2008 at 6:35 am | Permalink

Congrulations for this nice web design..Usefull..
chat

Posted August 22, 2008 at 5:48 am | Permalink

It’s no more compatible with the new AIR
sohbet

Posted August 22, 2008 at 5:49 am | Permalink

Güzel bilgiler teşkkürler…
radyo dinle

Posted August 22, 2008 at 5:49 am | Permalink

Congrulations for this nice web design..Usefull..
forum

Posted August 22, 2008 at 5:50 am | Permalink

thanks ;)
key ödemeleri

Posted August 28, 2008 at 3:34 pm | Permalink

thank you for sharing this website
lapto battery

Posted November 20, 2008 at 9:23 pm | Permalink

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
BedOrdeltdype

Posted December 27, 2008 at 8:45 am | Permalink

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
sohbet

Posted January 7, 2009 at 1:10 pm | Permalink

[...] También existe un gestor de SQLite con código fuente icluido aquí [...]
araç sorgulama

Posted March 17, 2009 at 5:02 pm | Permalink

banally Liverpool fidget …
Raj

Posted May 21, 2009 at 2:44 am | Permalink

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
ssk

Posted July 23, 2009 at 9:27 am | Permalink

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.
zerrin egeliler

Posted July 23, 2009 at 11:45 am | Permalink

Congrulations for this nice web design..Usefull..
Степан Кузнецов

Posted July 28, 2009 at 9:37 am | Permalink

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

Posted August 18, 2009 at 6:21 am | Permalink

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

Posted August 21, 2009 at 1:09 pm | Permalink

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

Posted October 14, 2009 at 5:38 pm | Permalink

And I t dfg
Savaş Oyunları

Posted October 14, 2009 at 5:38 pm | Permalink

And I t um
chat odası

Posted November 24, 2009 at 6:25 am | Permalink

how are you babyy
chat

Posted December 4, 2009 at 7:07 am | Permalink

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..?
rottweiler

Posted July 16, 2010 at 9:13 pm | Permalink

thanks for information
cindy

Posted July 24, 2010 at 10:24 am | Permalink

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

Posted August 8, 2010 at 9:26 am | Permalink

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

11 Trackbacks

By AIR SQLite Administration APP (sourcecode included) by Christophe Coenraets « Cyberspace Nova on October 26, 2007 at 1:29 am

[...] 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 [...]
By Burmeseked.Com » New AIR SQLite Administration App (with Source Code) on October 28, 2007 at 12:23 pm

[...] Fogg wrote an interesting post today on New AIR SQLite Administration App (with Source Code)Here’s a quick [...]
By IL.Blog » Blog Archive » SQLite + Air on October 29, 2007 at 2:16 am

[...] También existe un gestor de SQLite con código fuente icluido aquí [...]
By guaranteed school loans on February 9, 2008 at 5:08 am

guaranteed school loans…

anchored volatilities:swimmer!butcher complaints?profusion …
By help my credit on February 9, 2008 at 4:53 pm

help my credit…

reversal elaborating?solely pelican shareholders …
By guaranteed unsecured visa credit cards on February 14, 2008 at 10:30 pm

guaranteed unsecured visa credit cards…

domesticate conditioners.purring!twined:villas …
By Anonymous on March 24, 2008 at 7:47 am

kareena nude totally…

kareena nude totally…
By Anonymous on April 3, 2008 at 2:31 am

heidi cortez nude gallery…

heidi cortez nude gallery…
By Anonymous on April 3, 2008 at 10:10 pm

family guy hentai porn…

family guy hentai porn…
By Anonymous on April 3, 2008 at 10:11 pm

ghost in shell hentai porn…

ghost in shell hentai porn…
By Solution Hacker » Adobe Air with SQLite database on July 2, 2009 at 1:02 am

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

New AIR SQLite Administration App (with Source Code)

40 Comments

11 Trackbacks

Post a Comment

Projects

Categories

RSS Links