- 05, Jun 2020
- #1
SQLite Expert
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.
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
.
Supported platforms: Windows 2000, XP, Vista, 7, 8, 10.
Data editing
Visual SQL Query Builder
Powerful restructure capabilities
Import and Export data
Other features
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.
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
.
Supported platforms: Windows 2000, XP, Vista, 7, 8, 10.
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
.
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.
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.
