scany
jet
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.
scany
-
Are there any decent ORMs in Golang?
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).
-
How do you handle scanning of db.Rows?
If you want something like sqlx and you already know you're using pgx, a better choice is probably https://github.com/georgysavva/scany since you can use the native interface and get the same key features.
-
Building a Simple TODO App with Gin-gonic in Zerops: A step-by-step Guide
github.com/georgysavva/scany (v1.1.0)
-
SQL Query Strategy for complex structs
I like to use pgxscan from https://github.com/georgysavva/scany
-
Does gorm worth learning?
There's also bqb. We use it in production at our company -- much better than raw SQL. If you couple it with something like scany then you get more of the ORM benefits without the complexity.
jet
-
Open-sourcing SQX, a way to build flexible database models in Go
We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.
https://github.com/go-jet/jet
-
The "preferred" way of mapping SQL results in Golang is honestly, subjectively, awful, how to deal with this
Check go-jet https://github.com/go-jet/jet
- Comparing database/sql, GORM, sqlx, and sqlc
-
goscanql - conveniently reading joined SQL data into structs
https://github.com/go-jet/jet does a similar thing.
-
Does Go, has something similar to Laravel eloquent (ORM) ?
Try go-jet, it generates the models based on the schema, provides typed column names.
-
Any mid sized / big open source code base in golang that makes use of SQL DBs?
I have tried doing that, but was unable to get it to work. I posted about it in a discussion here: https://github.com/go-jet/jet/discussions/215
-
Automatic CRUD code generetor?
Jet might be what you're looking for - https://github.com/go-jet/jet
- How to Work with SQL Databases in Go
-
ORM or no ORM (and which ones)?
Use sql builder https://github.com/go-jet/jet.
- GitHub - go-jet/jet: Type safe SQL builder with code generation and automatic query result data mapping
What are some alternatives?
sqlx - general purpose extensions to golang's database/sql
sqlc - Generate type-safe code from SQL
ngrok - Unified ingress for developers
goqu - SQL builder and query library for golang
godotenv - A Go port of Ruby's dotenv library (Loads environment variables from .env files)
SQLBoiler - Generate a Go ORM tailored to your database schema.
go-pg - Golang ORM with focus on PostgreSQL features and performance
migrate - Database migrations. CLI and Golang library.
xlsx - Go library for reading and writing XLSX files.
pgcapture - A scalable Netflix DBLog implementation for PostgreSQL
usql - Universal command-line interface for SQL databases
go-queryset - 100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.