DuckDB

DuckDB is an open-source, in-memory analytical database management system designed for interactive querying and high-speed data analysis. It was developed by a team of researchers at CWI (Centrum Wiskunde & Informatica) in the Netherlands and is gaining popularity for its impressive performance, especially in analytical workloads.

Practices

• https://levelup.gitconnected.com/six-duckdb-sql-enhancements-you-should-learn-6a229b3c2d3e