6 ms·

> If I had to only pick two databases to deal with, I’d be quite happy with just Postgres and ClickHouse - the former for OLTP, the latter for OLAP. As the au

> If I had to only pick two databases to deal with, I’d be quite happy with just Postgres and ClickHouse - the former for OLTP, the latter for OLAP. As the author mentioned, I completely agree with this statement. In fact, many companies like Cloudflare are built with exactly this approach and it has scaled them pretty well without the need of any third database. > Another reason I suggest checking out ClickHouse is that it is a joy to operate - deployment, scaling, backups and so on are well documented - even down to setting the right CPU governor is covered. Another point mentioned by author which is worth highlighting is the ease of deployment. Most distributed databases aren't so easy to run at scale, ClickHouse is much much easier and it has become even more easier with efficient storage-compute separation.

saisrirampur 2y ago
Sai from ClickHouse here. Have been living and breathing past year helping customers integrating Postgres and ClickHouse together. Totally agreed with this statement - there are numerous production grade workloads solving most of their data problems using these 2 purpose-built Open Source databases. My team at ClickHouse has been working hard to make the integration even seamless. We work on PeerDB, an open source tool enabling seamless Postgres replication to ClickHouse https://github.com/PeerDB-io/peerdb/ https://github.com/PeerDB-io/peerdb/ This integration is now also natively available in the Cloud through ClickPipes. The private preview was released just last week https://clickhouse.com/cloud/clickpipes/postgres-cdc-connector https://clickhouse.com/cloud/clickpipes/postgres-cdc-connect...
yas_hmaheshwari 2y ago
Out of curiosity: Why not mysql? I am also surprised that no one has even mentioned mysql in any of the comments so far -- so looks like the verdict is very clear on that one PS: I am also a fan of Postgres, and we are using that for our startup. But I don't know the answer if someone asks me, why not Mysql. Hence asking
- codazoda 2y ago
  I think this might come down to… Oracle. Obviously there are alternatives like MariaDB but Postgres is a quality long standing open source solution.
- pradeepchhetri 2y ago
  To my knowledge, both Postgres and MySQL has their own strengths and weaknesses. Example: mvcc implementation, data replication, connection pooling and difficulty of upgrades were the major weaknesses of Postgres which are much improved over time. Similarly mysql query optimizer is consider lesser developed than that of Postgres's. Overall I think Postgres adoption and integrations and thus community is much more wider than MySQL which gives it major advantage over MySQL. Also looking at the number of database-as-a-service companies of Postgres vs those of MySQL we can immediately acknowledges that Postgres is much widely adopted.
  - throwawaythekey 2y ago
    A few other things I would add: - MySQL performs a bit better when reading by primary key - Postgres performs a bit better when doing random inserts/updates. - MySQL you don't need to worry about vacuums - The MySQL query optimizer is nice because you can give it hints when it misbehaves. This can be a godsend during certain production incidents. - Last I checked MySQL still has a nicer scaling story than postgres, but I'm not sure what the latest here is. - Connection pooling is still heavily in MySQLs favor i.e. you don't need the PG bouncer for lots for scenarios.
  - yas_hmaheshwari 2y ago
    There was an article from Uber on why they shifted from Postgres to Mysql: https://www.uber.com/en-IN/blog/postgres-to-mysql-migration/ https://www.uber.com/en-IN/blog/postgres-to-mysql-migration/ I don't know how much of that article points are still valid. The other part in favor of mysql (in my opinion) are that there are lots of companies that use mysql in production - so the access patterns, and its quirks are very well defined Companies like Square, YouTube, Meta, Pinterest, now Uber all use mysql. From blind, Stripe was also thinking of moving all its fleet from Mongo to mysql Perception wise, it looks like companies needing internet scale data are using mysql

saisrirampur 2y ago

Sai from ClickHouse here. Have been living and breathing past year helping customers integrating Postgres and ClickHouse together. Totally agreed with this statement - there are numerous production grade workloads solving most of their data problems using these 2 purpose-built Open Source databases. My team at ClickHouse has been working hard to make the integration even seamless. We work on PeerDB, an open source tool enabling seamless Postgres replication to ClickHouse https://github.com/PeerDB-io/peerdb/ https://github.com/PeerDB-io/peerdb/ This integration is now also natively available in the Cloud through ClickPipes. The private preview was released just last week https://clickhouse.com/cloud/clickpipes/postgres-cdc-connector https://clickhouse.com/cloud/clickpipes/postgres-cdc-connect...

yas_hmaheshwari 2y ago

Out of curiosity: Why not mysql? I am also surprised that no one has even mentioned mysql in any of the comments so far -- so looks like the verdict is very clear on that one PS: I am also a fan of Postgres, and we are using that for our startup. But I don't know the answer if someone asks me, why not Mysql. Hence asking

codazoda 2y ago
I think this might come down to… Oracle. Obviously there are alternatives like MariaDB but Postgres is a quality long standing open source solution.
pradeepchhetri 2y ago
To my knowledge, both Postgres and MySQL has their own strengths and weaknesses. Example: mvcc implementation, data replication, connection pooling and difficulty of upgrades were the major weaknesses of Postgres which are much improved over time. Similarly mysql query optimizer is consider lesser developed than that of Postgres's. Overall I think Postgres adoption and integrations and thus community is much more wider than MySQL which gives it major advantage over MySQL. Also looking at the number of database-as-a-service companies of Postgres vs those of MySQL we can immediately acknowledges that Postgres is much widely adopted.
- throwawaythekey 2y ago
  A few other things I would add: - MySQL performs a bit better when reading by primary key - Postgres performs a bit better when doing random inserts/updates. - MySQL you don't need to worry about vacuums - The MySQL query optimizer is nice because you can give it hints when it misbehaves. This can be a godsend during certain production incidents. - Last I checked MySQL still has a nicer scaling story than postgres, but I'm not sure what the latest here is. - Connection pooling is still heavily in MySQLs favor i.e. you don't need the PG bouncer for lots for scenarios.
- yas_hmaheshwari 2y ago
  There was an article from Uber on why they shifted from Postgres to Mysql: https://www.uber.com/en-IN/blog/postgres-to-mysql-migration/ https://www.uber.com/en-IN/blog/postgres-to-mysql-migration/ I don't know how much of that article points are still valid. The other part in favor of mysql (in my opinion) are that there are lots of companies that use mysql in production - so the access patterns, and its quirks are very well defined Companies like Square, YouTube, Meta, Pinterest, now Uber all use mysql. From blind, Stripe was also thinking of moving all its fleet from Mongo to mysql Perception wise, it looks like companies needing internet scale data are using mysql