ORM or no ORM (and which ones)?

1. sqlc

   1 182 15,507 8.9 Go

   Generate type-safe code from SQL

   

   SQL code generator (aka inspect a database or SQL files to generate data models). You have the option of using something like volatiletech/sqlboiler which looks at the a physical database and generates code based on the schema. Or SQLC which is an amazing and fast project.

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

   2 54 7,311 2.4 Go

   Fluent SQL generation for golang

   

   I personally do the no ORM approach, often combining query-builders with SQL drivers (sqlx + squirrel) as to avoid raw SQL in my code. You can build composable query this way and it lessens the likelihood of someone accidentally creating a SQL injection vulnerability.

4. almanack

   3 11 26 9.0 Go

   Predicts future sports scores

   

   You just write more queries and sqlc will make ad hoc types for you. I have a bunch of code here: https://github.com/spotlightpa/almanack/tree/master/internal/db https://github.com/spotlightpa/almanack/tree/master/sql/queries

5. GORM

   4 86 38,514 7.9 Go

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

   

   Hello, I want to communicate with a database in my go API. My API is for a website that allows you to track finances and budgets, so the reason I need a database is to store the user's expenses and allow them to search and find each one and which one is costing them the most. I also am going to implement login soon, but I don't think that matters for now. I'm now stuck on how to communicate with my database (Postgres). Should I go with an ORM like gorm, database/sql package, sqlx, or any others? Advice is appreciated

6. sqlx

   5 77 17,036 3.3 Go

   general purpose extensions to golang's database/sql

   

   https://github.com/jmoiron/sqlx and github.com/lib/pq are pretty solid, this is what i go to.

7. tinyORM

   6 2 1 5.2 Go

   A tiny package for your basic data layer needs (by BitlyTwiser)

   

8. bun

   7 18 4,255 9.3 Go

   SQL-first Golang ORM (by uptrace)

   

   This way: https://github.com/uptrace/bun, I prefer in all cases with PostgreSQL

9. Stream

   getstream.io featured

   Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.

   

10. ent

    8 146 16,349 8.5 Go

    An entity framework for Go

    

    Check out https://entgo.io/ I like the approach to define an entity schema first and let handle entgo the query part.

11. sqload

    9 3 44 3.9 Go

    Load your SQL queries from .sql files instead of writing the SQL code in your Go source files.

    

    sqload

12. goyesql

    10 1 253 5.0 Go

    Go + Yesql (by nleof)

    

    Yesqlgoyesql

13. jet

    11 30 3,263 8.9 Go

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

    

    Use sql builder https://github.com/go-jet/jet.

14. goqu

    12 24 2,519 4.5 Go

    SQL builder and query library for golang

    

    SQL Builders (think squirrel or goqu)

15. SQLBoiler

    13 43 6,897 7.5 Go

    Generate a Go ORM tailored to your database schema.

    

    SQL code generator (aka inspect a database or SQL files to generate data models). You have the option of using something like volatiletech/sqlboiler which looks at the a physical database and generates code based on the schema. Or SQLC which is an amazing and fast project.

Suggest a related project