SQLLite Administration Made Easy

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.

Related Blog Entries

Comments
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.
# Posted By Scott Stroz | 10/31/07 10:06 AM
@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
# Posted By Dan Wilson | 10/31/07 12:43 PM
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.
# Posted By Kevin Hoyt | 10/31/07 2:48 PM
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.
# Posted By Jack | 4/24/08 1:07 PM
BlogCFC was created by Raymond Camden. This blog is running version 5.9.001. Contact Blog Owner