SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating. SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.
-Modify table structure visually without losing data already existing in the database. SQLite Expert will automatically create a new table with the new structure and copy the data from the old table. All the operations are wrapped in a transaction which is rolled back if any error occurs during the process.
-Build SQL scripts visually using the integrated Query Builder.
-Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) database.
-The Data Transfer Wizard allows import/export from/to SQL script, another SQLite database or an ADO data source.
-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. Supports multiple SQL statements in the same query.
-In-grid editing of live queries.
-Save/Load SQL scripts to/from file.
-Transaction support. SQLite supports one level of transactions.
-Data mapping. SQLite Expert supports custom data types, and 40 predefined data types.
-Extend and enhance SQLite Expert using Lua or Pascal scripts.
Operating System: Windows 2000/XP/2003/Vista
SQLite - sqlite.dll version 3.x. (included)
May 26, 2008: Version 1.6.69. build 1585
-Modified constraint editors to allow unnamed constraints.
-Added label that displays whether a query is editable and which key fields are being used.
May 20, 2008: Version 1.6.68. build 1582
-Fixed error preventing database schema auto-refresh after executing a query that may have modified the schema.
May 20, 2008: Version 1.6.67. build 1581
-Fixed parsing error when processing unnamed constraints.
May 18, 2008: Version 1.6.66. build 1579
-Improved collation handling when restructuring a table.