SQLite Expert 1.7.25
Release date: September 19, 2008
SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating. SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.
Features and Benefits
By using SQLite Expert you will be able to:
- 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 visually 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 and PNG image formats. BLOB fields can be edited with the integrated hex editor.
- Execute SQL queries and display results in the grid or as text.
SQLite Expert Feature Comparison Matrix
Compare editions of SQLite Expert to determine the one that best meets your needs.
Personal | Professional | |
---|---|---|
Managing SQLite3 databases | ||
Create database | ![]() |
![]() |
View and change database parameters | ![]() |
![]() |
Register frequently used databases for using in SQLite Expert | ![]() |
![]() |
Check integrity | ![]() |
![]() |
Vacuum | ![]() |
![]() |
Transaction support | ![]() |
![]() |
Export to Excel | ![]() |
|
Import and export from and to text files (CSV, TSV) | ![]() |
|
Import data from ADO data source | ![]() |
|
Transfer data between SQLite databases | ![]() |
|
Export data to script | ![]() |
|
Managing tables | ||
Create tables | ![]() |
![]() |
Delete tables | ![]() |
![]() |
Rename tables | ![]() |
![]() |
Restructure tables without losing existing data | ![]() |
![]() |
View, add, delete, modify, reorder fields | ![]() |
![]() |
View, add, delete, modify indexes | ![]() |
![]() |
View constraints | ![]() |
![]() |
Add, delete, modify constraints | ![]() |
|
View triggers | ![]() |
![]() |
Add, delete, modify triggers | ![]() |
|
Supports temporary tables | ![]() |
![]() |
Managing views | ||
Create views | ![]() |
![]() |
Delete views | ![]() |
![]() |
Rename views | ![]() |
![]() |
View triggers | ![]() |
![]() |
Add, delete, modify triggers | ![]() |
|
Supports temporary views | ![]() |
![]() |
Executing SQL scripts | ||
Execute SQL scripts | ![]() |
![]() |
Stop long running queries | ![]() |
![]() |
SQL history | ![]() |
![]() |
SQL syntax highlighting | ![]() |
![]() |
Save and load SQL scripts | ![]() |
![]() |
Query Builder | ||
Completely visual building of complex SQL queries | ![]() |
|
User-friendly interface with drag & drop support | ![]() |
|
Visual building of sub-queries and unions | ![]() |
|
Visual criteria constructing tool for Where and Having clauses | ![]() |
|
Save and load SQL scripts | ![]() |
|
Displaying and editing data | ||
Display and edit data in the grid | ![]() |
![]() |
Display data as text | ![]() |
![]() |
Limit the number of records in result set | ![]() |
![]() |
Image editor (supports BMP, JPG and PNG) | ![]() |
![]() |
BLOB editor | ![]() |
![]() |
Text editor | ![]() |
![]() |
Generate HTML Reports | ![]() |
|
Extending SQLite Expert using scripting | ||
Lua scripting support | ![]() |
|
Pascal scripting support | ![]() |
|
Lua and Pascal example scripts | ![]() |
|
Data types | ||
40 predefined data types | ![]() |
![]() |
Custom data types | ![]() |
![]() |
Screenshots
Here are some screenshots of SQLite Expert performing different actions on the demo database. You can click on these thumbnails to see a larger version.