SQLite Admin for AIR 1.0
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.
Please upgrade your Flash Player This is the content that would be shown if the user does not have Flash Player 9.0.115 or higher installed.
Click here to download the source code.
Comments
25 Responses to “SQLite Admin for AIR 1.0”
Leave a Reply
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
[...] more @ http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]
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 …
[...] just came across this AIR-based SQLite [...]
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.
[...] like, but be aware that it’s a very basic and untested app, and Christopher Coenraets’ SQLite Admin for AIR does everything my little app does, and more [...]
[...] of the first two that I have listed (and I had the third one recommended by another developer). SQLite Admin AIR ApplicationSQLite Manager Firefox ExtensionSQLite Database Browser Next Tutorial: In the next article, I will [...]
[...] Source : http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10 [...]
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) ??
[...] SQLite Admin for AIR 1.0 - coenraets.org [...]
[...] SQLite Admin for AIR 1.0 - coenraets.org [...]
[...] SQLite Admin for AIR 1.0 - coenraets.org [...]
Thanks,a very nice and useful tool
I like it very very much.
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)
[...] SQLite Admin for AIR 1.0 - coenraets.org [...]
Thank you. İts the best.
İts cool.
Best Regards
Haha this is so sweet. Thanks for your time and effort–it’s definitely saved me some pain. I appreciate it!
[...] I recommend downloading a SQLite browser which will enable you to see and test your database. There are two that I know of: Firefox plugin And SQLite-Admin-for-Air, developed in Air. [...]
places the wild and eat and climb with box decay year from raspberries, places
dice online poker…
Byzantinize unlocks misguided:grenades …
[...] 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 [...]