#prql β Public Fediverse posts
Live and recent posts from across the Fediverse tagged #prql, aggregated by home.social.
-
π 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. π
https://prql-lang.org/ #PRQL #DataEngineers #ModernLanguage #HackerNews #ngated -
π 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. π
https://prql-lang.org/ #PRQL #DataEngineers #ModernLanguage #HackerNews #ngated -
π 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. π
https://prql-lang.org/ #PRQL #DataEngineers #ModernLanguage #HackerNews #ngated -
π 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. π
https://prql-lang.org/ #PRQL #DataEngineers #ModernLanguage #HackerNews #ngated -
Interesting lightning talk:
Community extension to allow efficient graph querying in #duckdbhttps://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.
-
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 π§ββοΈ
-
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
-
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: https://twitter.com/TarasNovak/status/1633979409450377216
-
Got the rough version of #PRQL cell run working in our new custom #DataNotebook π extension for #VSCode IDE. Will wire results to our #DataTableRenderers next. Sweet, eh? #DataProTools ...
See GIF: https://www.linkedin.com/feed/update/urn:li:activity:7039638295571554306/
-
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 π¬ ...
-
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 π¬ ...
-
After eval of #MalloyData tools, I am going back to #PRQL. Their repo, tools, docs & api look more mature to me, and should enable adding SQL queries to my data viewers next year.
PRQL playground: https://prql-lang.org/playground/
VSCode extension you can try: https://marketplace.visualstudio.com/items?itemName=prql-lang.prql-vscode
#dataTools π οΈ ...
Explore more at: https://github.com/prql/prql#explore
-
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 π§ββοΈ ...
-
π₯³ #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 π οΈ π§ββοΈ ...
-
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
-
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
-
#HappyPiDay to all the #PRQL & #DuckDB fans out there!
-
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: https://twitter.com/TarasNovak/status/1635632197422948352
-
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 ... https://vscode-sqltools.mteixeira.dev/en/drivers/
-
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: https://prql-lang.org/book/language-features/target.html#supported-dialects
GIF: https://twitter.com/TarasNovak/status/1631999447147204608
#DataTools ...
-
π₯³ Announcing our 1st #PRQLProTools release with #PRQLCodeLens to connect #PRQL directly to #SQLTools in #VSCode.
Become a Pro sponsor on github to get invited to this private #ProTools extension package repository:
π β€ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
π₯ β€ https://github.com/RandomFractals/prql-pro-tools -
Who'd like to become our 8β£th sponsor on github to support our continued dev efforts of making simple #PRQL, #DuckDB & other #DataTools π οΈ & #CodeNotebooks π for the masses?
π οΈ β€ https://twitter.com/search?f=live&q=(%23DataTools)%20(from%3ATarasNovak)&src=typed_query
π β€ https://twitter.com/search?q=(%23CodeNotebooks%20OR%20%23JSNotebooks%20OR%20%23DataTableRenderers)%20(from%3ATarasNovak)&src=typed_query&f=liveπ β€ π±? https://github.com/sponsors/RandomFractals
-
Another really cool Pro feature we'll ship in the upcoming #DuckDBProTools private beta for PRQL fans is #PRQLNotebooks π.
You'll be able to open any #PRQL file as a #DataNotebook π & Run PRQL query from a cell on an active #DuckDB connection in #VSCode.
Sign up to get invited to our private beta and use this feature soon! π https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
#Pro #DataTools ...
-
Had to do a wee bit of refactoring to move new #PRQL βΆοΈ Run Query code lens out of DuckDB Tools repo to make it standalone & work with/all the available #SQLTools drivers in #VSCode π
We'll call it #PRQLCodeLens π§ for now. Will be part of our new #PRQLPro Tools extension pack available only to our Pro sponsors on GitHub.
Sign up to get invited to our private PRQL Pro Tools repo and try this new PRQL/SqlTools combo next week: https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
#ProTools ...
-
π§ββοΈ Behold! βΆοΈ Run Query straight from a #PRQL document integrated with #DuckDBPro Tools we'll make available to Pro sponsors in our new #ProTools soon.
π Sign up to get on the private beta waiting list!
π https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
#VSCode #DuckDB #PRQLPro #SQLTools πππ π₯π₯π₯
GIF: https://www.linkedin.com/feed/update/urn:li:activity:7034276110808858626/
-
#RandomFractalsInc is on a code killing spree on GitHub this year. π
Started 2023 strong with some new DuckDB & PRQL Tools for data analysts & data scientists using VSCode extensions compatible IDEs.
More to come soon!
βοΈ β€ https://github.com/RandomFractals
Building #VSCode #SQL / #PRQL / #DuckDB #DataTools π¬
πππ π₯π₯π₯ ...
-
This #PRQL βΆ Run Query code lens is super generic & will work with any #SQLTools driver, PRQL supported SQL dialect & target DBMS, not just DuckDB.
We'll create new #PRQLProTools repo for this PRQL Run Query Lens & new #PRQLNotebook π extension, so you can use them with your fave DBs supported by SQLTools in VSCode.
-
Quick update on #DuckDBPro Tools private beta we plan to release next month:
βοΈ New Sql Tools driver will be called DuckDBPro
βοΈ Pro DB icons will have βͺοΈ in the βͺοΈ & π‘ DB state circles to make them look more like a π¦ head π
βοΈ Pro Tools version will support DuckDB v0.7 and DB write
βοΈ DuckDBPro Tools will work with our new Run Query #PRQLCodeLens
βοΈ Private beta repository will have new demo employees.duckdb, and sample SQL and PRQL queries to run π -
We'll attach .vsix of the upcoming #PRQL #VSCode extension update to the next release tag in prql-vscode repo so devs using #VSCodium can use new Save/Copy #SQL from PRQL #UX features we've been working on with PRQL dev team. Sneak peek with #DuckDBSqlTools integration π
Meanwhile, you should totally βοΈ& π PRQL Code extension GitHub repo: https://lnkd.in/g_nXMTTB
#DataTools ...
-
Implemented #PRQL to #SQL file generation today to streamline PRQL -> SQL -> query results workflow in our #DuckDBSqlTools. This change is added to the PRQL #VSCode extension for others to use as well.
See this PR: https://github.com/PRQL/prql-vscode/pull/49
#DuckDB #DataTools π§ββοΈ ...
-
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 π§ββοΈ π€―
-
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 π§ββοΈ π€―
-
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 π§ββοΈ π€―
-
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 π§ββοΈ π€―
-
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 π¬ πππ ...
-
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 π¬ πππ ...
-
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 π¬ πππ ...
-
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 π¬ πππ ...
-
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
-
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