Go ORM

Open-source Go projects categorized as ORM

Top 23 Go ORM Projects

  • GORM

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

    Project mention: Go ORMs Compared | dev.to | 2024-01-18

    GORM is a comprehensive ORM tool in Go, offering a code-first approach which allows defining database schemas using struct tags in Go. It's known for its developer-friendly nature, making it suitable for both beginners and experienced users. GORM supports a variety of SQL databases like MySQL, PostgreSQL, and SQLite. It's designed to be flexible, allowing developers to drop down to raw SQL when necessary. However, it's important to be cautious about its performance implications in large-scale applications.

  • ent

    An entity framework for Go

    Project mention: Concurrency Control in Go with Ent ORM and MySQL | dev.to | 2024-03-21

    In this article, we'll delve into the world of concurrency control in Go, specifically focusing on the optimistic locking approach. We'll explore its implementation using Ent ORM to illustrate how to manage data consistency when multiple users interact with the same resource. Keep in mind that this example serves as a simplified illustration, and real-world booking systems involve a many of additional complexities. However, the core concepts presented here provide a solid foundation for understanding optimistic locking in Go applications. Feel free to explore the complete source code in my GitHub repository for a more in-depth look at the implementation.

  • InfluxDB

    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.

  • gf

    GoFrame is a modular, powerful, high-performance and enterprise-class application development framework of Golang. (by gogf)

  • sqlc

    Generate type-safe code from SQL

    Project mention: Give Up Sooner | dev.to | 2024-03-13

    "Is there a way to get sqlc to use pointers for nullable columns instead of the sql.Null types?"

  • SQLBoiler

    Generate a Go ORM tailored to your database schema.

    Project mention: Go ORMs Compared | dev.to | 2024-01-18

    SQLBoiler takes a database-first approach, generating Go code from your database schema. This means it creates highly optimized and custom-tailored code for your specific database schema. SQLBoiler is great for applications where the database schema is well-defined and changes infrequently. However, like sqlc, it requires regenerating the code when the database schema changes. It's well-suited for projects where performance is a key concern and the database design is stable​.

  • Xorm

  • go-pg

    Golang ORM with focus on PostgreSQL features and performance

  • WorkOS

    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.

  • gorp

    Go Relational Persistence - an ORM-ish library for Go

  • xo

    Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)

    Project mention: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02

    i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.

  • upper.io/db

    Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.

  • bun

    SQL-first Golang ORM (by uptrace)

  • gormt

    database to golang struct

  • Storm

    Simple and powerful toolkit for BoltDB (by asdine)

  • prisma-client-go

    Prisma Client Go is an auto-generated and fully type-safe database client

    Project mention: Prisma Client Go: Typesafe Database Client for Golang | news.ycombinator.com | 2024-01-20
  • xorm

    xorm是一个简单而强大的Go语言ORM库,通过它可以使数据库操作非常简便。本库是基于原版xorm的定制增强版本,为xorm提供类似ibatis的配置文件及动态SQL支持,支持AcitveRecord操作 (by xormplus)

  • reform

    A better ORM for Go, based on non-empty interfaces and code generation. (by go-reform)

  • gobuffalo/pop

    A Tasty Treat For All Your Database Needs (by gobuffalo)

  • go-doudou

    go-doudou(doudou pronounce /dəudəu/)is OpenAPI 3.0 (for REST) spec and Protobuf v3 (for grpc) based lightweight microservice framework. It supports monolith service application as well.

  • go-sqlbuilder

    A flexible and powerful SQL string builder library plus a zero-config ORM.

    Project mention: Best sqlc alternative for dynamic queries? | /r/golang | 2023-05-15

    Here are 2 options for you * https://github.com/huandu/go-sqlbuilder * https://github.com/Masterminds/squirrel

  • gocqlx

    All-In-One: CQL query builder, ORM and migration tool

  • REL

    :gem: Modern ORM for Golang - Testable, Extendable and Crafted Into a Clean and Elegant API

    Project mention: Prisma for Go vs. Node.js Prisma Client & GORM: Thoughts? | /r/golang | 2023-12-10
  • godb

    A Go SQL query builder and struct mapper.

  • go-queryset

    100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.

  • SaaSHub

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

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2024-03-21.

Go ORM related posts

Index

What are some of the best open-source ORM projects in Go? This list will help you:

Project Stars
1 GORM 35,144
2 ent 14,763
3 gf 10,722
4 sqlc 10,518
5 SQLBoiler 6,373
6 Xorm 6,204
7 go-pg 5,566
8 gorp 3,707
9 xo 3,547
10 upper.io/db 3,474
11 bun 2,890
12 gormt 2,308
13 Storm 2,030
14 prisma-client-go 1,904
15 xorm 1,550
16 reform 1,435
17 gobuffalo/pop 1,403
18 go-doudou 1,347
19 go-sqlbuilder 1,182
20 gocqlx 865
21 REL 728
22 godb 726
23 go-queryset 719
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com