#markdownsql — Public Fediverse posts

Our new #MarkdownSQL #ProDataTools 🛠️ now support SQL code fences in #Quarto docs, and add #SQLCodeLenses 🧐 & #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 from standard .sql, .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 #MarkdownSQL Tools, and soon to be released #DataNotebookPro 📚 Tools.

We'll post new walk-throughs on how to install and use some of those new #ProDataTools in Azure Data Studio IDE soon.

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

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

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

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 #MarkdownSQLProTools v1.1.0 update next week for the #VSCode #SQLTools users sponsoring our Pro data tools work on GitHub ...

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

#MarkdownSQL #ProDataTools 🛠️🔬 ...