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.
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
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 …
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.
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) ??
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)
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!
places the wild and eat and climb with box decay year from raspberries, places
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
Sohbet Chat Muhabbet Odalari Turkish
Very useful tool. Thank you.
Thank you very much for this useful article.
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
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
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.
Thankx
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?
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
very good,thanks.
thanks.
Is there any type of licence for using.
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
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
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
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
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
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
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
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.
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 !.
Matbaa
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
plakalık
Bing recognizes the complementary benefits of bringing computational knowledge to the forefront of the search experience..
Nice!! Great Ifo. Great People. Great Blog. Thank you for all the great sharing that is being done here
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!
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 …
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