4 ms·
The best part of moving to PostgreSQL is that it is sort of the defacto standard wire protocol for relational databases now and that enables you to "grow into"
by outside1234 7y ago
The best part of moving to PostgreSQL is that it is sort of the defacto standard wire protocol for relational databases now and that enables you to "grow into" something like CockroachDB down the line when you need that sort of scale.
- collyw 7y agoCan you explain your comment in more detail as I am not really sure what you getting at with "the defacto standard wire protocol for relational databases" nor "grow into" something like CockroachDB".
- leandrod 7y agoPostgreSQL underlies at least a plurality of SQL DBMS developments nowadays, specially for scale-out (distributed) projects.
- wgjordan 7y agoAny sources on that assertion? A quick bit of Google searching [1] shows me only ~10% market share for PostgreSQL, compared to ~46% for MySQL. [1] https://www.datanyze.com/market-share/databases/postgresql-vs-mysql https://www.datanyze.com/market-share/databases/postgresql-v...
- martin_marques 7y agoThat's a joke right? I mean, you don't measure market share by looking at how many "websites" use one or the other database.
- provolone 7y agobecause wordpress
- ansible 7y agoIn the case of CockroachDB (a distributed database), it has the same wire-level protocol as Postgresql. So if your programming language has a Postgresql driver (and it likely does), then you can also talk to a CDB database as well. The SQL dialects are not the same, though they are similar, so you will have to go through your code to see if you need to fix anything. Moving the data itself over is fairly straight-forward: https://www.cockroachlabs.com/docs/stable/migrate-from-postgres.html https://www.cockroachlabs.com/docs/stable/migrate-from-postg...
- collyw 7y agoOk, so the "driver protocol" would be another way of saying that.
- mey 7y agoNot parent. No idea about the defacto standard comment. CockroachDB client protocol is* compatible with PostgreSQL. Edit: as well as SQL syntax, that's the important bit. Meaning you could in theory mirror data to CockroachDB and the point your clients to it instead of PostgreSQL. CockroachDB is aiming to solve horizontal scaling, hence the "grow" comment.