#duckdbpro — Public Fediverse posts

📣 Published new free and public #DuckDB #SQLTools Preview v1.6.0 for VS Code IDE with DuckDB v0.10.2 support.

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

See our #ProDataTools repo for advanced #DuckDBPro schema, commands, and new features updates:

📰 https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#pro-data-tools

#VSCode #DataTools 🛠️ 🧙‍♂️ ...

📣 Released #DuckDBPro #SQLTools for VS Code IDE with #DuckDB v0.10.2 support.

📰 https://github.com/RandomFractals/pro-data-tools/blob/main/CHANGELOG.md#duckdb-pro-tools-v160---2024-07-12

#VSCode #ProDataTools 🧙‍♂️ ...

📣 Released #DuckDB #SQLTools Preview v1.5.0 for VS Code IDE with DuckDB v0.9.2 BigInt support.

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

Will update this free public DuckDB SQL Tools VS Code extension to support the latest DuckDB v0.10 and v1.0.0 next week.

See our #ProDataTools repo for advanced #DuckDBPro schema, commands, and new features updates:

📰 https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#pro-data-tools

#VSCode #DuckDB #SQLTools 🧙‍♂️ ...

📣 Released #DuckDBPro Tools for VS Code IDE with full DuckDB v0.9.2 and BigInt support.

📰 https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#duckdb-pro-tools

Will update DuckDB Pro Tools to support DuckDB v0.10.3 and the latest v1.0.0 in the next few days. Stay tuned!

#VSCode #DuckDB #ProDataTools #SQLTools 🧙‍♂️ ...

Will be updating #DuckDBPro SQL Tools for VS Code IDE to support DuckDB v0.9.2, v0.10.3 and the latest stable DuckDB v1.0.0 this week.

Let us know what other DuckDB Pro features you'd like to see in our #ProDataTools updates next.

💬 https://github.com/RandomFractals/pro-data-tools/discussions/10

📰 https://github.com/RandomFractals/pro-data-tools?tab=readme-ov-file#duckdb-pro-tools

#VSCode #DuckDB #SQLTools 🛠️ 🧙 ...

Started working on new #PGSqlTools plugin this month.

Similar to our #DuckDBPro and #SQLitePro #DataTools 🛠️ this extension will display all #Postgres DB objects in Connections Explorer, provide information schema, system catalogs and other standard PG view shortcut commands for Postgres, Cockroach and many other #pgwire compatible databases.

Aiming to support most of the popular PostgreSQL flavor databases from this list: https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases

#VSCode #PostgreSQL #SQLTools #ProDataTools 🧙

One of the main reasons to try our #DuckDBPro 🛠️ in #VSCode IDE are the 30+ custom #DuckDB view & metadata shortcut commands you can invoke from the standard VS Code Commands Palette while exploring those embedded DB files in your #dataApps for your next EDA #dataProject ...

📰 https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#duckdb-view-commands

#ProDataTools 🧙‍♂️ ...

Gonna roll up our sleeves and add new remote Url and local data file #DuckDB connection auto-create magic & data loading to the #DuckDBPro 🛠️ for #VSCode IDE this month.

#ProDataTools 🧙‍♂️ ...

Our combined #ProDataTools 🛠️ changelog for the #DuckDB SQL and #DuckDBPro Tools, #PRQLCodeLens and #MarkdownSQLPro extensions, covering prominent features and enhancements in 15 releases of new #DataTools for VS Code IDE this year:

🧐 https://randomfractals.github.io/pro-data-tools/CHANGELOG

Using #MarkdownSQLPro Tools 🛠️ with new #SQLBookmarks 🔖, #SQLite & our #DuckDBPro #SQLTools in #VSCode IDE on @ploomber's #JupySQL #JupyText / #MyST #JupyterBook 📓 markdown docs 😎

#SQL #DuckDB #Markdown #ProDataTools 🧙‍♂️ ...

All of our #ProDataTools 🛠️ are just $2.66 today with GitHub's prorated sponsorship tier pricing.

💖 https://github.com/sponsors/RandomFractals/sponsorships?tier_id=295482

Sign up today to get #DuckDBPro Tools, #PRQLProTools and our latest #MarkdownSQLProTools to query DuckDB and other data sources with #SQLTools in VS Code IDE like a Pro. More to come soon!

You can sponsor our work on GitHub to get access to the new #MarkdownSQL and other #ProDataTools 🛠️ like #DuckDBPro.

You will get notified when new SQL code lenses for R markdown, Quarto and Observable markdown documents are released. Only $3.33 today:

💖 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?tier_id=295482

The next monthly release of #DuckDBPro Tools 🛠️ will integrate with VS Code File Explorer to load CSV, JSON and parquet data files from local file system, remote workspaces, public end-points, and S3 buckets.

It will streamline creating new #DuckDB instances to load, explore, and query data using #SQLTools in VS Code.

Sign up to get notified when this feature will be released:

