gem-hunter
Language: Go
Raft + Postgres parser + Postgres wire protocol + Boltdb + ? = Distributed PostgreSQL
Terminal 1:
$ go build $ ./waterbugdb --node-id node1 --raft-port 2222 --http-port 8222 --pg-port 6000
Terminal 2:
$ go build $ ./waterbugdb --node-id node2 --raft-port 2223 --http-port 8223 --pg-port 6001
Terminal 3, tell 1 to have 2 follow it:
$ curl 'localhost:8222/add-follower?addr=localhost:2223&id=node2'Terminal 3, now open psql:
$ psql -h localhost -p 6000 psql -h 127.0.0.1 -p 6000 psql (13.4, server 0.0.0) Type "help" for help. phil=> create table x (age int, name text); CREATE ok phil=> insert into x values(14, 'garry'), (20, 'ted'); could not interpret result from server: INSERT ok INSERT ok phil=> select name, age from x; name | age ---------+----- "garry" | 14 "ted" | 20 (2 rows)
Now exit psql and connect to the other database at port 6001. It
will fail if you try to write to it but SELECTs will work:
$ psql -h 127.0.0.1 -p 6001 psql (13.4, server 0.0.0) Type "help" for help. phil=> select age, name from x; age | name -----+--------- 20 | "ted" 14 | "garry" (2 rows)