Developer Tool Completed

PgGo

Typed PostgreSQL library for Go: generic Table[T] models, safe placeholders, CRUD, pagination, and optional cache.

Case study

Problem

Go projects using raw SQL or heavy ORMs lose type safety on dynamic queries, pagination, and schema sync.

Solution

Typed PostgreSQL toolkit with generic Table[T] models, consistent (data, error) returns, safe $n placeholders, typed CRUD, ILIKE search, and schema sync.

Technical challenges

Generic Table[T] that works with Go's type system without heavy reflection
Consistent error handling across all database operations
Optional typed cache layer that invalidates correctly on writes

Published

pkg.go.dev

Core API

Table[T]

Query ops

CRUD + search

Used in

Go Media Storage

Tech stack

Go

PostgreSQL

Memory Cache