v0.14.1

0.14.1 (04 Jun 2022)

Fixed

1. Fixed bug in the SQL parser that caused queries with CREATE TRIGGER to be parsed incorrectely (#211)

v0.14.0

0.14.0 (06 Nov 2021)

Added

1. Added support for the new PRAGMA command table_xinfo (mandel59 [PR#193])

2. Added new keywords to support newer SQLite versions (mandel59 [PR#191])

Fixed

1. Fix bug that caused the table view to not be shown on the new VSCode version (1.61) (mandel59 [PR#197])

Changed

1. Increased minimum supported VSCode version to 1.61.0 (mandel59 [PR#197])

v0.13.0

Added

1. New setting "sqlite.databaseExtensions", that allows running custom queries whenever a database is opened.

2. Added support for dot commands (like .tables, .schema ecc).

Fixed

1. Fix bug when running a query with a comment inside (#167)

v0.12.0

Changed

1. Disable sqlite.sqlite3 setting for untrusted workspaces.

Added

1. Command SQLite: Change Workspace Trust to change the trust of the current workspace.

v0.11.1

Changed

1. The icon used on the sidebar view has been changed to the database icon (MrCodingB [PR#153])
2. The database picker now uses the relative path of the database instead of the name (#117)

Other

1. Improved error messages (#143)

v0.10.1

Fixed

1. Fixed table and column name escaping when creating queries (mandel59 [PR#138])

v0.10.0

Fixed

1. The SQLite binaries provided with the extension are now executable.

Added

1. The total number of records is now displayed in the result view header.

v0.9.0

Fixed

1. Fixed bug that caused result view to not be displayed after opening it one time (#120, #125, #127)

Changed

1. In the result view, the sql statement is now hidden by default and can be displayed by clicking the SQL button
2. In the result view, the page section has been moved from below the table to the header above the table.

Other

1. Decreased extension size, removed useless files and sources are now bundled.
2. Changed result view frontend framework from preact to React.
3. Removed clipboardy dependency in favour of VSCode clipboard.
4. Increase minimum VSCode version from 1.23 to 1.30