it keeps asking me to upgrade "duckdb-async@0.6.1" to connect

[markxwang]

and running

 npm install duckdb-async@0.6.1 && exit 0

returned errors.

Any feedback is appreciated!

[RandomFractals]

You must have a newer version of DuckDB installed and using it with NodeJS.

I released this free trial DuckDB SQL Tools extension back in January when only DuckDB v0.6.1 for NodeJS was available.

Since then DuckDB team released v0.7.1 in February and v0.8.0 recently. DuckDB library and .duckdb files are not compatible when using different file or library versions. So, you'll have to install the older version of duckdb-async library to try that free extension.

You can also sign up for the paid monthly Pro Tools tier on github to sponsor our work on those extensions, and get access to DuckDB Pro Tools with more features and DuckDB v0.7.1 support.

We plan to update and release new Pro Tools version with the latest DuckDB v0.8.0 later this month.

[markxwang]

Thank you!

[RandomFractals]

We just released DuckDB SQL Tools Preview v1.1.0 with DuckDB v0.7.1 support:

https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools

Also, see new VS Code SQL and Pro Data Tools section in docs covering the premium SQL Data Tools with DuckDB v0.8 support:

https://github.com/RandomFractals/duckdb-sql-tools#vs-code-sql-and-pro-data-tools