SQLite Expert Personal: all versions and old releases

- Index Advisor on the SQL tab: SQLite’s own advisor suggests indexes that would speed up a query, and shows the resulting plan.
- Query History (SQL menu): every script run on the SQL tab, searchable, and reopened with a double-click.
- One Find window for the current grid (Ctrl+F, SQL results included), a table, or a whole database (Find in the tree). Contains, whole value, starts with or regular expression; match case; whole words; chosen columns. All matches are listed and highlighted; Go to Row opens the row.
- Recent searches are remembered. Esc or Clear Highlight removes the highlighting from a grid.
- Shorter tree and grid menus: related commands are grouped under submenus.
- Imports that create a table have a Column types option: descriptive types without sizes (the new default), STRICT type names, a STRICT table, or the old types with sizes. Floating-point columns are declared REAL.
- Imports store a value longer than its column’s declared size whole, and the text import stores yes/no as 1 or 0.
- The sample database uses SQLite’s type names (TEXT, REAL) without sizes.
- The Record Editor sizes each box to its value; drag the strip under a box to resize it.
- A new row appears in the grid at once, wherever it lands, and the cursor stays on it.
- The Value Inspector opens on a value that does not match its declared type, and the text editor saves such a value as stored.
- A tick box in a nullable column cycles through unchecked, null and checked.
- Ctrl+C while editing a cell on the Design tab copies the selected text, not the row.
- Fixed: an error on closing a database; a conversion error on arrow keys in yes/no and date cells; a blank row for a column added on the Design tab; Options failing on its second opening, and not reopening where it was closed.

- Added FastSpring integration.
- Added parser support for latest SQLite features.
- Added support for Windows 64-bit on ARM64 architecture.
- Added on-demand initialization of the printing system.