Using P3 to connect to CockroachDB

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Using P3 to connect to CockroachDB

Sven Van Caekenberghe-2
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
Reply | Threaded
Open this post in threaded view
|

Re: Using P3 to connect to CockroachDB

philippeback
Excellent news!

Phil

On Mon, Apr 23, 2018 at 11:33 AM, Sven Van Caekenberghe <[hidden email]> 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