Download SQLite Expert Personal 6.2.12.746

- 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.
- Grid filters offer every condition on TEXT columns (less than, greater than, between, any of and the rest), not only the LIKE family. BLOB columns can be filtered with Is null and Is not null.
- Filters name NULL Is null and Is not null instead of “blank”, and show an empty string as (Empty), so the two no longer look alike.
- A text column’s header filter list has (Empty) and (Not empty) beside (Null) and (Not null). Equals or Does not equal with no value is a condition on the empty string; Is null is the one for NULL.
- Dates in grids are shown, edited and filtered as yyyy-mm-dd, the way they are stored, whatever the Windows date format.
- 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; a filter on a date column that left every row showing; a row edited out of a filter repeating the last row; a filter on a decimal number on a Windows that uses a decimal comma.
- Fixed in grid filters: a date range (Is between) or list (Is any of) that matched no row; a NULL row kept by Does not equal, Is less than, Is not like or a Not group where the app filters the rows itself (dates, and queries with a WHERE, ORDER BY or LIMIT); a UNION result filtered on its last SELECT only; an error filtering a join on a column both tables have, or an EXPLAIN result.