SQLite Admin for AIR 1.0

February 26, 2008 in Air, Flex, SQLite

Here is a new version of my AIR-based SQLite Admin application updated for AIR 1.0. 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 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.

The UI is still simple, but uses some new AIR and Flex 3 features such as the AdvancedDataGrid and Native Windows.

[airbadge]sqliteadmin, http://coenraets.org/air/sqliteadmin/sqliteadmin.air, v1.0, http://coenraets.org/blog/wp-content/uploads/2007/10/sqladmin.png[/airbadge]

Click here to download the source code.

  • Thanks! You fixed the file extension restriction to allow opening of .sqlite files!

  • Thanks for posting the source. I added a button to QueryWindow.mxml to let you Save your SQL to a file. Its no frills, but if you want to add it in the AS3 code is here:

    http://initapp.privatepaste.com/e51RE2la3g

  • Pingback: SQLite Admin for AIR 1.0 | Adobe AIR Tutorials()

  • Hey Christophe,
    a very nice tool! I just started using Flex with Air and your tool makes it a lot easier working with sqlite, thanks.

    Greets,

    Daniel

  • Great work!

    You should lose the Eclipse / Flex Builder properties files (.settings/*, .flexProperties, etc) from your ZIP, though …

  • Pingback: » air sqlite admin()

  • Hi there,

    Thanks very much for the useful app and helpful source code. I was actually wondering about your source code distribution: it contains a copy of Adobe’s Myriad Web Pro font .ttf files.

    Is it permissible to redistribute these files generally? They seem to be something that you can purchase a licence for from Adobe, so I’m slightly confused as to whether you should be redistributing them, and whether I may?

    Cheers,
    Royston.

  • Pingback: joshua mostafa >> /dev/blog & » Blog Archive » simple sql batch loader in air()

  • Pingback: Koen.cz » AIR API - Introduction to the SQLite Database()

  • Pingback: CornFlex - Flex & Flash by Quentin Lengelé » Blog Archive » SQLite Admin for AIR 1.0()

  • Christophe,

    Thanks for sharing this as its a great AIR application! I know you’ve made the source available but I wanted to verify with you first. I’d like to expand the interface so devs can create easy things like columns and tables without needing to write any SQL. Would you be alright with me expanding on the source you’ve released and then making it available for others? Again thanks for such a helpful app!

  • Cool!!!
    Is there any type of licence for using. I would like to add some features as syntax highlighting and a graph to show database structure (using spring graph component) ??

  • Pingback: 101 Adobe AIR Resources to Add to Your Toolbelt of Awesomeness()

  • Pingback: Celi Online » 101 Recursos para Adobe Air()

  • Pingback: 101 Adobe AIR Resources to Add to Your Toolbelt of Awesomeness | AIR + Flex Laboratory.()

  • reallypride

    Thanks,a very nice and useful tool
    I like it very very much.

  • cp8r

    Thank you for this inspiring AIR application!

    As I am developping with Flex and AIR for my diploma degree I would like to ask two questions:

    1.
    Also described I do not understand how the local database receives its initially data – or from where! Where is the initial data written when one installs the application? I could not find anything in the XML files under /data.

    2.
    In an earlier post regarding the first version of salesbuilder you wrote you “removed the server component (to avoid having to watch all the bad things that can happen to a shared demo database)” and that an “XML document plays the role of server data.” So this means it’s also possible to access a remote database e.g. on a webserver? I try to do this for a while but cannot find out how this works. Do you have any hints?

    I would be very thankful for any answer, maybe via email. I would have emailed you, too, but could not find any address :-(

    Best regards,

    Christian (Wolfsburg, Germany)

  • Pingback: 101 Recursos para Adobe Air | Nodo54()

  • Thank you. İts the best.

  • İts cool.

    Best Regards

  • Marcus

    Haha this is so sweet. Thanks for your time and effort–it’s definitely saved me some pain. I appreciate it!

  • Pingback: SQLite with AIR tutorial, conquer the DB. at 9MMEDIA Blog()

  • places the wild and eat and climb with box decay year from raspberries, places

  • Pingback: dice online poker()

  • Pingback: Adobe AIR相關學習網頁 於傻仔仔()

  • Khairunnisa

    I tried your SQLite Admin application on Vista with UAC (User Access Control) on it doesn’t seem to want to retrieve data from tables.
    I can open your sqladmindemo.db but NOT querying from it.
    However, retrieval/writing of data on your SalesBuilder application works fine on Vista with the same settings.
    I realize both are using synchronous connection – so what’s the difference between these two applications in terms of calling data?
    My application is facing the same problem as your sqlite admin – not able to read data on Vista with UAC on. However works perfectly when UAC is off.

    Can Enlighten?

  • land we all green water black look jhon no boat head

  • Güzel bilgiler..Teşekkürler…

  • frog university me free head clean ibm this busy woman home juicy

  • Güzel bilgiler..Teşekkürler…

  • good thanks

  • thanks….

  • Thanks. you very muck.

  • ooo süper this is.

  • thanks.

  • thanks you man

  • good thanks

  • its cool.

  • thanks

  • i like thank you

  • Pingback: pot limit hold em pokher strategy()

  • Sohbet Chat Muhabbet Odalari Turkish

  • Very useful tool. Thank you.

  • Thank you very much for this useful article.

  • irc

    Thank you very much

  • Thanks You

  • tenksk you very
    It’s really a great artical and really helped me. One question from myside is..

    Is there anyway of copressing .tiff files by using mod_gzip??

  • thanks you man

  • Thank you very much coenraets.org

  • Venkat from India

    Does it not support insert statements or what!??

    I tried inserting something into the demo db and all I get is “Error #3115”?

  • thanks

  • Thanks You

  • Luis Munoz

    Hi there,
    Is there any documentation on how to install the SQLiteAdmin tool and how to use it. I am running Flex 3 on a iMac.
    I am trying to learn adobe Air and using above tool should make working with SQLite easier.Very much appreciated.

    Thanks

  • danke admin

  • tek yuo admin

  • thanks you good

  • thanks

  • thank you

  • thanks

  • thank you admin

  • thanks for you.

  • Pingback: Adobe AIR « Flex Generation Weblog()

  • Pingback: car insurance coverage()

  • Thankx

  • Doug

    I am also getting only 3115 error when attempting to insert. It is driving me crazy. What’s the deal?

  • thanks you

  • ı have followed your writing for a long time.really you have given very successful information.
    In spite of my english trouale,I am trying to read and understand your writing.
    And ı am following frequently.I hope that you will be with us together with much more scharings.
    I hope that your success will go on.

  • I am also getting only 3115 error when attempting to insert. It is driving me crazy. What’s the deal?

  • I am also getting only 3115 error when attempting to insert.

  • tşkk :)

  • thanks baby

  • thenks http://www.BizimleSohbet.com – sohbet, chat, muhabbet, sohbet odaları,sohbet sakarya,sohpet,sohbet oyun radyo,İslami Sohbet, Dini Sohbet, İslami Site, Dini Site, İslami Chat, İslami Radyo, iSlami Sohbetler, Dini Sohbetler, DiniSohbet, iSlamiSite, Dini Chat, iSlami Arkadaşlık

  • thanks.

  • thnks

  • thanks for you job life.

  • ssk sorgulama

    tanx see you later

  • happy new year!

  • thankx admin good your web site and post

  • Thanks…

  • I am also getting only 3115 error when attempting to insert. It is driving me crazy. What’s the deal?

  • John Keates

    This is a fine piece of work! Love this killer app :-)

  • Hey Christophe,
    a very nice tool! I just started using Flex with Air and your tool makes it a lot easier working with sqlite, thanks.

    Greets,

    Daniel

  • danke admin

  • ats

    very good,thanks.

  • web

    thanks.

  • Is there any type of licence for using.

  • Rosmayati

    I would like to know is there any possibility to integrate sqlite with other database management system such as oracle, db2, sql server etc? If yes, how?

  • El tema de los permisos es independiente al de los plugins
    Thanks admin

  • very nice page thankss

  • thank you

  • Error 3115 : make sure your syntax is SQLite friendly. Some commands will not to work.

    FOR EXAMPLE:
    INSERT INTO foo (first_id ,second_id) VALUES (‘410′, ’99’) ;
    will generate 3115.

    AND

    INSERT INTO foo (products_id ,categories_id) VALUES (“410”, “99”) ;
    will be okay.

    What’s difference? The first one uses apostrophes while the latter uses quotation marks.

    For a better idea, see http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql.

  • good thanks

  • thanx

  • sie :D

  • thanks admin

    türkçe mirc

  • Pingback: Design & Development Tutorials » Create an SQLite connection in Adobe Air()

  • MCX

    ddd

  • süper bir site ya:D

  • SQLite database. I use SQLite administrator which is free to download. Another good application is SQLite admin which was maid by Christophe Coenraets. This is an Air application and can by used on a mac. I’ll […]

  • thank

  • SQLite database. I use SQLite administrator which is free to download. Another good application

  • good thanks

  • origami : thanks .)

  • thanx

  • thanks good post

  • Thank You..

  • thansk

  • Thanks My Friend..

  • Thank You Admin.

  • thank

  • hallo i wish you verry succes operator

  • Thank You Admin.

  • hallo i wish you verry succes operator

  • godstroke

    thanks, and i guess you have some spam-comments in this post if you havent noticed. After the one with “george mckinney Says:” all of em are likely spam, they are in turkish, with links to some sites.

  • Thank you All..

  • thanks for post

  • hallo i wish you verry succes operator

  • hallo i wish you verry succes operator

  • hallo dear friends thanks a lot for your workshop

  • You should lose the Eclipse Flex Builder properties files ettings flexProperties etc from your ZIP thougr

  • mRai

    Is there any type of licence for using. I would like to add some features as syntax highlighting and oyUn a graph to show database structure (using spring graph component

  • sikis kasıyoruz

  • This is a good tool if you aren’t comfortable with the SQLite command line. It’s also nice that it works in the AIR environment.

  • I am also getting only 3115 error when attempting to insert. It is driving me crazy.

  • This is a good tool if you aren’t comfortable with the SQLite command line

  • Hi there,

    Thanks very much for the useful app and helpful source code. I was actually wondering about your source code distribution: it contains a copy of Adobe’s Myriad Web Pro font .ttf files.

  • This is a good tool if you aren’t comfortable with the SQLite command line

  • Thanks very much for the useful app and helpful source code. I was actually wondering about your source code distribution: it contains a copy of Adobe’s Myriad Web Pro font .ttf files.

  • Nice post. This post is different from what I read on most blog. And it have so many valuable things to learn. Thank you for your sharing!

  • I am grateful to you for this great content.

  • This is a good tool if you aren’t comfortable with the SQLite command line. It’s also nice that it works in the AIR environment.

  • thanks, and i guess you have some spam-comments in this post if you havent noticed. After the one with “george mckinney Says:” all of em are likely spam, they are in turkish, with links to some sites.

  • This is a good tool if you aren’t comfortable with the SQLite command line

  • Ahhh. This application is refreshingly handy. I downloaded a huge sqlite database and this tool is making it nice to explore. Plus it’s a good air application example to learn from on an unrelated air toy.

    Thank you for making this application available! I appreciate it. :)

    Best regards,

    Chris

  • SQLite database. I use SQLite administrator which is free to download. Another good application

  • thanks good post

  • ssk

    tenksk you very
    It’s really a great artical and really helped me. One question from myside is..

    Is there anyway of copressing .tiff files by using mod_gzip??

  • thanks, and i guess you have some spam-comments in this post if you havent noticed. After the one with “george mckinney Says:” all of em are likely spam, they are in turkish, with links to some sites.

  • This is a good tool if you aren’t comfortable with the SQLite command line

  • This is a good tool if ydsou aren’t comfortable with the SQLite command line

  • thank you every body.

  • ohh very good thanks you

  • thnx

  • ohh very good thanks you

  • yess very much

  • ı have followed your writing for a long time.really you have given very successful information.
    In spite of my english trouale,I am trying to read and understand your writing.
    And ı am following frequently.I hope that you will be with us together with much more scharings.
    I hope that your success will go on.

  • thank you every body.

  • ohh very good thanks you

  • very good thanks you

  • Thnakss .

  • thnk you my admin

  • Thank you very much admin!

  • Notebook ve notebook parçaları

  • teşekkürler arkadaşım süper

  • tanks goody

  • Given that they still have a silly religious devotion to keeping the front page “clean”, it’s a wonder their other products have done as well as they have. But many of them are making progress, slowly but surely, and I suspect one day Sergey and Larry will realize that starting with “search” is actually less convenient than starting with clicks and build out the front page.

  • products have done as well as they have. But many of them are making progress, slowly but surely, and

  • very good thanks you

  • This is a good tool if you aren’t comfortable with the SQLite command line. It’s also nice that it works in the AIR

  • This is a good tool if you aren’t comfortable with the SQLite command line. It’s also nice that it works in the

  • Pingback: As melhores aplicações AIR para Designers e Developers «()

  • It is very interesting to see this tool here.
    thank you

  • This is a good tool if you aren’t comfortable with the SQLite command line. It’s also nice that it works in the AIR

  • tesekkurler

  • sikiş social network

  • Pingback: Comunidade Portuguesa de Rich Internet Applications» Blog Archive » Parte I – Flex, AIR & SQLite()

  • Pingback: Tutorial parte I – Flex Air e SQLite at iMauro blog()

  • Thanks. you very muck

  • Thanks. you

  • thankyou mennnnnnnnÇ:S

  • Thank you a pleasant read, interesting and informative.

  • This is a very good tool

  • Excellent read, I am really impressed

  • Agustin

    Awesome, been looking for something like this for a while!!! Is it on adobe market place?

  • I really love this post anyway and i hope you to improve your quality of article
    regards

  • tahnks

  • Tim

    I am seeing what appears to be a bug with SQLite in Adobe Flex and in SQLAdmin, as follows:

    select t1.id, t1.descrip, t2.title
    from t1 inner join t2 on t1.id = t2.id
    where t1.desc like “xxx%”

    t1.id is integer ; t2.id is integer; t2.title is varchar

    The problem is, the correct rows from t1 are returned, but t2.title is always incorrect.

    When I examine the t2 table to determine the PK value of these wrong titles, I notice that the PK values are very close to t1.id. For example:

    t1.id = 140 and the wrong title has a PK of 1400.
    t1.id = 2530 and the wrong title has a PK of 25230.
    t1.id = 160 and the wrong title has a PK of 1610.

    It looks like a number column is being sorted as text. Perhaps an index is being turned into an array and sorted as text rather than as int?

    Please note than when I execute the identical query in other GUI query tools that work with SQLite (e.g. Razor, Visual Studio, SQL Maestro) they all agree with each other and return the correct t2.title values.

  • Great article as for me. It would be great to read a bit more about this matter.

  • Pingback: 超全的AIR学习资源网址大全()

  • Simon

    I’m still novice at using Adobe AIR and SQLite, but I’m in serious doubt on the SQLite syntax.
    According to the reference at : http://www.sqlite.org/lang_createtable.html , the following query should be alright ..

    CREATE TABLE `Bluueergwhatever`
    (`id` int(11) CONSTRAINT PRIMARY KEY AUTOINCREMENT,
    `name` varchar(50))

    But while playing around it seems like none of the sqlite syntax match, only the MySQL -like query syntax seems to work. What am I doing wrong ? Help is very much appreciated.

  • laptop servisi istanbul

  • yes agree with

  • thanks ;)

  • Pingback: SQLiteのGUI管理ツールを紹介 | Mtok-blog()

  • Pingback: KEMURI » SQLite Admin für AIR()

  • Wonderful Stuff you post!

  • güncel bilgiler,güncel blog,özgün blog

  • this is an amazing blog, you are a good publisher, i will return more often to your blog.

  • Really useful. Can’t believe how simple it is.

  • Fantastic little app, thanks very much.

    Regarding the syntax, I’ve noticed that it’s the quote marks you have to be careful of (i.e. MySQL uses ` with tables whereas SQLite uses ‘ ), but I believe this is an SQLite thing and nothing to do with the app.

  • this is an amazing blog, you are a good publisher, i will return more often to your blog.

  • thanks for article

  • I see the 2concern.I am very m glad to hear that you got your Supra fixed. I remember reading about some of your problem4x !.

  • Agree with Tim that there is appears to be a bug with SQLite in Adobe Flex and in SQLAdmin.

  • this application to examine the structure of a datab

  • Yes. I like the feature of your app where the database keeps track of the other databases. We are using similar for our structure for ours

  • Bing recognizes the complementary benefits of bringing computational knowledge to the forefront of the search experience..

  • wpolscemamymocneseo

    Nice!! Great Ifo. Great People. Great Blog. Thank you for all the great sharing that is being done here

  • J.

    Hi, nice app.
    Could you make a little improvement please?
    I have a database table with lots of rows in it.
    When i execute the query the datagrid under “enter a sl statement” gets to big.
    Could you add scrollbars to it, so i can view all presented data and scroll to the right to see all colmns?

    Greets, J.
    Ps. let me know if there is a new version

  • Very nice interface for testing SQL querys, thank you!

  • Pingback: Adobe AIR – Utilisation d'une base SQLite locale - Adobe Flex Tutorial - Tutoriaux Flex Builder, MXML, ActionScript, AS3()

  • VC

    Has Adobe Flex “team” come to its senses to compile-in the full-text-search capabilities into any of the newer versions of AIR? In fact, has anybody at Adobe come to enough of their senses to fire those that end up making such stupid decisions – to exclude it, in the first place?

  • ข้อมูลดีน่าสนใจ มาก

  • Laptop LCD panel, keyboard, adapter, battery, hinge …

  • Dani

    great,
    this is exactly what I was looking for.
    rgds

  • Great Info. Great Blog

  • Good Info, Thank you

  • good info, thanks

  • RichFLV- adobe.com SearchCoders Dashboard- adobe.com Spazan – Twitter client- adobe.com SQLite Admin for AIR 1.0- coenraets.org StockQ: A Stock Quotes application, built for Adobe AIR- adobe.com StudioCloud PSG […]

  • mavi ajans matbaa thanks

  • qüzel bir çalısma olmus mavi ajans matbaa thanks

  • Byzantinize unlocks misguided:grenades …

  • Here is a new version of my AIR-based SQLite Admin application updated for AIR 1.0. 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.

  • The UI is still simple, but uses some new AIR and Flex 3 features such as the AdvancedDataGrid and Native Windows.

  • Good. vThank you very much.

  • sugoiyokattayo
    matakurune

  • This is a great use of SQL to access databases quickly! Thank you so much for sharing!

  • o maiii ghatt :)

  • thank you every body.

  • yonca sohbet chat odaları

  • metin2 yang metin2 ep ürünleri

  • İts cool.

  • Evden Eve Nakliyat İş İlanları Platformu
    EVDEN EVE NAKLİYAT PLATFORMU

  • güzel anlatım.

  • Thank you. İts the best.

  • Thanks for post. It’s worked for me.

  • tubidy mobile music download system.

  • tubidy mp3

  • Ms. Baez called for a singalong from the invited audience, and got
    one, on “We Shall Overcome.” She recalled the Rev. Dr.
    Martin Luther King Jr.’s deciding

  • SearchCoders Dashboard-Spazan – Twitter client- adobe.com SQLite Admin for AIR 1.0- coenraets.org StockQ: A Stock Quotes application, built for Adobe AIR-

  • Tubidy Mobile Tubidy Mp3 video search will add this to its engine soon this will be amazing

  • thank you. İts the best.

  • Thanks for post. It’s worked for me.

  • thanks

  • good bloge thanks

  • Thanks really been a great article .. I like it when people come together and share opinions.

  • My teacher was very useful explanation, thank you very much

  • thanks for post.its very like thıs….

  • thanks

  • Thank u admin nice post

  • Thanks for writing, nice sharing was.

  • raf

    harika haberler ve başarılı olmuş

  • Fabrics we use in our form; The first-class micro-interlock; flex-fit, anti-bacterial, it has a thermo-balance, and immediately drying. This gives you the freedom to move your soccer jerseys of the match; It is designed stylish enough to be worn on a daily basis. Our models are produced in two types as my special jerseys and other digital printed.
      His highest production of our company, we use the sport socks products: cotton, cotton, polyester, nylon and lycra. It includes anti-bacterial.

  • Tubidy

    Thank you this is the best ever i saw it is like high music site
    http://mp3.tubidymobile.net/

  • I came very wonderful site, I’m here now, thank you.

  • Nice sharing thanks

  • Thank you. İts the best and very nice..

  • Pingback: SQLite & UML for Adobe AIR | Script by Q.()

  • Oh its a 2008 article it is still helped me to sort out my problems with my site http://www.tubidy.net.co

  • yusuf sarıkaya
  • İzmir Nakliyat

    Thank you. You need to call Atasun for transportation between cities
    http://www.atasunnakliyat.com.tr/

css.php