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 #prodatatools #MalloyData #datatools
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. πππ
#duckdbsqltools #MalloyData #duckdb #datatools
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 π¬ ...
#datatools #MalloyData #dataexport #datatablerenderers #flatdatagrid #datasummary #datatable #datanotebook #sql
#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 #DataNoteboks in code space without Py at last!
#QueryDataNotebooks π ...
See GIF: https://twitter.com/TarasNovak/status/1634189001367191554
#querydatanotebooks #datanoteboks #MalloyData
See supported langs in our new #DataNotebooks π for @code 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 shown w/our #DataTableRenderers πΈ!
#dataTools π¬ ...
#datatools #datatablerenderers #MalloyData #prql #sql #datanotebooks
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
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 ...
#datatools #dax #github #MalloyData #dataexplores
π’ New 2022 #ChicagoCrimes #MalloyData #Fiddle app you can run in a browser to learn Malloy model and query semantics, nesting, and simple charting ππ options:
π° https://randomfractals.github.io/chicago-crimes/apps/malloy-fiddle
π https://github.com/RandomFractals/chicago-crimes#with-malloy-fiddle
#DAX #dataApps #dataTools π¬ ...
#datatools #dataapps #dax #fiddle #MalloyData #ChicagoCrimes
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 π¬ ...
#datatools #vscode #MalloyData #ChicagoCrimes
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 π οΈ ...
#datatools #duckdb #parquetdata #ChicagoCrimes #MalloyData
@datapythonista @jorisvandenbossche @marcogorelli @maartenbreddels @ritchie46 @andygrove @bkamins I'll tag alone π Mostly interested in #polars & #dataFusion + #ArrowFlight & #ApacheBallista. #MalloyData too actually.
#MalloyData #ApacheBallista #ArrowFlight #DataFusion #polars