Changelog

Version 1.0.0

Latest 2026

Added

• Connections — open / create databases, SQLCipher password prompt, recent files, multi-database explorer, open a .db from the command line or a file association.
• Welcome / home screen — logo hero, “Get started” cards, and a recent-databases list with size and last-modified date.
• Explorer — searchable database list with a count badge, per-database file path, and a summary footer (database count + total size). Rich right-click menus on databases and objects.
• Browse & edit — schema tree (tables, views, indexes, triggers), paged data grid with inline cell edit, insert & delete (rowid / PK-safe), per-table export. Enter moves to the next column (Excel-style), Tab works across cells.
• SQL workspace — editor with SQLite syntax highlighting and schema-aware autocomplete (Ctrl+Space), run script or selection (F5), multiple result grids, persistent query history, and a “Run against” picker so each editor's target database is explicit.
• Schema designer — visually create tables with live DDL preview; rename / drop tables, views, indexes and triggers from the tree.
• Interactive ER Designer — drag tables onto a canvas, edit columns inline, draw foreign-key relationships (field-to-field), preview the SQL live, and create the schema in the selected database in one click.
• ER diagram — visual map of an existing database's tables and foreign-key relationships.
• Import / export — CSV & JSON import with type inference and table creation; run .sql scripts; export tables / queries to CSV, JSON, or SQL INSERT; dump a whole database to .sql.
• Backup / restore — online backup API (safe on a live database) and restore.
• Maintenance — stats, VACUUM, ANALYZE, REINDEX, integrity check, and encrypt / decrypt / change-password (SQLCipher).
• Settings — light / dark theme (light by default) and default page size.
• UI — professional light theme, highlighted active tab, a vertical utility rail (History, Refresh, Maintenance, Settings, About), splash screen, and an About dialog with version, auto-incrementing build number / date and a link to backendside.com.
• Packaging — self-contained single-file Windows build (sqlitedesk.exe) and an MSIX package for the Microsoft Store.

Fixed

• New encrypted databases are now actually encrypted on creation (a never-written keyed database used to stay an unencrypted empty file). Passwords are never persisted.
• Inserting a new row no longer fails with “datatype mismatch” when the primary key is blank.

Notes

• The build number increments automatically on every build and is shown in the About dialog.