Features
Works over PostgreSQL protocol
The application communicates with the router using the PostgreSQL protocol. In other words, the application doesn’t even know that it’s communicating with a Golang application and not a regular PostgreSQL cluster.
Moreover, you can connect to the router and the coordinator via psql to perform administrative tasks. SPQR has an administrative console. You can find the console port in your config file.
➜ psql "host=localhost sslmode=verify-full user=demo dbname=demo port=7432"
SPQR router admin console
Here you can configure your routing rules
------------------------------------------------
You can find documentation here
https://github.com/pg-sharding/spqr/tree/master/docs
SHOW shards;
listing data shards
---------------------
shard id -> shard1
shard id -> shard2
(2 rows)
Was this page helpful?