Are there any decent ORMs in Golang?

• scany

  5 1,207 5.4 Go

  Library for scanning data from a database into Go structs and more

When I don't use one, I'm typically using SQLx or (if using Postgres) pgx with scany https://github.com/georgysavva/scany (slightly better API than SQLx and great performance since you can use the native interface from pgx if desired whereas many database drivers only offer the text-based interface).

• ent

  145 15,042 8.1 Go

  An entity framework for Go

  

I think the best ORM in Go is Ent: https://entgo.io/ It has great docs, great migration capabilities, and is well run with professional staff. The only downside is that some people don't like the approach of code generation.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• goose

  29 5,951 8.9 Go

  A database migration tool. Supports SQL migrations and Go functions.

  

• sqlc

  171 11,247 9.6 Go

  Generate type-safe code from SQL

  

I have been using: https://sqlc.dev/ With pgx for Postgres and liking it so far. It does code generation. But seems pretty easy to maintain. And there is no reflection at runtime, so performance is good.

• SQLBoiler

  43 6,486 7.7 Go

  Generate a Go ORM tailored to your database schema.

  

sqlboiler

• Squirrel

  52 6,599 2.4 Go

  Fluent SQL generation for golang

  

But using a query builder, something like squirrel or (plug) bqb, allows you to actually write SQL (or something close to it) when you need it but also handles the nasty string building bits. Though I agree that ORMs are not always bad, especially for small projects with well-defined scope.

• bqb

  13 132 6.0 Go

  BQB is a lightweight and easy to use query builder that works with sqlite, mysql, mariadb, postgres, and others.

But using a query builder, something like squirrel or (plug) bqb, allows you to actually write SQL (or something close to it) when you need it but also handles the nasty string building bits. Though I agree that ORMs are not always bad, especially for small projects with well-defined scope.

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

Suggest a related project