Using P3 to connect to CockroachDB
Hi, Just a quick note: it is possible to use P3 (the lean and mean PostgreSQL client for Pharo using frontend/backend protocol 3.0, https://github.com/svenvc/P3) to connect to CockroachDB (an SQL database for global cloud services, an open source clone of Google Spannner, https://www.cockroachlabs.com) as it supports the same line protocol. Just make sure to load the latest version of P3 (and ZTimestamp when you are on Pharo 7). If you do their tutorial, you can set up your connection as follows: P3Client url: 'psql://root@localhost:26257/bank'. Sven
Excellent news! Phil On Mon, Apr 23, 2018 at 11:33 AM, Sven Van Caekenberghe <sven@stfx.eu> wrote:
Hi,
Just a quick note: it is possible to use P3 (the lean and mean PostgreSQL client for Pharo using frontend/backend protocol 3.0, https://github.com/svenvc/P3) to connect to CockroachDB (an SQL database for global cloud services, an open source clone of Google Spannner, https://www.cockroachlabs.com) as it supports the same line protocol.
Just make sure to load the latest version of P3 (and ZTimestamp when you are on Pharo 7).
If you do their tutorial, you can set up your connection as follows:
P3Client url: 'psql://root@localhost:26257/bank'.
Sven
participants (2)
-
phil@highoctane.be -
Sven Van Caekenberghe