Windows Developer Power Tools

20.3 Administering SQLite Databases with the SQLite Administrator

SQLite is an open source SQL database engine packed into a tiny 250 KB C library. This small database includes ACID (atomic, consistent, isolated, and durable) transactions, SQL92 implementation, a 2 terabyte database limit, and much more. Because all of this functionality is wrapped up in a small library, SQLite is an ideal candidate for embedded databases. It’s perfect as a location for client-side caching or offline support in Windows Forms and Windows Mobile applications.

One of the few downsides of SQLite is the lack of a good administration tool: it doesn’t come packaged with a tool comparable to SQL Server’s Enterprise Manager. SQLite Administrator is an open source application that fills this gap by giving you the ability to create, modify, and delete tables, views, indexes, and triggers. SQLite Administrator also includes additional functionality to write SQL queries, export data to Excel, and migrate SQLite 2 databases to the SQLite 3 format.

SQLite Administrator at a Glance
Tool	SQLite Administrator
Version covered	0.8.2.5 beta
Home page	http://sqliteadmin.orbmu2k.de
Power Tools page	http://www.windevpowertools.com/tools/109
Summary	Free administration tool for the SQLite database engine
License type	Freeware; commercial use prohibited without approval
Online resources	Forum

Getting Started

SQLite Administrator is distributed ...