Feature comparison¶
SQLite Expert comes in two editions: the free Personal Edition and the paid Professional Edition. Both share the same core database and visual table-design features, including STRICT tables, generated columns, the full set of database checks and the query plan viewer. Both also share the JSON editor and the value inspector. The Professional Edition adds reporting and printing, the full range of import/export formats, encrypted-database support, the ICU extension, scripting, the database compare tool, and repair and recovery of damaged databases.
The table below compares the two editions in detail. To purchase the Professional Edition, see Ordering.
| Personal | Professional | |
| General | ||
| Customize the appearance of the application using skins | ✅ | ✅ |
| Send the contents of any grid to printer or export it to a PDF file | ✅ | |
| Managing SQLite3 databases | ||
| Create database | ✅ | ✅ |
| View and change database parameters | ✅ | ✅ |
| Register frequently used databases for using in SQLite Expert | ✅ | ✅ |
| Check integrity | ✅ | ✅ |
| Check foreign keys | ✅ | ✅ |
| Check schema references in views and triggers | ✅ | ✅ |
| Check every index against the table it indexes | ✅ | ✅ |
| Vacuum | ✅ | ✅ |
| Vacuum into a new file | ✅ | ✅ |
| Reindex all tables | ✅ | ✅ |
| Analyze and optimize (query planner statistics) | ✅ | ✅ |
| Incremental vacuum | ✅ | ✅ |
| Checkpoint the write-ahead log (WAL) | ✅ | ✅ |
| Transaction support | ✅ | ✅ |
| Supports attached databases | ✅ | ✅ |
| Supports encrypted databases | ✅ | |
| Supports SQLite extensions | ✅ | ✅ |
| Supports SQLite auto extensions | ✅ | |
| Includes ICU extension | ✅ | |
| Schema tab — a text report of the whole database: every object with its columns, indexes, triggers and constraints | ✅ | |
| Import and export data — Excel, ODS, XML, HTML, JSON, text files (CSV, TSV), SQL scripts, ADO data sources, and between SQLite databases | ✅ | |
| Compare two databases, schema and data, and write a migration script | ✅ | |
| Online backup of a database | ✅ | |
| Repair a damaged database into a new file | ✅ | |
| Recover a badly damaged database page by page, with a lost-and-found table | ✅ | |
| Open multi-gigabyte databases, with rows read as they are scrolled to | ✅ | ✅ |
| Managing tables | ||
| Create tables | ✅ | ✅ |
| Delete tables | ✅ | ✅ |
| Rename tables | ✅ | ✅ |
| Reindex tables | ✅ | ✅ |
| Restructure tables without losing existing data, using ALTER TABLE where SQLite allows it | ✅ | ✅ |
| View, add, delete, modify, reorder fields | ✅ | ✅ |
| Copy/Paste fields via clipboard | ✅ | ✅ |
| View, add, delete, modify foreign keys | ✅ | ✅ |
| Copy/Paste foreign keys via clipboard | ✅ | ✅ |
| View, add, delete, modify indexes | ✅ | ✅ |
| Copy/Paste indexes via clipboard | ✅ | ✅ |
| View constraints | ✅ | ✅ |
| Add, delete, modify constraints | ✅ | ✅ |
| Copy/Paste constraints via clipboard | ✅ | ✅ |
| View triggers | ✅ | ✅ |
| Add, delete, modify triggers | ✅ | ✅ |
| Copy/Paste triggers via clipboard | ✅ | ✅ |
| Supports temporary tables | ✅ | ✅ |
| Supports virtual tables including RTREE, FTS3, FTS4 and FTS5 | ✅ | ✅ |
| Supports STRICT tables | ✅ | ✅ |
| Supports generated columns, stored and virtual | ✅ | ✅ |
| Managing views | ||
| Create views | ✅ | ✅ |
| Delete views | ✅ | ✅ |
| Rename views | ✅ | ✅ |
| View triggers | ✅ | ✅ |
| Add, delete, modify triggers | ✅ | ✅ |
| Copy/Paste triggers via clipboard | ✅ | ✅ |
| Supports temporary views | ✅ | ✅ |
| Executing SQL scripts | ||
| Execute SQL scripts | ✅ | ✅ |
| Stop long running queries | ✅ | ✅ |
| SQL code formatting (experimental) | ✅ | ✅ |
| SQL syntax highlighting | ✅ | ✅ |
| SQL Code Completion | ✅ | ✅ |
| Save and load SQL scripts | ✅ | ✅ |
| Supports parameters in SQL scripts | ✅ | ✅ |
| Explain the query plan of a statement | ✅ | ✅ |
| Query Builder | ||
| 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 | ✅ | |
| Schema diagram | ||
| View the database as an entity-relationship diagram | ✅ | |
| Relationships drawn between the columns they join, with cardinality | ✅ | |
| Arrange automatically, or place the tables yourself and keep the layout | ✅ | |
| Save the diagram as a picture, or export it to PDF | ✅ | |
| Print the diagram, tiled across sheets or on a single page | ✅ | |
| 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 | ✅ | ✅ |
| JSON editor for cell values, JSON text and JSONB | ✅ | ✅ |
| Value inspector — how a value is stored, its type and affinity, and every way a number reads as a date | ✅ | ✅ |
| Copy/Paste records between tables via clipboard | ✅ | ✅ |
| Copy/Paste tables between databases via clipboard | ✅ | ✅ |
| Copy tables between databases using drag and drop | ✅ | |
| 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 | ✅ | ✅ |