home.social

#prql — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #prql, aggregated by home.social.

  1. 🚀 Ah, the brave nerds have done it again—PRQL, pronounced #PREQUEL, because who doesn't love a good Jedi reference when discussing #SQL replacements? 🧘‍♂️ Unveiled as a "modern language" 💻, it's just SQL with a fancy hat, trying to impress data engineers by being as concise as their attention spans. 🙄
    prql-lang.org/ #PRQL #DataEngineers #ModernLanguage #HackerNews #ngated

  2. 🚀 Ah, the brave nerds have done it again—PRQL, pronounced #PREQUEL, because who doesn't love a good Jedi reference when discussing #SQL replacements? 🧘‍♂️ Unveiled as a "modern language" 💻, it's just SQL with a fancy hat, trying to impress data engineers by being as concise as their attention spans. 🙄
    prql-lang.org/ #PRQL #DataEngineers #ModernLanguage #HackerNews #ngated

  3. 🚀 Ah, the brave nerds have done it again—PRQL, pronounced #PREQUEL, because who doesn't love a good Jedi reference when discussing #SQL replacements? 🧘‍♂️ Unveiled as a "modern language" 💻, it's just SQL with a fancy hat, trying to impress data engineers by being as concise as their attention spans. 🙄
    prql-lang.org/ #PRQL #DataEngineers #ModernLanguage #HackerNews #ngated

  4. 🚀 Ah, the brave nerds have done it again—PRQL, pronounced #PREQUEL, because who doesn't love a good Jedi reference when discussing #SQL replacements? 🧘‍♂️ Unveiled as a "modern language" 💻, it's just SQL with a fancy hat, trying to impress data engineers by being as concise as their attention spans. 🙄
    prql-lang.org/ #PRQL #DataEngineers #ModernLanguage #HackerNews #ngated

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

    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

  6. I been slowly utilizing instead of raw . 😅

    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 in . 😎

    prql-lang.org/book/

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

    📰 github.com/RandomFractals/pro-

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

    #ProDataTools 🛠️ 🧙‍♂️ ...

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

    💖 ⤑ github.com/sponsors/RandomFrac

  9. Playing with a reverse proxy and the client/server protocol to automatically convert queries to SQL (in ): jpmoresmau.blogspot.com/2023/0

  10. 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 📚.

    📥 marketplace.visualstudio.com/i

  11. 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 📚.

    📥 marketplace.visualstudio.com/i

  12. 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 📚.

    📥 marketplace.visualstudio.com/i

  13. 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 📚.

    📥 marketplace.visualstudio.com/i

  14. 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 📚.

    📥 marketplace.visualstudio.com/i

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

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

    - over
    - over
    - over
    - Berkeley's language over MIT's
    - over
    - Geometric product over Cross product of vectors for high-school/college &

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

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

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

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

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

  22. 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 💎💎💎 ...

    💵 ⤑ github.com/sponsors/RandomFrac

  23. 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 🔬 ...

  24. 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!

    📥 marketplace.visualstudio.com/i

  25. 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:

    💖 ⤑ github.com/sponsors/RandomFrac

  26. 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:

    💖 ⤑ github.com/sponsors/RandomFrac

  27. 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:

    💖 ⤑ github.com/sponsors/RandomFrac

  28. 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:

    💖 ⤑ github.com/sponsors/RandomFrac

  29. 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:

    💖 ⤑ github.com/sponsors/RandomFrac

  30. Where all the 🦆s at you ask?

    Here is a fun #PRQL query you can run on that GBIF observations dataset 1st data chunk (~100MB) hosted by AWS with our #PRQLCodeLens #PRQLPro tool in VSCode 😎

    See demo GIF on twitter: twitter.com/TarasNovak/status/

    #DuckDB #SQLTools ...

  31. Where all the 🦆s at you ask?

    Here is a fun #PRQL query you can run on that GBIF observations dataset 1st data chunk (~100MB) hosted by AWS with our #PRQLCodeLens #PRQLPro tool in VSCode 😎

    See demo GIF on twitter: twitter.com/TarasNovak/status/

    #DuckDB #SQLTools ...

  32. Where all the 🦆s at you ask?

    Here is a fun #PRQL query you can run on that GBIF observations dataset 1st data chunk (~100MB) hosted by AWS with our #PRQLCodeLens #PRQLPro tool in VSCode 😎

    See demo GIF on twitter: twitter.com/TarasNovak/status/

    #DuckDB #SQLTools ...

  33. Where all the 🦆s at you ask?

    Here is a fun #PRQL query you can run on that GBIF observations dataset 1st data chunk (~100MB) hosted by AWS with our #PRQLCodeLens #PRQLPro tool in VSCode 😎

    See demo GIF on twitter: twitter.com/TarasNovak/status/

    #DuckDB #SQLTools ...

  34. Where all the 🦆s at you ask?

    Here is a fun #PRQL query you can run on that GBIF observations dataset 1st data chunk (~100MB) hosted by AWS with our #PRQLCodeLens #PRQLPro tool in VSCode 😎

    See demo GIF on twitter: twitter.com/TarasNovak/status/

    #DuckDB #SQLTools ...

  35. Also, our private beta of #DataProTools 🛠️ #QueryDataNotebook 📓 extension with SQL & #PRQL query run cells will support SQLite, PostgreSQL, MSSQL, and MySQL. We'll see if we can use #SQLTools DB drivers & API for the broader Data Sources support later ... vscode-sqltools.mteixeira.dev/

  36. Quick demo of Run #PRQL query using our new custom #VSCode #DataNotebook 📔 extension, and results rendered by the Data Table renderer from our #DataTableRenderers 🈸 ... #QueryDataNotebook 📓 ...

    See demo GIF on twitter: twitter.com/TarasNovak/status/

  37. Took me a few hours to whip my new #DataNotebook 📓 extension base code into shape today. Got #PRQL loaded into vscode notebook view using Open With option. Will wire SQL gen., query & results/output data rendering with our #DataTableRenderers this week for sure! #DataTools 🔬 ...

  38. See supported langs in our new #DataNotebooks 📚 for #VSCode ext. 😎

    We'll let you query your data stores in raw #SQL if you prefer that, or using the alternative #PRQL & #MalloyData -> SQL pipelines ...

    & Yes! Results will be displayed w/our #DataTableRenderers 🈸! #ProDataTools 🔬 ...

  39. Our #PRQLCodeLens users can run #PRQL queries directly on active #DuckDB SQLTools connections, without installing any extra unsigned DuckDB extensions, resorting to duckdb CLI or using Python duckdb tools.

    In fact, they can do this with any of the supported PRQL target DB engines: prql-lang.org/book/language-fe

    GIF: twitter.com/TarasNovak/status/

    #DataTools ...