New AIR SQLite Administration App (with Source Code)

October 25, 2007 in Air, Flex, SQLite

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.

,

  • Pingback: AIR SQLite Administration APP (sourcecode included) by Christophe Coenraets « Cyberspace Nova()

  • Sounds good. But what is AIR?

  • JJ

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

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

  • Pingback: Burmeseked.Com » New AIR SQLite Administration App (with Source Code)()

  • Pingback: IL.Blog » Blog Archive » SQLite + Air()

  • Jason The Saj

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

  • 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

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

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

  • jacob

    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

    It’s no more compatible with the new AIR

  • Mike

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

  • Will

    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

    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

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

  • Pingback: guaranteed school loans()

  • Pingback: help my credit()

  • Pingback: guaranteed unsecured visa credit cards()

  • Hope this helps. Thanks.

    ysbostan

  • Pingback: Anonymous()

  • Pingback: Anonymous()

  • Pingback: Anonymous()

  • Pingback: Anonymous()

  • Phil

    Looks like this needs to be updated for Air 1.1. Can you post a current build?? TIA!

  • Güzel bilgiler teşkkürler…

  • Wowww…This is what i need..thanks…

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

  • It’s no more compatible with the new AIR

  • Güzel bilgiler teşkkürler…

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

  • thanks ;)

  • thank you for sharing this website

  • 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

  • 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

  • […] También existe un gestor de SQLite con código fuente icluido aquí […]

  • banally Liverpool fidget …

  • Raj

    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

  • Pingback: Solution Hacker » Adobe Air with SQLite database()

  • ssk

    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.

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

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

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

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

  • And I t dfg

  • And I t um

  • how are you babyy

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

  • thanks for information

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

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

  • thx.

  • thanks for article

  • thhhh

  • Thank you for sharing your article I would always follow.

  • Cheap DG Shoes Make your first step from Gucci outlet, you will definitely be the most vogue! Follow Gucci, follow the fashion!

  • thank you admınn .1

  • Real gucci shoes for cheap re-interpreting signature styles with a fresh eye and a contemporary approach..

  • one is high-end professional-grade headphones, which are mostly used by people make a career in music; the other type is best quality high-end headphones, what fanciers pursue

  • kareena nude totally…

  • mavi ajans matbaa kendi alanında uzman kadrosuyla ve yaptıkları çalışmalarıyla bir adım önde baslayın mavi ajans matbaa

  • discount coach site

  • jorje

    Take a look on a free tool — Valentina Studio. Amazing product! This is excellent tool for PostgreSQL database administration and development. http://www.valentina-db.com/en/valentina-studio-overview

  • the invention us in our place .. everything up to date information here Fun music video story!

  • obrg gracias amigo

  • chant

  • quality, and reasonable price here in mass production.

css.php