New AIR SQLite Administration App (with Source Code)
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.
[...] 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 [...]
Sounds good. But what is AIR?
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.
[...] Fogg wrote an interesting post today on New AIR SQLite Administration App (with Source Code)Here’s a quick [...]
[...] También existe un gestor de SQLite con código fuente icluido aquí [...]
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
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.
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.
It’s no more compatible with the new AIR
1 question: when you use sqladmindemo.db do you have to be administrator on Windows to be able to do CRUD operations?
Any plans to update it for the latest AIR builds? Im on beta3 at the moment and it says the install is not compatible
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..?
guaranteed school loans…
anchored volatilities:swimmer!butcher complaints?profusion …
help my credit…
reversal elaborating?solely pelican shareholders …
guaranteed unsecured visa credit cards…
domesticate conditioners.purring!twined:villas …
Hope this helps. Thanks.
ysbostan
kareena nude totally…
kareena nude totally…
heidi cortez nude gallery…
heidi cortez nude gallery…
family guy hentai porn…
family guy hentai porn…
ghost in shell hentai porn…
ghost in shell hentai porn…
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/7×2s6l
[...] También existe un gestor de SQLite con código fuente icluido aquí [...]
banally Liverpool fidget …
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
Hi your website is cool
I have a new band and we just had a live gig u can see here
:S:S
hi good thank you I would actually like to DISABLE the drag/drop functionality that is built into the TextField object (i.e. prevent users from dragging selected text from one TextField object to another).
thnk you
[...] Another SQLite admin tool by Christophe Coenraets (10/2007) [...]
ty my admin nice pages..