[mrtimo]

Thanks for letting me know about this! I do the same thing... DuckDB loads CSVs very quick and easy. Malloy uses duckDB and can work in VScode or vscode.dev or the vscode built into github. So, you can analyze large .csv files in any of those places.

For example, go here [1]. Press "." (this loads vscode in browser) and you will be analyzing large .csv or .parquet files directly in your browser, after you click on the .malloynb file

Something I made to analyze every form submitted to the Securities and Exchange Commission (SEC) (10-K etc.) since 2014. [2] Go there, press ".", install the malloy extension, and click on the .malloynb file! Do it all within your browser, or download it and use it in VScode.

[1] https://github.dev/malloydata/quickstart/blob/main/README [2] https://github.dev/mrtimo/isa5

[392]

How do you feel about Malloy vs PRQL?

[mrtimo]

I think I would miss the the semantic data modeling of malloy, and Malloy is definitely easier to read and write IMHO, in part because of the semantic data modeling.

I would also miss the nest feature of Malloy, and the way it handles time / dates / timestamps.