pogo

Pogo

Type-safe Database Client for Go. Supports PostgreSQL and SQLite.

The code has been in production for many years now including Standup Jack.

Install

go install github.com/matthewmueller/pogo/cmd/pogo@latest

Usage

Introspect your database

# connect to a postgres database and build the client into internal/pogo
pogo --db $(POSTGRES_URL) --schema public --dir ./internal/pogo

Using the Generated Client

db, err := pgxpool.New(ctx, url.DSN)
if err != nil {
  return nil, err
}

users, err := user.FindMany(db,
  user.NewFilter().Email("alice@livebud.com"),
  user.NewOrder().CreatedAt(user.DESC),
)

Check out the tests for more usage examples.

Development

Running Tests

To run the tests, you'll need to have PostgreSQL installed locally with an empty pogo database:

createdb pogo
make test

License

MIT