[dataviz1000]

> SQLite is still the GOAT when it comes to OLTP, but DuckDB is really becoming the GOAT in the OLAP world

Can you explain this more, especially why SQLite is best at OLTP and what happens at scale?

[storywatch]

Most people forget that clickhouse embedded exists

[iw2rmb]

Let's keep discussion bar high.

I've just checked their website, and they state "relying on ClickHouse to power these analytics use cases". That's not OLTP. https://clickhouse.com/comparison/postgresql

Fair to say, seeing 1000x w/o any trace of proof won't help me to choose.