💖 + 💸 = 🛠️ ⤑ https://github.com/sponsors/RandomFractals

More info about our #ProDataTools 🛠️ for VS Code IDE:

📰 ⤑ https://github.com/RandomFractals/pro-data-tools

Quick demo of the new Extract All SQL and Execute SQL code lenses in the upcoming #MarkdownSQL Pro Tools v1.2.0 with #JupyterBook markdown support and #JupySQL / #SQLMagics SQL code extraction and execution in action:

This example uses VS Code #SQLTools and #DuckDBPro Tools to execute SQL queries directly from the Jupy SQL Jupyter Book markdown document (https://github.com/ploomber/jupysql/blob/master/doc/quick-start.md).

#VSCode #ProDataTools 🧙‍♂️ ...

📰 Great news for all the #DuckDBPro's & fans of our #DataTools 🛠️ out there:

Today we released #DuckDBProTools v1.3.0 with #DuckDB v0.8.0 support.

See updated docs & examples below & become a #ProTools sponsor on GitHub to access the latest and greatest in #ProDataTools for #VSCode.

💖 ⤑ https://github.com/sponsors/RandomFractals

Took #StarCoder from #BigCodeProject for a spin today. Used 🤗 #VSCode autocomplete extension to generate a bunch of sample employees #DuckDB SQL queries for the next #DuckDBPro Tools update. #DataTools 🔬 ...

https://www.linkedin.com/feed/update/urn:li:activity:7060961253258625024/

A lot of work went into making #DuckDBPro Tools. So, we hope it's a fair game to post some info about it in @duckdb discussions for those interested in better #DuckDB tooling in VSCode IDE. Cheers! #DataTools 🧐

https://github.com/duckdb/duckdb/discussions/7388

Quick View #DuckDB schemata shortcut command demo. More such metadata function and view shortcut commands will be added in the next #DuckDBPro Tools update. #DataTools 🔬 ...

Yup! You can install and load #DuckDB #geoSpatial extension in our #DuckDBPro Tools too. It just needs installed status and description update. See: https://github.com/duckdblabs/duckdb_spatial #GeoDataTools 🗺️ ...

Creating Pro Tools with examples takes time and good book-keeping habits. Snapshot of the #DuckDBPro Tools private beta changelog we released back in March. #DataTools 🧙‍♂️ ...
Our Pro sponsors on github can access it directly: https://github.com/RandomFractals/duckdb-pro-tools/blob/main/CHANGELOG.md

Enhanced SQL IntelliSense in the upcoming #DuckDBPro #SQLTools v1.1.0 with active #DuckDB connection tables and column name hints, and database and schema name displayed in those @code tips as you type SQL. #DataTools 🧙‍♂️ ...

Refined #DuckDB table columns display in #DuckDBPro Tools v1.1.0 we plan to release later this week. Note added primary 🔑/ column type iconography, db type and not null constraint display in the column tree view node detail. #VSCode #SQLTools / #DataTools 🧙‍♂️ ...

Also, for the DuckDB @code fans out there, we just added Indexes display to our #DuckDBPro Tools ... DuckDB Pro Sql Tools FTW coming to @code terminals near you soon! 😎 #SQL / #DataTools 💎💎💎

Quick preview of the upcoming #DuckDBPro Tools v1.1.0 with extended DB objects tree view display showing #DuckDB instance databases, schemas, tables, views, installed and loaded DuckDB extensions, DB types, functions, and keywords. #DataTools 🛠️ #VSCode 🧙‍♂️ ...

Extended DuckDB objects display in #DuckDBPro Tools is shaping up nicely. New DB objects tree view with finer icons and a list of databases, schemas, tables, views and settings with setting data type and current value displayed for #DuckDB config view at a glance. #DataTools 🧙‍♂️...

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

You can try our #DuckDBPro and #PRQLCodeLens Pro Tools free today. It's a one day deal! Don't miss out if you want to try the latest version of #DuckDB, #PRQL and #SQLTools in Code!
👉 https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884

The official PRQL Code extension doesn't support #PRQL documents with multiple queries defined, but you'll be able to use our new #DataNotebooks 📚 extension to load such PRQL docs in #VSCode 📓 & run those queries inline or with #PRQLCodeLens & #DuckDBPro #SqlTools 🧙‍♂️ 🤯

🥳 Happy to announce the first #DuckDBProTools beta release available to our Pro sponsors on github now. 📥 https://github.com/RandomFractals/duckdb-pro-tools/releases/tag/v1.0.3

Sign up to access this #DuckDBPro tools repository, download and install this extension with #DuckDB v0.7 support:

💖 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884

Just having all that #DuckDB demo data to play with in #VSCode is probably worth $4.33 to get access to. idk, we'll see if it is. Besides, you do get slick #PRQLCodeLens ext. with it already. Will release the rest later this week. ✌️

💖 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884

#DuckDBPro 💎💎💎