ORM vs SQL Builder in Go

• Squirrel

  52 6,505 2.8 Go

  Fluent SQL generation for golang

  

Using an ORM library like gorm, which potentially will generate unnecessary queries or using SQL builder library like squirrel where I need to manually write those queries that an ORM would do for me?

• bqb

  13 122 7.1 Go

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

Squirrel is great! Let me also plug bqb.

• 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.

  

• jet

  26 2,010 8.1 Go

  Type safe SQL builder with code generation and automatic query result data mapping

IMO jet is probably the most advanced SQL builder for go. Don't use ORMs.

• sqlc

  169 10,837 9.7 Go

  Generate type-safe code from SQL

  

sqlc is the best database access tool I’ve ever used.

• SQLBoiler

  42 6,424 7.8 Go

  Generate a Go ORM tailored to your database schema.

  

I love SQL Boiler, which generates type-safe code for you from the database schema.

• proteus

  2 195 3.5 Go

  A simple tool for generating an application's data access layer. (by jonbodner)

I have a SQL mapping tool called Proteus at https://github.com/jonbodner/proteus . I spoke about its design and performance at GopherCon 2017: https://www.youtube.com/watch?v=hz6d7rzqJ6Q

• goqu

  23 2,227 5.6 Go

  SQL builder and query library for golang

We've been using goqu and it's super nice! although there are a ton of other query builders that could better fit your use-case.

• InfluxDB

  www.influxdata.com sponsored

  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.

  

Suggest a related project