Stumbled on this Marketplace Preview VS Code extension. Great way to preview new #VSCode extension docs, tags, and check resource links.

Below is our #MarkdownSQLPro 🛠️ Marketplace Preview. More info at:

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

#CodeTools

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

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.

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

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

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

We will add Bookmarks 📑 integration to the next release of our #MarkdownSQLPro Tools 🛠️ for VS Code IDE.

Bookmarks extension is very popular with devs and data scientists using VS Code and has close to 3 million installations.

📥 https://marketplace.visualstudio.com/items?itemName=alefragnani.Bookmarks

Bookmark All SQL Code lens will provide quick jump points to the SQL code blocks in markdown docs via the Bookmarks Explorer view.

Example of Bookmarked SQL in the open Observable JS and markdown documents:

#MarkdownSQL #ProDataTools 🛠️ 🧙‍♂️ ...