About Dan Wilson
Dan Wilson
Dan Wilson
Model-Glue:Gesture for Fun and Profit
Watch Video
Presentation Files
360 Flex Course
DataCurl LLC, My Company
2010 Speaking Engagements
Video Interviews
DZone Articles
SQLLite Administration Made Easy
Sez : Dan Wilson
October 31, 2007 9:27 AM
I am working on some AIR projects now. AIR has SQLLite embedded into it. While looking around for a good way to manage SQLLite databases, I came across a post by Critter Gewlas titled Easy Administration of an SQLLite Database.
There is a freeware version with a very solid feature set. The professional version adds a trigger management UI, a Query Builder and some other enterprise level features. View the features for both editions on the SQLite Expert website
Here are some screenshots:
A data transfer wizard
Index Manager
Trigger Interface
An Image Editor for columns containing images
In short, this is a no-joke program for managing SQLLite Databases. I plan on evaluating this program in the near future and will post my findings.
There are no comments for this entry.
Add Comment
Subscribe to Comments
@zoid,
I saw that last night. It is a very nice tool. Though I was trying to create and populate tables I got a few errors. You gave me the incentive to fix them. Thanks!
http://www.nodans.com/index.cfm/2007/10/31/Fixed-e...
DW
Too bad it doesn't support Mac...
In my searching, I've landed at SQLite Database Browser, an open source utility that runs on both Windows and Mac. Zero install. Very easy to use and quick to start.
http://sqlitebrowser.sourceforge.net/
No frills for sure, but worth consideration for general SQLite uses.
Kevin Hoyt
Platform Evangelist
Adobe Systems, Inc.
A man I deeply admire (and whose job I covet) released a sweet SQLite Administration tool. I downloaded it last night and was playing with it. It is a very nice example of an AIR application.
Suscribe
Follow Us
Contact
Dan - There is also a pretty cool AIR app that lets you manage SQLite Databases. I doubt its a feature rich as this, but it works real well, and is free.