Yes - it's a specific workload for sure. SQLite is still the GOAT when it comes to OLTP, but DuckDB is really becoming the GOAT in the OLAP world - I think DuckDB is simply amazing and truly an amazing piece of technology for anyone working with large amounts of data.

▲

dataviz1000 2 hours ago | parent [-]

> 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 2 hours ago | parent [-]

Most people forget that clickhouse embedded exists

	▲	iw2rmb 44 minutes ago \| parent [-]
		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.