Are there any decent ORMs in Golang?

1. scany

   1 6 1,417 2.5 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).

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. ent

   2 146 16,188 8.7 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.

4. goose

   3 30 8,392 8.4 Go

   A database migration tool. Supports SQL migrations and Go functions. (by pressly)

   

5. sqlc

   4 182 15,064 9.0 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.

6. SQLBoiler

   5 43 6,863 6.9 Go

   Generate a Go ORM tailored to your database schema.

   

   sqlboiler

7. Squirrel

   6 54 7,311 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.

8. bqb

   7 13 168 3.9 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.

9. SaaSHub

   www.saashub.com featured

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

   

Suggest a related project