|
|
|
|
|
by hodgesrm
703 days ago
|
|
You can't use ClickHouse this way. It does not have ACID transactions and the main table type (MergeTree) is optimized for reads on append-only workloads that operate on large blocks. MySQL & PostgreSQL are vastly better for OLTP use cases. |
|
I don't think it is impossible to use Clickhouse as a backend to a CRUD app, if you didn't particularly care about things like transactional guarantees or read performance. You still can write rows to it, and read rows from it.
I've also worked in the business long enough to know that people make all kinds of suboptimal engineering decisions all the time.