Case study
Problem
Go projects using raw SQL or heavy ORMs often lose type safety and predictability — especially around dynamic queries, pagination, and schema sync.
Solution
Built a strict typed PostgreSQL toolkit with generic Table[T] models, consistent (data, error) returns, safe $n placeholders, typed CRUD, ILIKE search, and schema sync controls.
Technical challenges
- Generic Table[T] that works with Go's type system without reflection-heavy magic
- Consistent error handling pattern across all database operations
- Optional typed in-memory cache layer that invalidates correctly on writes
pkg.go.dev
Published
Table[T]
Core API
CRUD + search
Query ops
Go Media Storage
Used in
Tech stack
Go
PostgreSQL
Memory Cache