logoalt Hacker News

cle • yesterday at 7:33 PM • 1 reply • view on HN

It is optimized for analytic workloads (default in-mem columnar layout), whereas PG and sqlite are OLTP DBs. It's going to be insanely faster for those use cases.


Replies

zeristor • yesterday at 8:50 PM

And with DuckDB?

DuckDB is an in process OLAP, I’ve been using it a lot, and I am keen to use Polars but DuckDB seemings to be flying for me.