A simple service demonstrating Go, gRPC, and PostgreSQL. Integration with CircleCI (version 1.0) included.
Building go-httpd requires Go 1.8 or later. gvm is a great tool for installing and managing your versions of Go.
Download and build it like so:
mkdir go-grpc-pg # Or any directory of your choice cd go-grpc-pg/ export GOPATH=$PWD go get -t github.com/otoolep/go-grpc-pg/... cd src/github.com/otoolep/go-grpc-pg go install ./...
Some people consider using a distinct
GOPATH environment variable for each project doing it wrong. In practise I, and many other Go programmers, find this actually most convenient.
Optional step to speed up testing
Unit testing actually uses SQLite, which is built as part of the test suite -- there is no need to install SQLite separately. However the compilation of SQLite is slow, and quickly becomes tedious if continually repeated. To avoid continual compilation every test run, execute the following command after performing the steps above:
go install github.com/mattn/go-sqlite3
Once built as per above, launch the server as follows:
This assumes PostgreSQL is listening on
localhost, port 5432. Run
$GOPATH/bin/server -h to learn the full configuration the server expects of PostgreSQL, including the database, user, and password that must exist.
Assuming the server is up and running, execute the client as follows.
An example session is shown below.
>> CREATE TABLE bar (id INTEGER NOT NULL PRIMARY KEY, name TEXT) Last Insert ID: -1, rows affected: 1 >> SELECT * FROM bar >> INSERT INTO bar(id, name) VALUES(1, 'bob') Last Insert ID: -1, rows affected: 1 >> INSERT INTO bar(id, name) VALUES(2, 'tom') Last Insert ID: -1, rows affected: 1 >> SELECT * FROM bar 1 bob 2 tom >>