3 ms·
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
by 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 agoOk, so the "driver protocol" would be another way of saying that.