nonsense · @nonsense
10 followers · 17 posts · Server mastodon.ml

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

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

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

#prql #sql

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
166 followers · 260 posts · Server vis.social

🥳 v1.2 & now use language compiler v0.8 to generate & Run SQL queries for v0.8 & other DB drivers in IDE.

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

💖 ⤑ github.com/sponsors/RandomFrac

#prodatatools #vscode #sqltools #duckdb #prql #prqlcodelens #prqlprotools

Last updated 1 year ago

JP Moresmau · @jpm
76 followers · 1225 posts · Server fosstodon.org

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

#postgresql #prql #rustlang

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
156 followers · 209 posts · Server vis.social

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

📥 marketplace.visualstudio.com/i

#datatablerenderers #datasummary #prql

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
156 followers · 208 posts · Server vis.social

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

#prodatatools #prqlnotebook #sql #prql #protools #datanotebook

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
156 followers · 207 posts · Server vis.social

You can try our and Pro Tools free today. It's a one day deal! Don't miss out if you want to try the latest version of , and in Code!
👉 github.com/sponsors/RandomFrac

#sqltools #prql #duckdb #prqlcodelens #duckdbpro

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
156 followers · 205 posts · Server vis.social

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

#sqltools #duckdbpro #prqlcodelens #vscode #datanotebooks #prql

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
156 followers · 204 posts · Server vis.social

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

💵 ⤑ github.com/sponsors/RandomFrac

#sqltools #duckdb #prql #protools #duckdbprotools #prqlcodelens

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
150 followers · 193 posts · Server vis.social
Taras Novak 🇺🇦 · @dataSamurai
149 followers · 188 posts · Server vis.social

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

#prodatatools #prql #duckdb #duckdbprotools

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
149 followers · 185 posts · Server vis.social

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 should totally try !

📥 marketplace.visualstudio.com/i

#prql #datatools #sql

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
149 followers · 183 posts · Server vis.social

You can now Run queries with new loop, func & let vars directly on the open connections using v1.1.0 extension from our private Tools collection. Sign up to get access to the PRQL Code Lens 📦

💖 ⤑ github.com/sponsors/RandomFrac

#datatools #prqlpro #prqlcodelens #sqltools #prql

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
149 followers · 181 posts · Server vis.social

Where all the 🦆s at you ask?

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

...

#sqltools #duckdb #prqlpro #prqlcodelens #prql

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
146 followers · 177 posts · Server vis.social

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

#sqltools #prql #querydatanotebook #dataprotools

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
146 followers · 174 posts · Server vis.social

Quick demo of Run query using our new custom 📔 extension, and results rendered by the Data Table renderer from our 🈸 ... 📓 ...

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

#querydatanotebook #datatablerenderers #datanotebook #vscode #prql

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
146 followers · 173 posts · Server vis.social

Got the rough version of cell run working in our new custom 📓 extension for IDE. Will wire results to our next. Sweet, eh? ...

See GIF: linkedin.com/feed/update/urn:l

#dataprotools #datatablerenderers #vscode #datanotebook #prql

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
146 followers · 172 posts · Server vis.social

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

#datatools #datatablerenderers #prql #datanotebook

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
145 followers · 171 posts · Server vis.social

See supported langs in our new 📚 for @code ext. 😎 We'll let you query your data stores in raw if you prefer that, or using the alternative & -> SQL pipelines ...

& yes! Results will be shown w/our 🈸!

🔬 ...

#datatools #datatablerenderers #MalloyData #prql #sql #datanotebooks

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
144 followers · 169 posts · Server vis.social

Our users can run queries directly on active SQLTools connections, without installing any extra DB 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 #duckdb #prql #prqlcodelens

Last updated 1 year ago

Taras Novak 🇺🇦 · @dataSamurai
144 followers · 168 posts · Server vis.social

🥳 Announcing our 1st release with to connect directly to in .

Become a Pro sponsor on github to get invited to this private extension package repository:

💖 ⤑ github.com/sponsors/RandomFrac

📥 ⤑ github.com/RandomFractals/prql

#protools #vscode #sqltools #prql #prqlcodelens #prqlprotools

Last updated 1 year ago