SQLite Expert Professional version 6.0.1 (64-bit)
-------------------------------------------------

Release date: August 2026

Copyright (C) 2026 Coral Creek Software

Homepage: www.sqliteexpert.com


ABOUT
-----

SQLite Expert is a powerful visual tool for creating, administering and
exploring SQLite 3 databases. It brings database design, data editing,
querying and maintenance together in a single graphical environment, so
most tasks can be done without writing a line of SQL - while full SQL
access is always one tab away.

The Professional edition adds the visual Query Builder, the full range of
import and export formats, reporting and printing, encrypted databases,
the ICU extension, and Lua and Pascal scripting.


WHAT'S NEW IN VERSION 6
-----------------------

 * New help system. The manual has been rewritten and is now HTML based,
   searchable and easier to read. Press F1 anywhere in the program.

 * 64-bit scripting fixed. In the 64-bit edition every Pascal scripting
   function that returns a string - ExtractFileName, IntToHex, Format,
   FormatDateTime and the rest - used to crash the script with an access
   violation. That, along with long-standing bugs in the file and
   byte-buffer routines (FileRead, FileWrite, FileSeek, FileSetDate,
   FileAge, StringToBytes), is fixed.

 * Standard Lua print. print now behaves as in any other Lua interpreter:
   tab-separated arguments, a terminated line, and correct rendering of
   every value type. io.write writes without separators or a newline.
   Scripts that ended a print with an explicit "\n" argument still work
   but now produce an extra blank line - drop the "\n".

 * Updated SQL parser and change-script generation, covering the latest
   SQLite syntax.

 * Many fixes for issues uncovered by an extensive code review and a new
   unit test suite.

 * The dbdemos sample database and the example scripts now install under
   the shared application data folder instead of next to the program:
   C:\ProgramData\SQLite Expert\Professional 6 - 64bit\
   Scripts that referred to the old location under Program Files need
   their paths updated.


FEATURES
--------

Designing databases

 * Restructure tables visually without losing the data already in them.
   SQLite Expert creates a new table with the new structure and copies
   the data across; the whole operation runs inside a transaction that is
   rolled back if anything goes wrong.
 * Add, delete, reorder and modify columns, foreign keys, indexes,
   constraints and triggers - and copy any of them between tables through
   the clipboard.
 * Review the generated SQL change script before it touches the database.
 * Visual editors for views and for virtual tables, including RTREE, FTS3
   and FTS4.

Viewing and editing data

 * Display and edit data in a fast grid, with filtering and in-grid
   editing of live queries.
 * Built-in editors for BLOB (hex), text and image columns (BMP, JPEG,
   PNG, GIF and ICO).
 * Copy records between tables, and whole tables between databases, using
   the clipboard or drag and drop.

Writing SQL

 * SQL editor with syntax highlighting, code completion and support for
   multiple statements in a single script.
 * Parameters in SQL scripts, and cancellation of long running queries.
 * Visual Query Builder for complex queries, sub-queries and unions, with
   drag and drop support; a query can be turned into a view.
 * Experimental SQL formatter on the SQL and DDL tabs.

Managing databases

 * Create databases, view and change their parameters, check integrity,
   vacuum (compact) and reindex.
 * Attached databases, transactions and savepoints.
 * Encrypted databases, SQLite extensions and auto extensions, and the
   bundled ICU extension for Unicode-aware collation and text handling.
 * Online backup, database schema report, and a tool that compares the
   DDL or schema of two databases.
 * Detailed space analysis through sqlite3_analyzer.exe.

Importing and exporting

 * Import from text files (CSV, TSV), ADO data sources, SQL scripts and
   other SQLite databases.
 * Export to Excel, ODS, XML, HTML, JSON, text files, SQL scripts and
   other SQLite databases.
 * Send the contents of any grid to the printer or to a PDF file, and
   generate HTML reports.

Extending the program

 * Lua and Pascal scripting, with example scripts included.

Data types and appearance

 * 40 predefined data types plus custom types, mapped onto SQLite's
   flexible type system.
 * Customizable appearance through the built-in skin library.


SYSTEM REQUIREMENTS
-------------------

Operating system: Windows 7, 8, 10 or 11 (64-bit, including ARM64)
Disk space:       a few megabytes; no other special hardware required
SQLite:           sqlite3.dll version 3.x, included


HELP AND SUPPORT
----------------

Press F1 anywhere in the program, or choose Help > Contents, to open the
manual. For technical support, the knowledge base, news and tips, visit
www.sqliteexpert.com. Suggestions and bug reports are welcome through
Help > Send Feedback; please include the version shown under Help >
About, the steps that led to the problem, and any error message you saw.


LICENSE
-------

SQLite Expert Professional can be evaluated free of charge for 30 days.
After that you need to either purchase a license or remove the software
from your computer. Licenses are sold on a subscription basis; to order,
choose Help > Buy Online from the main menu, or visit
www.sqliteexpert.com/order.html.

The full license agreement is in terms.txt, in the installation folder.
