Taking down fully staffed @Google #dataTools in @code team in 2 weeks of coding & 4+ months in marketplace ... @lloydtabb & your #MalloyData crew been pwned in installs in @code:

πŸ“₯ https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools

#ProDataTools πŸ§™β€β™‚οΈ ... πŸ’ŽπŸ’ŽπŸ’Ž ... 😎

P.S.: add #duckdb keyword to yours..

DuckDB Sql Tools - Visual Studio Marketplace

Extension for Visual Studio Code - DuckDB Sql Tools extension adds DuckDB connections, database schema, and SQL query user interfaces to VSCode IDE.

Talk about #DataTools πŸͺ„ & #DuckDB in @code FTW: #MalloyData has been in dev w/fully staffed dev team since January 2022 & we put together our free trial #DuckDBSqlTools in a month in January 2023. One in VS marketplace for over a year & a half, the other only 4 months. πŸ’ŽπŸ’ŽπŸ’Ž
Running #SQL queries in our new #DataNotebook πŸ““ @code extension, rendering results with simple #DataTable, #DataSummary 🈷️ & #FlatDataGrid δΈ­ from our #DataTableRenderers 🈸 + CSV #DataExport from VSCode Notebook cell output all in one go. We doubt #MalloyData is as flexible. 😎 #DataTools πŸ”¬ ...

#MalloyData team actually beat us to it and added .malloynb support to VSCode IDE in their pre-release version yesterday.

Great to see some new variety and healthy competition in the #DataNotebooks in code space without Py at last!

#QueryDataNotebooks πŸ“š ...

See GIF: https://twitter.com/TarasNovak/status/1634189001367191554

Tweet / Twitter

Twitter

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

Playground

PRQL

Please tag your #dataExplores with Malloy using #MalloyData tag on #github. I'd like to see what other devs & data scientists create with that new #DAX language.

See ours here: https://github.com/topics/malloydata

+ https://github.com/RandomFractals/chicago-crimes#with-malloy-composer

+ https://github.com/RandomFractals/chicago-crimes#with-malloy-fiddle

#dataTools πŸ› οΈ 2022 ...

Build software better, together

GitHub is where people build software. More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects.

GitHub
2022 Chicago Crime Reports Malloy Fiddle App

Updated #ChicagoCrimes with #MalloyData tools example & more info in docs:

🧐 https://github.com/RandomFractals/chicago-crimes#with-malloy-data

Clone that data repo & install Malloy #vscode extension to try it out:

πŸ“₯ https://marketplace.visualstudio.com/items?itemName=malloydata.malloy-vscode

#dataTools πŸ”¬ ...

GitHub - RandomFractals/chicago-crimes: Exploring Chicago crimes dataset with Jupyter notebooks, DuckDB, Malloy and new Panel/PyScript data and dashboard tools.

Exploring Chicago crimes dataset with Jupyter notebooks, DuckDB, Malloy and new Panel/PyScript data and dashboard tools. - GitHub - RandomFractals/chicago-crimes: Exploring Chicago crimes dataset w...

GitHub

I've decided to try #MalloyData today.

Here is a quick example of loading #ChicagoCrimes 2022 #parquetData with #DuckDB and Malloy queries for some rough counts and data summaries:

https://github.com/RandomFractals/chicago-crimes/issues/24

#dataTools πŸ› οΈ ...

Add Malloy DuckDB parquet data loading and queries example Β· Issue #24 Β· RandomFractals/chicago-crimes

Use smaller 2022 crimes dataset added in #22 Malloy docs: https://looker-open-source.github.io/malloy/documentation/language/basic.html MalloyData VSCode extension in VS Marketplace: https://market...

GitHub