Gonna try to wrap up and release #DataNotebookPro 📓 @code / #SQLTools extension this month for our #ProDataTools 🛠️ sponsors on GitHub ...

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

#DataNotebooks 📚 / #DataTools 🧙‍♂️ ...

I really enjoyed this week's awesome #vscode livestream with Pamela Fox, showing connecting to #postgresql database by various ways in VSCode, and #python.

Covers #sqltools, #sqlalchemy, running in a dev container with docker compose and connecting to local and azure DBs, environment management... so many things crammed in an hour!

Also shows of GitHub Copilot a lot, but you don't need it to follow along (I'm going to try it using GitLab Duo).

Probably the most complete #DuckDB #SQLTools extension created for devs & data scientists using #VSCode that includes all the DuckDB tree view objects, including main DB instance, system and temp database views with the corresponding main, information schema & pg_catalog schemas display, settings, extensions, data types, functions, and keywords display you will not find in #DBeaver or @motherduck or any other related DuckDB Tool/driver out there. 🤗

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

#ProDataTools 🧙‍♂️ ...

Our new #MarkdownSQL #ProDataTools 🛠️ now support SQL code fences in #Quarto docs and add #SQLCodeLenses 🧐 and #SQLBookmarks 📑 to .qmd markdown documents in #VSCode IDE.

Quick demo of setting up local HR #SQLite database with #SQLTools VS Code extension, rendering Quarto markdown document with Quarto VS Code extension, and using our new #MarkdownSQL Pro Tools to Execute SQL queries form standard .md and .qmd markdown documents code:

https://github.com/RandomFractals/pro-data-tools#interactive-sql-in-quarto-docs

We took the latest #AzureDataStudio for a spin today and can confirm that all of our old custom #VSCode #dataViz extensions work in that IDE, including new #DuckDB #SQLTools, #PRQLCodeLens, new #MarkdownSQLTools, and soon to be released #DataNotebookProTools.

We'll post some walkthroughs on how to install and use some of our new #ProDataTools in Azure Data Studio IDE soon.

Let us know if any of these #DataTools would be of interest to your #DataTeams and your users.

🛠️ https://randomfractals.github.io/pro-data-tools/

There are over 538K SQL code blocks in docs on GitHub:

🔎 https://github.com/search?q=%2F%60%60%60sql%5B%5Cs%5CS%5D*%3F%60%60%60%2F+language%3AMarkdown&type=code

We believe SQL code in docs should be runnable.

We created #SQLCodeLenses with new #SQLBookmarks 📑 in #MarkdownSQLPro Tools 🛠️ for VS Code IDE.

Get #SQLTools drivers to connect to data sources and run SQL queries:

📥 https://marketplace.visualstudio.com/search?term=tag%3Asqltools-driver&target=VSCode&category=All%20categories&sortBy=UpdatedDate

Our Markdown SQL Pro Tools add new SQL code lenses to enable direct SQL code interactions.

Subscribe to get notified when they will be released:

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

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!

The #MarkdownSQLPro Tools 🛠️ v1.2.0 we will be releasing tomorrow add Execute SQL code lenses to SQL code blocks in Quarto markdown docs in VS Code IDE.

Quick demo of setting up local HR #SQLite database with #SQLTools VS Code extension, rendering Quarto markdown document with @quarto_pub extension, and using our new #MarkdownSQL Pro Tools 🛠️ to Execute SQL queries from standard .md and .qmd markdown documents code:

#Quarto #Markdown #SQL #ProDataTools 🧙‍♂️

Good to see our free and public #DuckDB #SQLTools Preview #VSCode extension cross 3K installs. We do get about 600 new installs every month now and should hit 6K by the end of 2023.

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

#DataTools 🛠️ ...

GitHub - whoiskatrin/sql-translator: SQL Translator is a tool for converting natural language queries into SQL code using artificial intelligence. This project is 100% free and open source.

https://github.com/whoiskatrin/sql-translator

#sql #sqltools #translator

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

With #MarkdownSQLProTools v1.1.0 we plan to release to our sponsors on GitHub this week, you'll be able to run SQL code from code blocks in markdown documents and plain SQL documents & use different #SQLTools drivers, #DuckDBPro in this demo ... #ProDataTools 🧙‍♂️ ...

🧐 https://randomfractals.github.io/pro-data-tools/#markdown-sql-pro-tools

New Copy #SQL to clipboard Code Lens feature we'll ship in our #MarkdowSQLProTools v1.1.0 update next week for the #SQLTools @code users sponsoring our Pro data tools work on GitHub ...

🧐 ⤑ https://randomfractals.github.io/pro-data-tools/#markdown-sql-pro-tools

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

🥳 #PRQLProTools v1.2 & #PRQLCodeLens now use #PRQL language compiler v0.8 to generate & Run SQL queries for #DuckDB v0.8 & other #SQLTools DB drivers in #VSCode IDE.

See updated docs & become a Pro sponsor on github to access the latest #ProDataTools 🛠️ 🧙‍♂️ ...

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

Demo of our new #MarkdownSQLProTools extension with custom Select SQL & Execute SQL #VSCode lenses added to the #SQL code blocks in #markdown documents, showing SQL query results in #SQLTools + extended #DuckDB connection tree view display at the end using our #DuckDBProTools.

#DataTools 🧙‍♂️ ...

🥳 Behold! Our new #MarkdownSQLProTools extension w/Select SQL code & Execute All SQL statements #VSCode lenses, integrated with the popular #SQLTools extension & database drivers, #DuckDBProTools in this example 😎

#Markdown #SQL #DuckDB #ProDataTools #DataTools 🧙‍♂️ ... 💎💎💎... 🚀🚀🚀 !!!