#duckdbsqltools — Public Fediverse posts

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 ...

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 🔬 ...

Users of #VSCodium IDE can also use our new #DuckDBSqlTools extension.

1⃣ Download duckdb-sql-tools-x.x.x.vsix 📦 from our extension releases on github:

📥 https://github.com/RandomFractals/duckdb-sql-tools/releases

2⃣ Use Install from #VSIX feature to install #DuckDB #SqlTools 📦👇

▶️ https://twitter.com/TarasNovak/status/1620073278743388160

#SQL 📜 #DataTools 🧙‍♂️ 🔬 💎 ...

Quick demo of our new #DuckDBSqlTools vscode extension loading and querying 7,687,725 #ChicagoCrimes recorded in 2001 through the end of November 2022 from a large 1.68 GB CSV data file in seconds ... See demo gif at:

📰 https://github.com/RandomFractals/chicago-crimes#with-duckdb-sql-tools

#DuckDB #SqlTools #VSCode #DataTools 💎💎💎

Almost done with #DuckDBSqlTools documentation. Will release Preview version tomorrow for sure.

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