SQLite Expert Professional is a straightforward and practical piece of software that helps you to manage and organize SQLite databases and gain better visibility into how your tables and classes are operating.
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 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, PNG, GIF and ICO image formats. BLOB fields can be edited with the integrated hex editor.
Execute SQL queries and display results in the grid or as text.
What’s New in This Release:
Both Win32 and Win64 versions.
Redesigned table/view/virtual table editors, using a new recursive-descent SQL parser based on COCO/R.
Separate editors for table and column constraints.
The change script is available before applying changes to a database object.