8000 duckdb sql tools v1.4.0 changelog and readme update for duckdb v0.9.2… · RandomFractals/duckdb-sql-tools@6194838 · GitHub
[go: up one dir, main page]
Skip to content

Commit 6194838

Browse files
RandomFractalsRandomFractals
committed
duckdb sql tools v1.4.0 changelog and readme update for duckdb v0.9.2 support
1 parent cc63848 commit 6194838

File tree

2 files changed

+20
-11
lines changed

2 files changed

+20
-11
lines changed

‎CHANGELOG.md

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2,6 +2,13 @@
22

33
See [releases](https://github.com/RandomFractals/duckdb-sql-tools/releases) for the `duckdb-sql-tools-x.x.x.vsix` extension package downloads.
44

5+
## v1.4.0 - [2023-12-01]
6+
7+
- Update DuckDB SQL Tools to support the latest DuckDB 0.9.2 version
8+
- Remove VS Code Memory Limit section from DuckDB SQL Tools doc
9+
- Add new SQLite Pro Tools info to the Pro Data Tools sections in DuckDB SQL Tools `README.md`
10+
- Package and publish DuckDB SQL Tools v1.4.0 with DuckDB v0.9.2 support
11+
512
## v1.3.0 - [2023-10-27]
613

714
- Update DuckDB SQL Tools and demo DuckDB configs to use new DuckDB v0.9.1 NodeJS libraries

‎README.md

Lines changed: 13 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -12,11 +12,11 @@
1212

1313
[DuckDB](https://duckdb.org/docs/) is an in-process SQL [OLAP](https://en.wikipedia.org/wiki/Online_analytical_processing) database management system that uses vectorized data engine for optimized analytics and parallel query processing with extensive SQL support and direct `Parquet`, `CSV`, and `JSON` data loading and query capabilites for local and remote data sources.
1414

15-
[DuckDB SQL Tools](https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools) *Preview* extension v1.3.0 adds the following basic DuckDB SQL capabilities to VS Code IDE for working with DuckDB instances:
15+
[DuckDB SQL Tools](https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools) *Preview* extension v1.4.0 adds the following basic DuckDB SQL capabilities to VS Code IDE for working with DuckDB instances:
1616

17-
- **Connect** to a local DuckDB v0.9.1 instance
17+
- **Connect** to a local DuckDB v0.9.2 instance
1818
- **Create** new in-memory DuckDB instance
19-
- **View** DuckDB v0.9.1 tables, columns, and views
19+
- **View** DuckDB v0.9.2 tables, columns, and views
2020
- **Run** SQL queries on open DuckDB connections
2121
- **Attach** SQLite database files to in-memory DuckDB instances
2222
- **Query** remote `CSV` and `Parquet` data files with [DuckDB HTTPFS](https://duckdb.org/docs/extensions/httpfs.html) extension
@@ -71,6 +71,8 @@ SQL Tools support many popular databases via the [official and community databas
7171

7272
![Pro Data Tools](https://github.com/RandomFractals/pro-data-tools/blob/main/docs/images/pro-data-tools.png?raw=true)
7373

74+
![SQLite Pro Tools](https://github.com/RandomFractals/pro-data-tools/blob/main/docs/images/sqlite-tools-extension.png?raw=true)
75+
7476
### DuckDB Pro Tools
7577

7678
**Pro Data Tools** include [DuckDB Pro Tools](https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#duckdb-pro-tools) extension that adds advanced [DuckDB](https://duckdb.org/) connection features and support to VSCode IDE, and provides database schemas display, DuckDB extensions and settings views, information schema and catalog views, SQL query API and user interfaces integrated with the popular SQL Tools extension, SQL query editor, SQL language server, and VS Code data processing tools.
@@ -101,6 +103,12 @@ The latest version of [DuckDB Pro Tools](https://github.com/RandomFractals/pro-d
101103

102104
![DuckDB Pro Tools View Commands](https://github.com/RandomFractals/duckdb-sql-tools/blob/main/docs/images/duckdb-pro-tools-view-commands.gif?raw=true)
103105

106+
## SQLite Pro Tools
107+
108+
**Pro Data Tools** VS Code extensions also include [**SQLite Pro Tools**](https://github.com/RandomFractals/pro-data-tools/blob/main/sqlite-tools.md). **SQLite Pro Tools** provide over a dozen of common SQLite database shortcut [Commands](https://github.com/RandomFractals/pro-data-tools/blob/main/sqlite-tools.md#commands), display table column data type and primary key indicators, SQLite database [Indexes](https://github.com/RandomFractals/pro-data-tools/blob/main/sqlite-tools.md#indexes), [Modules](https://github.com/RandomFractals/pro-data-tools/blob/main/sqlite-tools.md#modules), [Configuration Settings](https://github.com/RandomFractals/pro-data-tools/blob/main/sqlite-tools.md#configuration-settings) and [Functions](https://github.com/RandomFractals/pro-data-tools/blob/main/sqlite-tools.md#functions).
109+
110+
![SQLite Pro Tools Views](https://github.com/RandomFractals/pro-data-tools/blob/main/docs/images/sqlite-tools.png?raw=true)
111+
104112
### PRQL Pro Tools
105113

106114
Our [**Pro**](https://github.com/sponsors/RandomFractals/sponsorships?tier_id=18884) sponsors on github also get access to the premium [PRQL Pro Tools](https://github.com/RandomFractals/pro-data-tools/blob/main/prql-tools.md) VS Code extension. The initial private beta release of **PRQL Pro Tools** comes with custom [PRQL Code Lens](https://github.com/RandomFractals/pro-data-tools/blob/main/prql-tools.md#prql-code-lens) SQL Tools plugin that allows you to run [PRQL](https://prql-lang.org/) queries for the supported PRQL target [SQL dialects](https://prql-lang.org/book/project/target.html#dialects) directly using any of the supported SQL Tools extension drivers for the different database management systems.
@@ -204,13 +212,13 @@ Due to the limited time and minimal development effort invested into building th
204212

205213
## DuckDB Storage
206214

207-
**DuckDB SQL Tools** *Preview* v1.3.0 release of this extension supports only local database instances created with [DuckDB v0.9.1](https://github.com/duckdb/duckdb/releases/tag/v0.9.1) engine. Database instances and files created with other versions of DuckDB are not supported as they use different compression and storage formats and the structure of `.duckdb` file has been changing as DuckDB engine is evolving.
215+
**DuckDB SQL Tools** *Preview* v1.4.0 release of this extension supports only local database instances created with [DuckDB v0.9.2](https://github.com/duckdb/duckdb/releases/tag/v0.9.2) engine. Database instances and files created with older minor versions of DuckDB are not supported as they use different compression and storage formats and the structure of `.duckdb` file has been changing as DuckDB engine is evolving.
208216

209217
Use [DuckDB CLI](https://duckdb.org/docs/api/cli.html) to export data from the older database file versions and create new `.duckdb` file using the latest DuckDB storage implemenation. Read [Announcing DuckDB 0.9.0](https://duckdb.org/2023/09/26/announcing-duckdb-090.html) blog post for more information about DuckDB v0.9 storage improvements and new features.
210218

211219
You can use prior [`v1.0.2`](https://github.com/RandomFractals/duckdb-sql-tools/releases/tag/v1.0.2) of this free **DuckDB Sql Tools** *Preview* extension to work with the older DuckDB [v0.6.1](https://github.com/duckdb/duckdb/releases/tag/v0.6.1) files. DuckDB SQL Tools [`v1.1.0`](https://github.com/RandomFractals/duckdb-sql-tools/releases/tag/v1.1.0) supports DuckDB [v0.7.1](https://github.com/duckdb/duckdb/releases/tag/v0.7.1), and DuckDB SQL Tools [`v1.2.0`](https://github.com/RandomFractals/duckdb-sql-tools/releases/tag/v1.2.0) supports DuckDB [v0.8.1](https://github.com/duckdb/duckdb/releases/tag/v0.8.1).
212220

213-
The **Premium** [**DuckDB Pro Tools**](https://github.com/RandomFractals/pro-data-tools/tree/main#duckdb-pro-tools) extension version, available to our [**Pro** sponsors](https://github.com/sponsors/RandomFractals/sponsorships?tier_id=18884) on GitHub, supports DuckDB [v0.8.1](https://github.com/duckdb/duckdb/releases/tag/v0.8.1) files with many advanced SQL Tools features, and will be updated to support the latest DuckDB [v0.9.0](https://github.com/duckdb/duckdb/releases/tag/v0.9.0) storage format and features soon.
221+
The **Premium** [**DuckDB Pro Tools**](https://github.com/RandomFractals/pro-data-tools/tree/main#duckdb-pro-tools) extension version, available to our [**Pro** sponsors](https://github.com/sponsors/RandomFractals/sponsorships?tier_id=18884) on GitHub, supports DuckDB [v0.8.1](https://github.com/duckdb/duckdb/releases/tag/v0.8.1) files with many advanced SQL Tools features, and will be updated to support the latest DuckDB [v0.9.x](https://github.com/duckdb/duckdb/releases) storage format and features soon.
214222

215223
## Read-Only DuckDB
216224

@@ -228,12 +236,6 @@ You can experiment with writable `:memory:` DuckDB instances in this **DuckDB SQ
228236

229237
Sign up for the Premium [Pro Data Tools on GitHub](https://github.com/sponsors/RandomFractals/sponsorships?tier_id=18884) to get access to the [**DuckDB Pro Tools**](https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#duckdb-pro-tools) and work with the latest versions of DuckDB files in read and write modes.
230238

231-
## VS Code Memory Limit
232-
233-
You can adjust the amount of RAM allocated to VS Code IDE to enable opening large files and load more data into memory. Go to `File -> Preferences -> Settings` and type `files.maxMemoryForLargeFilesMB` in the Setting search field to change it. For example, users with 64GB of RAM can change it to `49152` MB to allow VS Code use 48GB of available memory.
234-
235-
![VS Code Max Memory Setting](https://github.com/RandomFractals/duckdb-sql-tools/blob/main/docs/images/vscode-max-memory-setting.png?raw=true)
236-
237239
# Configuration
238240

239241
[SQL Tools](https://marketplace.visualstudio.com/items?itemName=mtxr.sqltools) extension provides many configuration [Settings](https://vscode-sqltools.mteixeira.dev/en/settings/) users can toggle to change database connection and tree view display options, sql formatting, and results display.

0 commit comments

Comments
 (0)
0