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 released new version of #MarkdownSQL Pro Tools. New features:

✅ SQL code block highlights & selections

✅ Detection of %%sql magic code blocks & %sql magic code lines

✅ New #SQLBookmarks 📑

✅ New Extract All SQL code lens

✅ MyST #JupyterBook markdown documents support

✅ SQL code lenses for #Quarto, #Rmarkdown, and #ObservableJS docs

Docs and new demos at:

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

These tools are free today, for one day only. Sign up to try them out!

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

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

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

The next release of #MarkdownSQL Pro Tools for #VSCode IDE will highlight SQL code blocks in the supported markdown documents (.md, .qmd, .omd, .rmd) and provide new top level Select All SQL code blocks code lens to make it easier to spot them in markdown docs.

#ProDataTools 🛠️ ...

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

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