Supermoto

Tools for building websites with Go and PostgreSQL

Supermoto is a small collection of Go functions for web development with html templates. It exists because I seem to copy these functions into every new project. It is intentionally minimal, no abstractions, no magic, no framework. Made to work with the standard library router.

If you are building something small and want to stay close to the standard library, it might be useful. If you are on a large team or need something feature-rich you should probably look elsewhere.

Install

go get github.com/Dragonfly-Computing/Supermoto@v1

Usage

database.go

Opens a pgx connection pool to PostgreSQL and verifies the connection with a ping.

pool, err := supermoto.Connect(ctx, "postgres://user:password@localhost:5432/mydb?sslmode=disable")

migrate.go

Runs forward-only SQL migrations from a directory. Migrations are tracked in a schema_migrations table and protected by a PostgreSQL advisory lock to prevent concurrent runs. Files must be named NNN_description.sql (e.g. 001_create_users.sql).

Migrate() accepts a *log.Logger as the last argument to log what migrations were ran/skipped. Pass nil in the last parameter to use the default standard library logger.

err := supermoto.Migrate(ctx, "./migrations", pool, nil)

templates.go

Parses and serves Go HTML templates. The first html view path is the entry point; any additional paths are partials parsed into the same template set, so {{template "name" .}} calls resolve correctly.

supermoto.Serve(w, nil, []string{"views/contract.html"})

To use a base layout with a content page, define {{define "content"}} in your page template and {{template "content" .}} in your base:

supermoto.Serve(w, nil, []string{"views/base.html", "views/home.html"})

To pass data from the handler to the template, use a map to include it in the second parameter:

supermoto.Serve(w, map[string]any{"Name": "Robert Robertson", "Studio": "AdHoc"}, []string{"views/contract.html"})

Notes

• Everything is written to return an error rather than making assumptions and continuing.
• The name Supermoto comes from the fast/versatile/compact/durable/cheap type of motorcycle. They are a lot of fun to ride :)

ToDo

• Middleware chain
• Session based authentication
• Better handling when templates fail (Currently sends 500 to user)
• Example codebase? With recommended file structure?