Aquesta és la versió actual. · Data de publicació:
Fitxers d’instal·lació 6.2.9.743
| Arquitectura | Tipus | Àmbit | Mida del fitxer | Baixa | SHA256 |
|---|---|---|---|---|---|
| 64 bits | EXE (Inno Setup) | Tots els usuaris | — | sqliteexpert.com | VirusTotal |
| 32 bits | EXE (Inno Setup) | Tots els usuaris | — | sqliteexpert.com | VirusTotal |
L’enllaç i l’SHA256 provenen del manifest comunitari del Gestor de paquets del Windows. Convé comparar el hash del fitxer baixat abans d’executar-lo.
Notes de la versió
- 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.
