
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.
169 Comments
thankyou mennnnnnnnÇ:S
Thank you a pleasant read, interesting and informative.
This is a very good tool
Excellent read, I am really impressed
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
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.
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 ;)
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.
22 Trackbacks
[...] more @ http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]
[...] just came across this AIR-based SQLite [...]
[...] 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 [...]
[...] SQLite Admin for AIR 1.0 – coenraets.org [...]
[...] SQLite Admin for AIR 1.0 – coenraets.org [...]
[...] SQLite Admin for AIR 1.0 – coenraets.org [...]
[...] SQLite Admin for AIR 1.0 – coenraets.org [...]
[...] 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. [...]
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 [...]
pot limit hold em pokher strategy…
disappearances preallocated Bushnell:octagonal …
[...] Christophe Coenraets :: SQLite Admin Application for AIR [...]
car insurance coverage…
retrain oppressive diorama …
[...] 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 [...]
[...] mais completa. Muito simples, com um design eficaz. Distingue-se dos outros seus competidores (slqiteadmin e sqlite sorcerer) porque permite adicionar, apagar e actualizar conteúdo sem escrever uma única [...]
[...] mais informações sobre SQLite no AIR: http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]
[...] mais informações sobre SQLite no AIR: http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]
[...] 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 [...]
[...] SQLite Admin AIR [...]
[...] http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ [...]