- Support
sqlitedriver. Connect to on-disk SQLite files (or use :memory:).- The implementation uses the JS-only sql.js library. This may cause incompatibility with large database files on memory constrained devices. But, this avoids having to package native bindings for every platform and keeps the door open for in-browser support.
- Fix rendering of binary and JSON data.
- Serialize binary data as hexadecimal with a
0xprefix. - Marshal JSON data to a string.
- Serialize binary data as hexadecimal with a
- Inline all dependencies to reduce bundle size by ~20%.
-
When clicking
Run All, cells now execute in series. Previously, cells executed in parallel. -
New configuration option for maximum number of result rows before truncating the result table. Defaults to
25.
{
"SQLNotebook.maxResultRows": 25
}- Fix for
mysqldriver result tables that caused each row to render with its own header.
- Bundle
sqlslanguage server intovscode-sql-notebook.- When running on a compatible arch/os, notebooks can now
benefit from intelligent autocomplete and hover information
when connected to a valid database connection. To enable this unstable
feature, add the following to your
settings.json.
- When running on a compatible arch/os, notebooks can now
benefit from intelligent autocomplete and hover information
when connected to a valid database connection. To enable this unstable
feature, add the following to your
{
"SQLNotebook.useLanguageServer": true
}- New configuration option for query timeout in milliseconds. Defaults to 30000.
{
"SQLNotebook.queryTimeout": 30000
}