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

Going back to our new #DataNotebook 📓 #ProDataTools 🛠️ development, and updating our generic #DataTableRenderers 🈸 for #VSCode Notebooks 📚 this week.

File your new feature requests and enhancements in our VS Code #DataTable ⊞ repo for now:

🗃️ https://github.com/RandomFractals/vscode-data-table

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

One of the main reasons to try our #DuckDBPro 🛠️ in @code 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 apps for your next EDA #dataProject ...

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

#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've enabled GitHub discussions for our public #DataTools & new #ProDataTools 🛠️ users to ask questions, request new features, and share ideas on how to improve them for the data scientists and devs using #VSCode, #VSCodium and #AzureDataStudio.

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

Our #ProDataTools 🛠️ 🧙‍♂️ docs repo for all the brave #DataTools in #VSCode & #AzureDataStudio explorers out there 🤗

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

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/

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

Gonna roll up our sleeves and add new remote url and local data file #DuckDB connection mapping magic and data loading to the #DuckDBPro Tools this month.

#ProDataTools 🛠️ 🧙‍♂️ ...

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

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

Our updated #RandomFractals dev profile on GitHub with new #ProDataTools 🧙‍♂️ info:

https://github.com/RandomFractals

Updated #MarkdownSQLPro Tools info in our public #ProDataTools docs repo now:

https://github.com/RandomFractals/pro-data-tools#markdown-sql-pro-tools

We'll add demos of how to use new #SQLBookmarks and other features from our upcoming Markdown SQL v1.2.0 release with Quarto, R and Observable docs after lunch.

We created new combined changelog to capture all the #ProDataTools 🛠️ VS Code extensions and versions with detailed features info released to our Pro sponsors on GitHub this year.

📜 https://github.com/RandomFractals/pro-data-tools/blob/main/CHANGELOG.md

You can get access to all of our Pro Data Tools today for a low low price of only $0.66. That's less than the cost of a ☕️ for some great new #DataTools for @code.

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

We'll wrap up our latest #MarkdownSQLPro Tools v1.2.0 docs today and will release that update shortly.

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

You can find more info in our new #ProDataTools docs repo:

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

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 $4 today:

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

Using our soon to be released #MarkdownSQLPro Tools 🛠️ v1.2.0 in .Rmd docs:

1. Install #MarkdownSQLProTools:

🧐 https://github.com/RandomFractals/pro-data-tools#markdown-sql-pro-tools

2. Clone sql-in-rmd repository:

➤ https://github.com/sciencificity/sql-in-rmd

3. Open sql-in-rmd project and create new SQLite database connection.

4. Use Extract All code lens to extract all SQL code blocks.

5. Use Execute All code lens to run extracted SQL code.

6. Use Execute code lenses to execute individual SQL code blocks and view results.

#MarkdownSQL #ProDataTools 🧙‍♂️