GORM
sqlc
Our great sponsors
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
GORM
- How do you handle nil/null values correctly
-
ORM or no ORM (and which ones)?
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
-
Web Development JWT Practices
For more information on Gorm's operation of MySQL, please refer to Gorm
- High Performance Web Framework Tasting-Database Operations
-
Build REST API with Go Fiber and PlanetScale - Part 1
To access PlanetScale, we can use ORM from Go called Gorm, and since the PlanetScale database is built on top Vitess (MySQL), install the MySQL driver as well.
-
Dapper-like ORM, Mapping
Just my opinion, so it it for what it’s worth to you, but I haven’t been especially impressed with the ORM landscape in Go. I have tinkered with a few ORMs - I gave gorm a serious whirl a few months ago, but ended up ditching it in less than a month. If time is on your side, I’d strongly encourage you to experiment with what the standard library’s database/sql package has to offer.
-
Looking for some PgSQL infos
If it is to low-level for your liking maybe take a look at sqlx or even gorm.
-
using go-sqlmock with sqlite
Sigh... If you're using gorm V2, you need to pass a dialector to gorm.Open as the first parameter. See the V2 example here: https://github.com/go-gorm/gorm/issues/3565
-
Which framework and ORM should we choose?
Framework - Gin ORM - Gorm
sqlc
-
You might not need an ORM
Relatedly, I'd like to recommend people check out sqlc. It's a Go project, although it does technically support codegen to other languages.
With sqlc, you write queries and get fully typed functions you can call. It's not completely perfect, but it's pretty good.
-
Building web-based SaaS with Go as a solo entrepreneur. What should I be aware of?
How do you find it compared to using something like https://github.com/kyleconroy/sqlc ? curious which enables faster "developer velocity"
-
How to Work with SQL Databases in Go
Honestly I think the code generation approach using sqlc is better these days than manually writing all of the DB code yourself or an ORM like GORM. You are writing the queries, and it's handling the boilerplate that you'd do anyway, and it's not using introspection but rather providing type safe functions and structures for your queries.
-
ORM or no ORM (and which ones)?
I highly recommend sqlc. You just write normal SQL DDL/DML and you get statically typed Go functions and data structures.
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.
-
Ask HN: ORM or Native SQL?
Likely depends on the language. With Go I like using https://sqlc.dev/ - it generates Go-code from a SQL script. You get the benefits of static typing for parameters and return types + it removes much of the boilerplate involved in using plain SQL. And you still get the full expressiveness of SQL. I think this is a middle ground between SQL and ORM.
-
Anything like sqlc for Rust?
I've been using Go's sqlc for a while now at work, for working with Postgres. Got to admit it's been great, better than any ORM or query builder I've used so far in any other language.
-
Best Orm that uses Graphql and Postgres
sqlc website: https://sqlc.dev
What are some alternatives?
ent - An entity framework for Go
Xorm
SQLBoiler - Generate a Go ORM tailored to your database schema.
go-pg - Golang ORM with focus on PostgreSQL features and performance
sqlx - general purpose extensions to golang's database/sql
beego orm
pgx - PostgreSQL driver and toolkit for Go
gorp - Go Relational Persistence - an ORM-ish library for Go
xorm - xorm是一个简单而强大的Go语言ORM库,通过它可以使数据库操作非常简便。本库是基于原版xorm的定制增强版本,为xorm提供类似ibatis的配置文件及动态SQL支持,支持AcitveRecord操作
bun - Incredibly fast JavaScript runtime, bundler, transpiler and package manager – all in one.
upper.io/db - Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.