#markdownsql — Public Fediverse posts on home.social

Taras Novak 🇺🇦 @[email protected] · 2023-08-20 · 12:53 UTC

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

#sqltools #sqlite #vscode #sqlbookmarks #sqlcodelenses #quarto

Taras Novak 🇺🇦 @[email protected] · 2023-08-16 · 12:20 UTC

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/

#datateams #datatools #prodatatools #prqlcodelens #sqltools #duckdb

Taras Novak 🇺🇦 @[email protected] · 2023-08-04 · 18:55 UTC

📢 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

#observablejs #rmarkdown #quarto #jupyterbook #sqlbookmarks #markdownsql

Taras Novak 🇺🇦 @[email protected] · 2023-07-30 · 14:07 UTC

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

#prodatatools #sql #markdown #quarto #markdownsql #sqltools

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 13:29 UTC

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

#duckdbpro #prodatatools #markdownsql

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 13:29 UTC

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

#duckdbpro #prodatatools #markdownsql

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 13:29 UTC

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

#duckdbpro #prodatatools #markdownsql

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 13:29 UTC

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

#markdownsql #prodatatools #duckdbpro

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 13:29 UTC

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

#duckdbpro #prodatatools #markdownsql

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 12:42 UTC

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

#prodatatools #markdownsql #markdownsqlprotools #markdownsqlpro

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 12:42 UTC

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

#prodatatools #markdownsql #markdownsqlprotools #markdownsqlpro

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 12:42 UTC

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

#prodatatools #markdownsql #markdownsqlprotools #markdownsqlpro

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 12:42 UTC

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

#markdownsqlpro #markdownsqlprotools #markdownsql #prodatatools

Taras Novak 🇺🇦 @[email protected] · 2023-07-29 · 12:42 UTC

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

#prodatatools #markdownsql #markdownsqlprotools #markdownsqlpro

Taras Novak 🇺🇦 @[email protected] · 2023-07-27 · 14:23 UTC

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

#prodatatools #markdownsql #markdownsqlpro

Taras Novak 🇺🇦 @[email protected] · 2023-07-17 · 15:11 UTC

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

#prodatatools #vscode #markdownsql

Taras Novak 🇺🇦 @[email protected] · 2023-07-16 · 14:57 UTC