• PRO Fixed an issue that prevented inline foreign key previews from resolving
• PRO Inline FK content no longer loads for collapsed items (only loads when expanded).

PRO Markdown Preview

Columns that store markdown can now be viewed with a rendered preview in the row detail modal. A switch lets you toggle between plain text and the rendered view; You can treat any TEXT column as markdown by cycling its type in the column header (same gesture as for date/datetime). Declared types such as TEXT MARKDOWN or MDTEXT are recognized by default.

When you open a cell in a markdown column in VS Code, the file opens with a .md extension by default, so the editor uses markdown highlighting and tooling without relying on language detection.

Additions

• PRO Backspace now sets the focused column to NULL for all selected rows
• PRO In the row detail modal, date/time columns now show the same date display as in the table

Changes

• Resized textarea heights are now remembered for the duration of the session
• Opening a DB now selects the first table (not the first item, which could be a view)
• PRO All buttons that cycle properties now reset to their default value on right-click
• PRO Pragma Editor Optimize action now defaults to "Dry Run"
• PRO Date/raw toggle in modal is now per column

Fixes

• PRO Batch edit in row detail now updates all selected rows correctly
• PRO Fixed an issue where editing a cell via "Open in VS Code" could leave the selection stuck on "No row selected"
• Ctrl+A (Cmd+A) in sidebar inputs selects all text in that input only
• View row counts in the explorer show "∞" ("N/A") for unopened views instead of 0
• PRO Deprecated pragmas are no longer shown in the Pragma Editor

• Resolved visual artifacts that appeared during hover on fieldsets in certain themes
• PRO The "Collapse All" button for inlined foreign keys now collapses every expanded level

PRO Inline Foreign Keys in Row Detail

In the row detail modal (detail view), foreign key columns can now show the referenced row inline. You can expand or collapse each FK to see and edit the linked row without leaving the modal.

• Nested references are supported: expanding an FK can reveal further FKs in that row, each with its own expand/collapse.
• Editing works inline: you can change values in the referenced row and save; updates apply to the correct table.

Additions

• Primary key tooltips now list every table that references this column via foreign key
• The left sidebar now supports the same keyboard selection behavior as the main table
• Double-clicking a table or view in the left sidebar now expands or collapses it

Changes

• Changing focus in the main view no longer scrolls the corresponding value into view in the sidebar
• Fieldsets in the sidebar no longer display a visual active state
• PRO Input field placeholders for columns with default values now display the default value or expression instead of NULL
• PRO Input field placeholders for generated columns now display the generation expression
• PRO Input fields for generated columns are now disabled
• PRO The file extension for hex files was renamed from .hexblob to .hexdump

Fixes

• The right sidebar no longer loses its scroll position when it is (auto-)closed.
• No accept-drop state when dragging a column over another table (sidebar or header).
• PRO Add Column now accepts column types that contain spaces (e.g. TEXT MARKDOWN).
• PRO Various invalid foreign key/autoincrement/generated statements can no longer be created via the 'Add Column' UI

Additions

• PRO When adding columns to an empty table that references another table's composite primary key, the table now uses a single table-level FOREIGN KEY constraint instead of inline REFERENCES on each column

Fixes

• 'Without Row ID' and 'Strict' options in the table info panel are now disabled when using the Free Version
• PRO Add Table, Add Column, Drop Table, and drop column actions are now disabled when the database is read-only instead of throwing an error
• PRO Fixes a bug when adding a PRIMARY KEY column without specifying a column type
• PRO Dropping a column that is part of a composite primary key no longer fails
• PRO Fixed renaming of columns that are part of a composite primary key
• PRO Fixed reordering columns when renaming in an empty table
• PRO Fixed JSONB default values when adding or editing columns
• PRO Fixed over-escaping of quotes in generated SQL in certain instances

Browse the complete changelog to see all features, bug fixes, and improvements across every version of SQLite Viewer PRO.