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.
Features SQLite Expert Professional:
- 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.
SQLite Expert Professional Version 5.3
- Added support for UPSERT clause.