Comment on Choose DuckDB rather than SQLiteparentComments−dataviz10001moSQLite is still the GOAT when it comes to OLTP, but DuckDB is really becoming the GOAT in the OLAP worldCan you explain this more, especially why SQLite is best at OLTP and what happens at scale?−storywatch1moMost people forget that clickhouse embedded exists−iw2rmb1moLet'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/postgresqlFair to say, seeing 1000x w/o any trace of proof won't help me to choose.−misiek081moYou new to the world, right? ClickHouse proven being a beast for analytics, tracing and even some basic metrics storage (VM won of course, but still CH is probably 2nd or 3rd)−storywatch1mo* for other readers, VM here most likely refer to Victoria Metrics−iw2rmb1moEvery day someone is new to the world. Analytics is not OLTP. Would appreciate for anything to read except “you stupid” and “believe me, bro”.
Comments
Can you explain this more, especially why SQLite is best at OLTP and what happens at scale?
Most people forget that clickhouse embedded exists
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.
You new to the world, right? ClickHouse proven being a beast for analytics, tracing and even some basic metrics storage (VM won of course, but still CH is probably 2nd or 3rd)
* for other readers, VM here most likely refer to Victoria Metrics
Every day someone is new to the world. Analytics is not OLTP. Would appreciate for anything to read except “you stupid” and “believe me, bro”.