What is the best way to use PostgreSQL with Go?

• GORM

  74 35,416 8.4 Go

  The fantastic ORM library for Golang, aims to be developer friendly

  

I will add a fourth choice that I have been using with PostgreSQL and it’s fantastic! https://gorm.io/ gorm

• SQLBoiler

  42 6,424 7.8 Go

  Generate a Go ORM tailored to your database schema.

  

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• pggen

  11 268 6.6 Go

  Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.

I created pggen a few weeks ago to create my preferred method of database interaction: I write real SQL queries and I use generated, type-safe Go interfaces to the queries. https://github.com/jschaf/pggen

• sqlc

  169 10,837 9.7 Go

  Generate type-safe code from SQL

  

The project is new but pretty well tested; bug reports welcome. Sqlc is a more mature code generator in the same design space with a different implementation that I can also recommend. https://github.com/kyleconroy/sqlc

Suggest a related project