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 | |
|
| Reindex all tables | |
|
| Transaction support | |
|
| Supports attached databases | |
|
| Supports encrypted databases | |
|
| Supports SQLite extensions | |
|
| Supports SQLite auto extensions | |
|
| View database schema report | |
|
| Export to Excel | |
|
| Export to XML | |
|
| 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 | |
|
| Reindex tables | |
|
| Restructure tables without losing existing data | |
|
| View, add, delete, modify, reorder fields | |
|
| Copy/Paste fields using the clipboard | |
|
| View, add, delete, modify indexes | |
|
| Copy/Paste indexes via clipboard | |
|
| View, add, delete, modify foreign keys | |
|
| Copy/Paste foreign keys via clipboard | |
|
| View, add, delete, modify constraints | |
|
| Copy/Paste constraints via clipboard | |
|
| View, add, delete, modify triggers | |
|
| Copy/Paste triggers via clipboard | |
|
| Supports temporary tables | |
|
| Managing views | ||
| Create views | |
|
| Delete views | |
|
| Rename views | |
|
| Add, delete, modify triggers | |
|
| Copy/Paste triggers via clipboard | |
|
| Supports temporary views | |
|
| Executing SQL scripts | ||
| Execute SQL scripts | |
|
| Stop long running queries | |
|
| SQL history | |
|
| SQL syntax highlighting | |
|
| Save and load SQL scripts | |
|
| Supports parameters in 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 | |
|
| Data filtering | |
|
| Image editor (supports BMP, JPEG, PNG, GIF and ICO) | |
|
| BLOB editor | |
|
| Text editor | |
|
| Copy/Paste records between tables via clipboard | |
|
| Copy/Paste tables between databases via clipboard | |
|
| Copy tables between databases using drag and drop | |
|
| 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 | |
|