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.

#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 🧙‍♂️ ...

📢 #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 @code 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
@code exploring #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 JSON ext. 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 my new daily installs low! 😎

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

#VSCode #DuckDB #SQLTools ...

Creating TPC-DS #DuckDB is super easy w/our #DuckDBSqlTools:

1. Install DuckDB Sql Tools VSCode extension:

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

2. Create new tpc-ds.duckdb #SQLTools config:

🧐 https://github.com/RandomFractals/duckdb-sql-tools#in-memory-duckdb

3. Get and Run TPC-DS schema SQL:

▶️ https://github.com/carlineng/malloy-tpcds/blob/main/tpcds_schema.sql

👇

There is a private #DuckDB Tools monorepo that houses the current #DuckDBSqlTools alpha v. extension source code, and will contain new #DuckDBPro Tools extension package with more advanced features for our Pro sponsors on github.

You can sign up here to get notified when new DuckDB Pro Tools private beta version will be released: 💖💵 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884

#DuckDB #VSCode #ProTools ...

I see this share is trending here. We released the first alpha version of #DuckDBSqlTools last month:

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

We'll attach .vsix of the upcoming #PRQL #VSCode extension update to the next release tag in prql-vscode repo so devs using #VSCodium can use new Save/Copy #SQL from PRQL #UX features we've been working on with PRQL dev team. Sneak peek with #DuckDBSqlTools integration 😉

Meanwhile, you should totally ⭐️& 👀 PRQL Code extension GitHub repo: https://lnkd.in/g_nXMTTB

#DataTools ...

Implemented #PRQL to #SQL file generation today to streamline PRQL -> SQL -> query results workflow in our #DuckDBSqlTools. This change is added to the PRQL #VSCode extension for others to use as well.

See this PR: https://github.com/PRQL/prql-vscode/pull/49

#DuckDB #DataTools 🧙‍♂️ ...

And the #1 extension trending in Visual Studio Code marketplace this week is the #DuckDBSqlTools we published last Friday 👇

https://marketplace.visualstudio.com/vscode

Install it to try #DuckDB in #VSCode without Jupyter notebooks or using CLI:

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

#DataTools 🧙‍♂️ ...

Created new data/scripts repo to explore some of the large #ChicagoTransportation datasets with our #DuckDBSqlTools extension loading and querying those datasets.

Chicago Traffic Crash reports viewing with data info & instructions to run:

▶️ https://github.com/RandomFractals/chicago-transport#view-crash-reports

#VSCode #DuckDB #SQLTools / #DataTools 🔬 ...