Interesting lightning talk:
Community extension to allow efficient graph querying in #duckdb

https://www.youtube.com/watch?v=QDdTbhSR2Vo

Also, an aside: I think it's pretty incredible duckdb extensions can introduce syntax like this. We've already seen this with things like the #prql extension. Rare to see extensions introducing custom DSLs in other ecosystems (that I can think of) without the REPL/tooling getting confused.

#database

Pipelined Relational Query Language, pronounced “Prequel”

No, that's clearly pronounced "perkele" 🇫🇮

#prql #perkele #finnish #suomi

I been slowly utilizing #prql instead of raw #sql. 😅

So far, it makes sense when doing analytical jobs. But for language support, it is far more natural to use DSL features made for languages like #ecto in #elixir. 😎

https://prql-lang.org/book/

Released #PRQLCodeLens v1.3.0 for #VSCode IDE with #PRQL v0.9.5 grammar support and updated PRQL and #DuckDB SQL query examples.

🧐 https://github.com/RandomFractals/prql-pro-tools

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

#PRQLTools / #PRQLProTools / #PRODataTools 🧙‍♂️

Published our #PRQLTools #VSCode extension documentation for devs & data scientists interested in using #PRQL, #SQLTools and various DB drivers to check out:

📰 https://github.com/RandomFractals/pro-data-tools/blob/main/prql-tools.md

Quick demo of using ▶️ Run Query #PRQLCodeLens with our #DuckDB SQL Tools:

#ProDataTools 🛠️ 🧙‍♂️ ...

We'll be updating our #PRQLProTools / #PRQLCodeLens & #DuckDB #PRQL query examples for devs & data scientists using #SQLTools in #VSCode IDE this week. Stay tuned! ...

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

🧐 https://twitter.com/search?q=%23PRQLProTools&src=typed_query&f=live

#SQL / #PRQL / #ProDataTools 🧙‍♂️ ...

Ох какой прекрасный срач в комментах: https://www.opennet.ru/opennews/art.shtml?num=59499

Старперы и неосиляторы-лошки взъелись на язык #PRQL, который должен наконец прийти на замену замшелому #SQL или хотя бы стать альтернативой.

Думаю может написать статейку на хабр, где привести примеры когда SQL реально неудобен и нечитаем, а PRQL прям вывозит.

🌕 GitHub - PRQL/prql: PRQL是一種現代化的數據轉換語言 - 一種簡單、強大、流水線式的SQL替代方案
➤ PRQL的特點和發展狀況
✤ https://github.com/PRQL/prql
PRQL是一種現代化的數據轉換語言，它是一種簡單、強大、流水線式的SQL替代方案。它支持變量和函數等抽象概念，可以與任何使用SQL的數據庫一起使用。PRQL正在積極開發中，但仍有一些小bug和缺失的功能。它目前主要用於非技術團隊進行相對簡單的查詢。
+ 這個PRQL語言聽起來很有潛力，我想試試看。
+ 看起來PRQL還有一些問題需要解決，但它的功能和特點很有吸引力。
#GitHub #PRQL #數據轉換語言

🥳 #PRQLProTools v1.2 & #PRQLCodeLens now use #PRQL language compiler v0.8 to generate & Run SQL queries for #DuckDB v0.8 & other #SQLTools DB drivers in #VSCode IDE.

See updated docs & become a Pro sponsor on github to access the latest #ProDataTools 🛠️ 🧙‍♂️ ...

💖 ⤑ https://github.com/sponsors/RandomFractals

Playing with a reverse proxy and the #postgresql client/server protocol to automatically convert #prql queries to SQL (in #rustlang): https://jpmoresmau.blogspot.com/2023/06/prql-to-sql-transformation-on-fly.html

Actually, it's more fun to look at such #PRQL SQL output and query results using #DataSummary 🈷️ renderer from our popular #DataTableRenderers 🈸 extension for VSCode Notebooks 📚.

📥 https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.vscode-data-table

Not only will our new #DataNotebook 📓 #ProTools extension for Code let you load #PRQL docs with multiple queries, we'll show you the generated #SQL in the #PRQLNotebook cell output, and you can copy/paste that SQL into other DB tools. We'll add show SQL setting to make it optional. #ProDataTools 🧙‍♂️ ...

You can try our #DuckDBPro and #PRQLCodeLens Pro Tools free today. It's a one day deal! Don't miss out if you want to try the latest version of #DuckDB, #PRQL and #SQLTools in Code!
👉 https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884

A few obscure things that I wish end up winning over current dominant alternatives:

- #SvelteJS over #ReactJS
- #Podman over #Docker
- #PRQL over #SQL
- Berkeley's #Snap language over MIT's #Scratch
- #ActivityPub over #Twitter
- Geometric product over Cross product of vectors for high-school/college #math & #physics

The official PRQL Code extension doesn't support #PRQL documents with multiple queries defined, but you'll be able to use our new #DataNotebooks 📚 extension to load such PRQL docs in #VSCode 📓 & run those queries inline or with #PRQLCodeLens & #DuckDBPro #SqlTools 🧙‍♂️ 🤯

willing data souls and explorers can try our awesome #PRQLCodeLens & #DuckDBProTools for $1.33 today. That #ProTools sub goes back to $10 tomorrow, as github prorates their monthly tiers and dues collected ... #PRQL #DuckDB #SQLTools 💎💎💎 ...

💵 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884

Do our #DuckDB #SqlTools and #PRQL Code Lens from #PRQLPro Tools work in #CodeSpaces? Yes, they do! Try them!

DuckDB Sql Tools ⥱ https://github.com/RandomFractals/duckdb-sql-tools

📥 https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools

PRQL Code Lens 🧐 info ⥱ https://twitter.com/TarasNovak/status/1635981882125963265

#VSCode #DataTools 🔬 🚀🚀🚀 ...

Extended list of #DuckDBProTools features we'll ship in our first private beta version of that VSCode DuckDB tools extension. Documenting the rest, new #DuckDB JSON extension features, and our demo DuckDB instances with #PRQL & SQL query examples. #ProDataTools 🔬 ...

Good to see PRQL language extension crossing 1K downloads in Visual Studio Code marketplace.

We had fun helping them out in the past month or so to get them there 😎.

Fans of hybrid #SQL #DataTools should totally try #PRQL!

📥 https://marketplace.visualstudio.com/items?itemName=PRQL-lang.prql-vscode

You can now Run #PRQL queries with new loop, func & let vars directly on the open #SQLTools connections using #PRQLCodeLens v1.1.0 extension from our private #PRQLPro Tools collection.

Sign up to get access to the PRQL Code Lens 📦 #DataTools:

💖 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884