PRO JSON Patch

Updating JSON values will now attempt to update the structure sparsely using SQLite's built-in json_patch and jsonb_patch utilities. This can be useful when another process has modified the JSON value while manually editing the value through the extension UI. Rather than overwriting the entire JSON value, only the properties that changed in the edit will be applied, preserving non-conflicting external changes.

This should be particularly useful when editing values in a VS Code tab and the Instant Commit setting.

Beware that this feature is still experimental and has a few sharp edges:

• Conflicts will still be resolved in favor of last-write, same as in the case of non-JSON values.
• This is subject to the limitations of SQLite's patch functions, specifically with respect to arrays, which are overwritten in whole.
• For textual JSON values, it will only attempt the new patch behavior if both values are strict RFC-8259 JSON values. SQLite supports a more relaxed standard for JSON, which also allows code comments. Applying patches through json_patch would not preserve these. JSONB columns do not have this limitation.
• This feature is not available for batch updates

Fixes

• PRO Fixed file upload UI not showing correctly when dropping a file onto a field in the 'New Row' dialog
• PRO Fixed a bug that made entering numeric values in the 'New Row' dialog difficult
• PRO JSON/B input field are now rendered correctly in 'New Row' dialog

Known Issues

• Editing BLOBs with the 'Edit in VS Code' feature and the Hex Editor extension will write incorrect results back to the db.

PRO Drag & Drop File as BLOB

You can now drag and drop a file into the sidebar or modal fieldset to upload its content as a BLOB in the corresponding column. This is an alternative to the file picker and not limited to BLOB columns. This works with both OS files from the File Explorer/Finder as well as VS Code files from the file tree.

Changes

• PRO Removed per-cell datetime formats. The datetime format is now guessed per column.
• PRO Datetime format is now always shown in the header cell and its behavior is now the same as the one in the sidebar.
• PRO Fixed editing cell values in VS Code when column names include /.

Known Issues

• Poor performance for uploading larger files
• Missing loading indicators when undoing file uploads

PRO Edit in VS Code

You can now edit individual cell values in a tab in VS Code, making full use of VS Code's text editing features, installed extensions (Vim mode!), syntax highlighting, and more. This should be particularly useful when editing JSON/B columns.

You can access this feature through the "Edit in VS Code to the Side" icon button in the top right corner of a text area (visible on hover). There is now also a VS Code setting to configure the behavior of a cell double-click, allowing you to open it in the new VS Code tab feature instead of the built-in modal dialog.

This feature also makes use of VS Code's text syntax detection feature to open tabs with appropriate formatting pre-applied. This can be useful when storing HTML responses or Markdown content in SQLite.

For improved ergonomics, the behavior of the SQLite Viewer sidebar has been modified to auto-close when space is running low (i.e., when a VS Code tab opens to the side) and to auto-show when it becomes available again.

Changes

• PRO UTC/local time zone toggle is now always visible in column headers
• Improved queries for tables without ROWID and multiple primary keys
• Using BLOBs as primary keys in tables without ROWID now works, provided they are small (<= 48 bytes).
• Added a "Copy to clipboard" button to text areas that allows copying values to the clipboard without text cutoff limits
• Added an ellipsis "…" to the end of text values that were cut off due to size
• "Click to select" on text fields should be a little less finicky now
• Improved responsive sidebar handling with better width management
• Added "Open in VS Code" functionality to the Table Info SQL field
• Improved error handling, so that the sidebar is still accessible when an error occurs
• PRO Fixed invalid output when exporting a table with exactly 1 row as a JSON object
• PRO Fixed a bug that prevented deleting rows in tables without ROWID

Known Issues

• Exporting from within the viewer is broken when multiples DBs of the same name are open (export from the command pallette not affected)

PRO Export Dialog

Introduced a new export command for saving table data in multiple formats. This feature is designed as an alternative to the selection/clipboard-based export, especially for larger tables. Exported data is written directly to a file.

You can launch the export either as a standalone command from the Command Palette or through a modal dialog within the viewer. The modal dialog supports sorting and filtering, just like the clipboard export.

While this method can handle larger datasets than the clipboard export, it is still limited by JS' performance and the overhead of data marshalling. For exporting large tables (1M+ rows), a dedicated export tool is recommended.

Fixes

• PRO Fixed a bug that prevented images from being embedded in exported data.
• PRO The cutoff for inlined BLOBs can now be configured from the export dialog (also affects clipboard export) and now defaults to 10KB.
• Fixed an issue where the left sidebar could not be snapped to its minimum position.
• Added a warning when attempting to select more than 10,000 rows.

• Added forward and backward button
• Moved 'Expand All' button inside the sidebar (only visible on hover; same as VS Code explorer)
• Section headers in the left sidebar are now sticky
• Updated various dependencies

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