SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databasesare operating. SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.

Features and Benefits
- Edit tables and views visually, without writing a line of SQL. Easily restructure fields, indexes, constraints, triggers without losing data already existing in the tables.
- Build SQL scripts and generate views visually using the integrated Query Builder.
- Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
- Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.
- Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG and PNG image formats. BLOB fields can be edited with the integrated hex editor.
- Execute SQL queries and display results in the grid or as text.

February 7, 2010: Version 2.3.27. build 1945
* Import and export to and from CSV files now differentiate between null and empty values.
* On the text export window, changing delimiter will change the file extension.
* Modified foreign key editor to allow self-referencing foreign keys.

Home page - http://www.sqliteexpert.com/