SQLite Expert Professional

SQLite Expert Professional: Administration tool for SQL databases

SQLite Expert Professional is a visual tool that allows you to administer your SQLite3 databases without any hassles.

SQLite Expert integrates database management as well as maintenance into a single environment, with an innovative graphical interface that is very easy to use.

Features
- edit tables as well as views visually – no need to write a line of SQL
- restructure constraints, indexes, fields, and triggers without data loss to existing tables
- build SQL scripts
- visually generate views using the built-in query builder
- lets you create SQLite3 databases
- you can visualize and modify database parameters
- verify database integrity
- allows you to compact databases
- data can be transferred with ease between SQLite databases
- data can be imported from ADO data sources and SQL scripts
- you can export data to SQL scripts
- data is displayed and edited in the grid, including BLOB and image fields
- support is provided for GIF, PNG, BMP, ICO, and JPG image formats
- you can easily edit BLOB fields with the built-in hex editor.
- capable of executing SQL queries and show the results as text or in the grid
- includes repair function for damaged databases
- allows you to backup databases online
- support is enabled for temporary tables
- virtual tables are supported, including RTREE, FTS3 and FTS4
- contains ICU extension and multiple SQL tabs.
- predefined and custom data types are included.
- enables you to copy and paste tables and records between databases using the clipboard
- advanced SQL editor with useful options such as code completion and syntax highlighting
- advanced data editing options are provided in the grid with built-in editors for image, text and BLOB
- unicode support is provided
- customizable via skins
- tables can be copied between databases via drag and drop
- copy tables between databases using drag and drop
- support is offered for encrypted databases
- Export data to ADO, CSV, TSV, HTML, XML, and Excel data sources as well as SQL script, and SQLite database