Create a gRPC (and HTTP/JSON) Server from the generated code by the awesome sqlc project. If you’re searching for a SQLC plugin, use sqlc-gen-go-server.
go install github.com/sqlc-dev/sqlc/cmd/sqlc@latest
go install github.com/bufbuild/buf/cmd/buf@latest
go install github.com/walterwanderley/sqlc-grpc@latest
--queries.sql
CREATE TABLE authors (
id BIGSERIAL PRIMARY KEY,
name text NOT NULL,
bio text,
created_at TIMESTAMP
);
-- name: GetAuthor :one
-- http: GET /authors/{id}
SELECT * FROM authors
WHERE id = $1 LIMIT 1;
-- name: ListAuthors :many
-- http: GET /authors
SELECT * FROM authors
ORDER BY name;
-- name: CreateAuthor :one
-- http: POST /authors
INSERT INTO authors (
name, bio, created_at
) VALUES (
$1, $2, $3
)
RETURNING *;
-- name: DeleteAuthor :exec
-- http: DELETE /authors/{id}
DELETE FROM authors
WHERE id = $1;
-- name: UpdateAuthorBio :exec
-- http: PATCH /authors/{id}/bio
UPDATE authors
SET bio = $1
WHERE id = $2;
version: "2"
sql:
- schema: "./queries.sql"
queries: "./queries.sql"
engine: "postgresql"
gen:
go:
out: "internal/author"
sqlc generate
sqlc-grpc -m "mymodule"
go run . -db [Database Connection URL] -dev
Use the -litefs command line parameter to replicate SQLite with LiteFS as a library. Example: https://github.com/walterwanderley/sqlc-grpc/tree/main/_examples/authors/sqlite
You can customize the HTTP endpoints generated by grpc-gateway by adding comments to the queries.
-- http: Method Path
Here’s an example of a queries file that has a custom HTTP endpoint:
-- name: ListAuthors :many
-- http: GET /authors
SELECT * FROM authors
ORDER BY name;
-- name: UpdateAuthorBio :exec
-- http: PATCH /authors/{id}/bio
UPDATE authors
SET bio = $1
WHERE id = $2;
It's safe to edit any generated code that doesn't have the DO NOT EDIT
indication at the very first line.
After modify a SQL file, execute these commands below:
sqlc generate
go generate
buf generate
.