DuckDB

DuckDB just released 1.0.0. I bet on DuckDB. Let’s see what the future holds.

2024-09

https://duckdb.org/2024/09/09/announcing-duckdb-110.html

• histogram is cute for a quick statistical overview of some data.

• SET VARIABLE looks very useful for interactive sessions.

• I like generic SQL-only macros, e.g. SUMMARIZE, because that should allow me to generalize SQL (composition is one of the language’s weak points).

• Habitually, I use CTEs to structure complex queries. Thus Automatic CTE Materialization using a heuristic is a very welcome addition.

  The heuristic currently is that if the CTE performs aggregation and is queried more than once, it should be materialized.

Playing with llm   setup.cfg –> pyproject.toml