3 ms·

Can 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

by collyw 7y ago

Can 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 ago
PostgreSQL underlies at least a plurality of SQL DBMS developments nowadays, specially for scale-out (distributed) projects.
- wgjordan 7y ago
  Any 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 ago
    That'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 ago
    because wordpress
ansible 7y ago
In 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 ago
  Ok, so the "driver protocol" would be another way of saying that.
mey 7y ago
Not 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.

by collyw 7y ago

Can 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 ago

PostgreSQL underlies at least a plurality of SQL DBMS developments nowadays, specially for scale-out (distributed) projects.

wgjordan 7y ago
Any 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 ago
  That'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 ago
  because wordpress

ansible 7y ago

In 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 ago
Ok, so the "driver protocol" would be another way of saying that.

mey 7y ago

Not 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.