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.
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.
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..?
Hope this helps. Thanks.
ysbostan
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 …
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, 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
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