SQLite Expert is a powerful tool designed to simplify the development of SQLite3 databases. It is a feature rich administration and development tool for SQLite designed to answer the needs of all users from writing simple SQL queries to developing complex databases.
Home Page - http://www.sqliteexpert.com/
The graphical interface supports all SQLite features. It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities.
Visual SQL Query Builder
- Build complex SQL queries with ease.
- Formatted SQL query text layout.
- Powerful means of SQL query parsing and analysis.
- Advanced SQL editor with syntax highlighting and code completion.
Data editing
- Edit data in the grid using powerful in-place editors.
- Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats.
- Visualize and modify BLOB fields using the integrated Hex editor.
Powerful restructure capabilities
- Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints.
- Restructure any complex table without losing data.
- Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes.
Import and Export data
- Import data from ADO data source, CSV files, SQL script or SQLite.
- Export data to CSV files, SQL script, Excel or SQLite.
- Copy tables between SQLite databases using drag and drop operations.
- Export data to Excel via clipboard.
Other features
- Full Unicode support.
- Support for attached databases.
- Supports SQLite extensions and third-party SQLite libraries.
- Lua and Pascal scripting support.
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.