News for hackers. Stuff that matters.
Re:Ask HN: Are there any websites for SQL puzzle games? by mrtimo on Saturday March 02, 2024 @02:45AM (#39570780)
You don't even need a database file if you use Malloy, just a .parquet file or .csv file will work. Think of a .parquet file as a python dataframe saved as a file. DuckDB combined with Malloy are a powerful combo. If you like writing SQL queries for fun, you should like writing Malloy queries even more (at least I do). If you are looking to compare timeframes, Malloy does this well: https://docs.malloydata.dev/documentation/patterns/yoy
Re:Ask HN: Are there any websites for SQL puzzle games? by prometheon1 on Saturday March 02, 2024 @03:46PM (#39575609)
You don't even need Malloy if you use DuckDB, just a .parquet file or .csv file. https://duckdb.org/docs/data/overview