SQLite Expert 是一個強大的工具，旨在簡化 SQLite3 數據庫的開發。它是一個功能豐富的SQLite管理和開發工具，旨在滿足所有用戶的需求，從編寫簡單的 SQL 查詢到開發複雜的數據庫。
圖形界面支持所有 SQLite 功能。它包括一個可視化查詢構建器、一個帶有語法突出顯示和代碼完成功能的 SQL 編輯器、可視化表和視圖設計器以及強大的導入和導出功能。
支持的平台：Windows 2000/XP/2003/Vista/7/8/10/11
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.
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.
Other features
Full Unicode support.
Support for attached databases.
Supports SQLite extensions and third-party SQLite libraries.
Lua and Pascal scripting support.
Recent features
View all the functions and collations installed by each SQLite extension!
New in 3.5: Added support for partial indexes.
New in 3.5: Added support for tables without rowid.
| Feature comparison | Professional |
| Manage SQLite3 databases: create database, view/change parameters. | V |
| Repair damaged databases. | V |
| Database DDL compare tool. | V |
| Online backup of databases. | V |
| Check integrity, reindex all tables, transaction support. | V |
| Supports attached databases and SQLite extensions. | V |
| Manage tables: create, delete, rename, reindex. | V |
| Restructure tables: fields, indexes, foreign keys, unique and check constraints, triggers. | V |
| Manage views: create, delete, rename, restructure. Manage view triggers. | V |
| Supports temporary tables and views. | V |
| Supports virtual tables including RTREE, FTS3 and FTS4. | V |
| Includes ICU extension. | V |
| Advanced SQL editor with code completion and syntax highlighting. | V |
| Multiple SQL tabs. | V |
| Advanced data editing capabilities in the grid: image, BLOB and text editors. | V |
| Custom and predefined data types. | V |
| Copy/Paste records between tables via clipboard. | V |
| Copy/Paste tables between databases via clipboard. | V |
| Full Unicode support. | V |
| Customize the look and feel of the application using skins. | V |
| Visual SQL Query Builder. | V |
| Copy tables between databases using drag and drop. | V |
| Supports password protected databases (requires third party SQLite library - not included). | V |
| Supports SQLite auto extensions. | V |
| Export data to Excel, XML, JSON, HTML, CSV, TSV, ADO data sources, SQL script, SQLite database. | V |
| Import data from ADO data source, SQL script, SQLite, CSV, TSV. | V |
| Send the contents of any grid to printer or export it to a PDF file. | V |
| Generate SELECT, INSERT, UPDATE and DELETE statements based on the visible fields on the current table. | V |
| Lua and Pascal scripting support. | V |
View change script
A new feature in version 4.0 is the ability to view the change script before applying changes.
New in 3.0: printing support
A recent feature introduced in version 3.0 is printing support. The content of any grid can be sent to the printer or exported to a PDF file.
Customize look and feel using styles
Also introduced in version 3.0 is the ability to customize the look and feel of the application using styles.
SQL Query Builder
If you are not an SQL expert but want to create complex queries visually, you can use the integrated Query Builder to generate SQL SELECT queries in a visual interface.
Executing SQL Queries
SQLite Expert allows users to easily execute SQL scripts and display the results in the grid or as text. The result set is also editable if all columns in the selection query are from one table.
SQLite Expert supports syntax highlighting, saving and loading scripts to/from files, SQL history, and interrupting the execution of long running queries.
Displaying and editing data in the grid
SQLite Expert allows users to insert, delete and edit the table data in the grid.
You can just click a grid cell and modify its value. Clicking on the "Post" button in the navigator panel will save the data to database. You can use Up, Down, PageUp and PageDown keys to traverse the grid cells.
