Released #DuckDBSqlTools v1.4.0 with #DuckDB v0.9.2 support:

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

📰 https://github.com/RandomFractals/duckdb-sql-tools/releases/tag/v1.4.0

#VSCode #SQLTools

📢 We just released #DuckDBSqlTools v1.3.0 for #VSCode IDE with the latest #DuckDB v0.9.1 support.

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

#SQL / #DataTools 🛠️

#DuckDB devs & users, we just hit 5K installs & over 7.6K downloads of our free & public #DuckDBSQLTools extension for #VSCode IDE.

DuckDB Labs & co. should just buy that extension to get more traction in the #DataTools field with #SQLTools devs, data scientists, data analysts, and other users using & exploring their DB in Code 😉

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

#DuckDBTools 🛠️ #ProDataTools 🧙‍♀️ ...

Released #DuckDBSqlTools v1.2.0 for @code IDE with the latest stable #DuckDB v0.8.1 support:

📰 https://github.com/RandomFractals/duckdb-sql-tools/discussions/10

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

#DuckDBTools 🧙‍♂️

Our #DuckDB #SQLTools recently crossed 3,600 installs. Try #DuckDBSQLTools 🛠️ Preview extension from #VSCode marketplace. It's free!

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

Our new #DuckDBTools documentation page now covers free #DuckDBSQLTools Preview extension and premium #DuckDBProTools version in depth.

📰 https://randomfractals.github.io/pro-data-tools/duckdb-tools

New DuckDB Tools documentation has many demos of the advanced DuckDB Pro Tools features and usage scenarios.

#DuckDB #ProDataTools 🧙‍♂️

Checked on #DuckDBSQLTools for #VSCode IDE stats after 5 months in VS Code Marketplace.

Almost 600 #DuckDB #SQLTools users upgraded to our latest v1.1.0.

There is a steady trickle of about 500 installs/month per our custom & VS Marketplace dashboard stats read ...

#DataTools 🧙‍♂️ ...

Between the free #DuckDBSQLTools & #DuckDBProTools, our #DuckDB #SQLTools are the only #DuckDBTools we know that support the most recent DuckDB versions & releases:

v0.7.1 ⤑ https://twitter.com/TarasNovak/status/1673314356896071680

v0.8.1 ⤑ https://twitter.com/TarasNovak/status/1673703402738704387

#VSCode #DataTools 🧙‍♂️ ...

🥳 Happy to announce #DuckDBSQLTools Preview v1.1.0 release with #DuckDB v0.7.1 support and new #VSCode #SQLTools & #ProDataTools sections in docs.

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

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

#DataTools 🧙‍♂️ ...

📢 #DuckDB users: we'll add DuckDB v0.7.1 support to the free public #DuckDBSQLTools v1.1.0.

You can signup for #DuckDBProTools on GitHub to use our SQL #ProDataTools in #VSCode IDE with the latest DuckDB v0.8 features and files.

New DuckDB connection error message display with supported DuckDB versions info 🧙‍♂️ ...

Talk about #DataTools 🪄 & #DuckDB in @code FTW: #MalloyData has been in dev w/fully staffed dev team since January 2022 & we put together our free trial #DuckDBSqlTools in a month in January 2023. One in VS marketplace for over a year & a half, the other only 4 months. 💎💎💎

Our #DuckDBSqlTools Preview @code crossed 2,000 installs after 4 months in #VSCode marketplace.

Should we add #DuckDB v0.7.1 support to that Preview version & release new version of our #DuckDBProTools with DuckDB v0.8.1 support? 🤔

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

#DataTools 🧙‍♂️...

This is kinda exciting ... We just crossed 1,800+ of our #DuckDBSqlTools in #VSCode installs. We'll update that ext. to support the latest "stable" #DuckDB v0.7.1 storage format once we hit 2k installs there. Cheers!
#DataTools 💎💎💎...

#DuckDBSqlTools vs #DuckDBProTools features side by side to help you decide if supporting #ProDataTools on github is worth the 2 ☕️ for you to try what Pros use in #VSCode exploring #DuckDB ...

Our #DuckDBSqlTools at 1699 installs now? Guessing some devs & data scientists using #VSCode must be using them ... ⤑ https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools
cc @duckdb 😎

DuckDB has many metadata functions: https://duckdb.org/docs/sql/duckdb_table_functions.

While our free public version of #DuckDBSqlTools for VSCode only list main database tables and views, the next version of #DuckDBPro Tools will include all the extra #DuckDB objects and schemas in Connections/DB tree view. #DataTools ...

We see a steady stream of #DuckDBSqlTools installs & crossed 1K after two months in #VSCode marketplace. What was the spike on March 27th? @DataCouncilAI was hosting their #DataCouncil23 conference & devs were installing our #DuckDB #SQLTools to try that #DataTool ext. in IDE. 😎

Planning to update #DuckDBSqlTools to use v0.7.1 storage format. While at it, would #DuckDB users like to have new DuckDB JSON extension installed & loaded automatically, similar to how we've done it for remote data with HTTPFS?

DuckDB Sql Tools HTTPFS ⤑ https://github.com/RandomFractals/duckdb-sql-tools/tree/main#duckdb-httpfs

DuckDB JSON ⤑ https://duckdb.org/2023/03/03/json.html

Query public #GBIF dataset hosted on AWS with #DuckDBSqlTools:

1. Install #DuckDB #SQLTools

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

2. Create :memory: DB instance

🧐 ⤑ https://github.com/RandomFractals/duckdb-sql-tools#duckdb-httpfs

3. Run occurrence parquet data chunk query below 👇

GBIF info ⤑ https://github.com/gbif/occurrence/blob/master/aws-public-data.md

#DataTools 🔬 ...

Quick #DuckDBSqlTools ext. stats update after a month in VSCode marketplace below. I expected more hands-on DB devs, data analysts & data scientists would give it a go. 15 installs/day avg is our new daily avg ext. installs low! 😎

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

#VSCode #DuckDB #SQLTools ...