SingleStore is pretty amazing since it supports UPDATE DELETE and joins with other tables. Clickhouse updates are painful. I looked on postgres with citus exte

SingleStore is pretty amazing since it supports UPDATE DELETE and joins with other tables. Clickhouse updates are painful. I looked on postgres with citus extension and it only supports appends. Their paper on how they organize the columnstore and row store buffer is pretty neat. https://images.go.singlestore.com/Web/MemSQL/%7Bd1e77ba1-0e3e-4194-8438-2e289cb2b87c%7D_research-paper-cloud-native-transactions-and-analytics-in-singlestore.pdf https://images.go.singlestore.com/Web/MemSQL/%7Bd1e77ba1-0e3... It’s really cool to see usefathom take off doing millions in ARR with two engineers. SingleStore has to been a high leverage choice so they can focus on product. Power to them. Meanwhile we’ve been grappling with a mixture of Mongo, Snowflake and Postgres for more than an year with a decent sized team. The curse of VC funded startups is that with more money and more engineers, a likely outcome is more complexity. The infra becomes a complex beast that takes many quarters/years to build because there isn’t that market pressure to be time and money efficient.