Fixed
- Fixed bug in the SQL parser that caused queries with
CREATE TRIGGER
to be parsed incorrectely (#210)
Added
-
Added support for the new
PRAGMA
commandtable_xinfo
(mandel59 [PR#193]) -
Added new keywords to support newer SQLite versions (mandel59 [PR#191])
Fixed
- Fix bug that caused the table view to not be shown on the new VSCode version (1.61) (mandel59 [PR#197])
Changed
Added
-
New setting
"sqlite.databaseExtensions"
, that allows running custom queries whenever a database is opened. -
Added support for dot commands (like
.tables
,.schema
ecc).
Fixed
- Fix bug when running a query with a comment inside (#167)
Changed
- Disable
sqlite.sqlite3
setting for untrusted workspaces.
Added
- Command
SQLite: Change Workspace Trust
to change the trust of the current workspace.
Changed
- The icon used on the sidebar view has been changed to the database icon (MrCodingB [PR#153])
- The database picker now uses the relative path of the database instead of the name (#117)
Other
- Improved error messages (#143)
Fixed
Fixed
- The SQLite binaries provided with the extension are now executable (#135)
Added
- The total number of records is now displayed in the result view header. (#131)
Changed
- Changed font style of the result view to be the same as the editor font style.
Fixed
Changed
- In the result view, the sql statement is now hidden by default and can be displayed by clicking the SQL button
- In the result view, the page section has been moved from below the table to the header above the table.
Other
- Decreased extension size, removed useless files and sources are now bundled.
- Changed result view frontend framework from preact to React.
- Removed clipboardy dependency in favour of VSCode clipboard.
- Increase minimum VSCode version from 1.23 to 1.30
Fixed
- Fixed bug that sometimes caused result view to not be displayed in a remote session (#94)
- Fixed bug in the SELECT/INSERT sql generation for columns with spaces in the name (#97)
- Fixed bug that prevented database with single quotes in the path to be opened correctly (#106)
Changed
- Whenever an error is encountered retrieving a table or a view when opening a database, a warning is displayed in the SQLite output channel (previously the database failed to open completely) (#99)
Fixed
- Fixed bug that caused empty strings in the query to be parsed incorrectly (#82).
Added
- Added command
Run Selected Query
to run only the query selected in the document.
Changed
- The command
Run Query
now runs every query in the document (previously if there was a query selected it ran that query)
Fixed
- Fixed bug that caused SQLite binaries with version not supported to not throw an error when used.
- Fixed bug that caused, in some OSs, SQLite binaries to not work as expected.
Added
- Added setting
"sqlite.databaseExtensions"
, to customize file extensions recognized as SQLite database.
Changed
- Autocompletion now suggests only the name of the column (instead of
[table].[column]
) - The statement in the result panel is now collapsed in a single line and can be expanded clicking on it.
Added
- Added option in the sqlite explorer to copy database path.
- Added option in the sqlite explorer to copy table/column name.
- Added option in the sqlite explorer to create a new table query (Select/Insert).
- Added option in the files explorer to create a new database query.
- Added command in the command palette to refresh sqlite explorer databases.
- Added support for
EXPLAIN QUERY PLAN
.
Fixed
- Log level is now changed correctly.
- Fixed bug that caused the last line of the result table to disappear after hiding and then showing the result table.
- Fixed bug that prevented empty tables from showing in the sqlite explorer (#63)
Changed
- Changed view table icon.
- New lines are now rendered in the result table.
Other
- Improved query performance.
- Improved query logging.
Fixed
- Fixed bug that caused table field with HTML code to be rendered. (#59)
Fixed
- Fixed bug that caused intellisense to not work on
New Query
document (#55)
Added
- Added language
sqlite
(thanks to mandel59).
Fixed
- Fixed bug on Windows that prevented the result view from being show when the extension was not on the same disk as Visual Studio Code (thanks to mandel59)
- Fixed bug on Windows that replaced unicode characters in the database path and in the query with question marks (thanks to mandel59)
- Fixed bug that sometimes prevented the last line of the table in the result view from being shown.
- The result view is now kept open when there is an error in the query.
- Removed system tables (
sqlite_sequence
andsqlite_stat1
) from the sqlite explorer. - Removed
:memory:
from the databases you can choose when adding a database to the explorer.
Added
- The sqlite explorer now supports views.
- Added icons to distinguish between tables and views in the explorer.
- Added support for :memory: database.
Fixed
- Fixed bug that prevented custom sqlite paths from being recognized as a command on Windows.
- Fixed bug that sometimes truncated the error message.
Added
- Added command:
SQLite: Show output
, to show the extension's output channel.
Other
- Updated SQLite3 binaries to the version 3.26.0
Fixed
- Fixed bug that prevented the extension from recognizing executable paths set in the setting
sqlite.sqlite3
.
Added
- Added autocompletion for sqlite keywords, table names, column names.
- Added
.db3
,.sdb
,.s3db
as recognized extensions for an sqlite3 database (thanks to LokiSharp) - Added support for binary data, now displayed as hex string
Fixed
- Fixed bug that prevented the correct execution of queries on tables with the same name as sqlite keywords (e.g Order, Select, Table...)
Added
- Export result to
html
. - Export multiple results to
csv
,html
orjson
. - Added option to open/use a database outside your workspace.
- Keyboard shortcut
ctrl+shift+q
to execute document query
Removed
- Setting:
sqlite.outputBuffer
. - Setting:
sqlite.autopick
, the option to choose a database outside the workspace removed the usefulness of autopick.
Fixed
- Fixed an issue that prevented the correct execution of a query in multiple lines and without an ending semicolon.
Other
- Improved performance and responsiveness.
Added
- Setting:
sqlite.outputBuffer
, query output buffer in bytes.
Added
- Pagination, tables are now displayed in pages, each page with a set number of records.
- Setting:
sqlite.recordsPerPage
, to set the number of records per page.
Removed
- Setting:
sqlite.showTableLimit
, now that pagination is supported this setting is useless.
Fixed
- Fixed a bug that prevented the export button from working correctely.
- Fixed a bug that prevented the correct execution on Windows of queries composed of multiple statements.
Fixed
- Fixed bug that prevented the query result from showing on Windows.
Added
- Export query result to Json.
- Export query result to Csv.
- Show/Hide query result.
Changed
- Improved query result graphic.
Fixed
- Explorer: Show Table can now display more records.
Fixed
- Fixed bug that prevented the database from showing in the explorer if it was previously closed.
Added
- New setting:
sqlite3.logLevel
, to set the logging level of the output channel. - New setting:
sqlite3.showTableLimit
, to limit the records displayed when showing a table using Show Table (in SQLite Explorer).
Changed
sql
document database can now be changed from the status bar.- SQLite output channel now displays time and log level.
Added
- Added new command: Quick Query, execute a query directly without creating a new sql document.
- Tables in the explorer are now ordered alphabetically.
- Explorer: new icons for primary key, not null and nullable fields.
- Explorer: added default value in the columns' tooltip when default value is not NULL
Fixed
- Composite primary keys are now all recognized as primary keys.
- Comments inside a comment in an sql document are now parsed correctely.
Fixed
- unicode characters are now shown correctely
Fixed
- fixed a bug that prevented the correct parsing of the query result when it contained an escaped quote
- fixed a bug that crashed the extension when the query result contained a unicode character inside the string
Other
- improved quality of the icon
Fixed
- fixed a bug that showed unicode characters as octets.
Initial release