golang-database-library-orm-example
enthistory
| golang-database-library-orm-example | enthistory | |
|---|---|---|
| 4 | 1 | |
| 21 | 40 | |
| - | - | |
| 0.0 | 7.2 | |
| about 1 year ago | 28 days ago | |
| Go | Go | |
| - | MIT License |
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.
golang-database-library-orm-example
-
Golang Database Library and Orm Examples
What I found is sqlx and sqlc are excellent for hand-rolled queries, but is poor for dynamic queries which a query builder library/orm might suite better. If there are many eager-loading table relationships, I found that orms tend to be much better. Of course these are entirely my personal opinion. I dove into more details on how each libraries and orms fares against those operations in the posts. It is also accompanied with reproducible repo at https://github.com/gmhafiz/golang-database-library-orm-example
-
Dynamic sql code during runtime.
I discussed approaches using different libraries and ORMs at https://www.gmhafiz.com/blog/golang-database-library-orm-example-dynamic-list/. Though I just realised the example for squirrel is missing. Check out the code examples though
-
Scanning joined SQL rows into nested go struct
I show scans for a many to many relationship between two tables. https://github.com/gmhafiz/golang-database-library-orm-example/blob/master/db/sqlc/manyToMany.go
-
What kind of things have you ran with go:generate?
I made repo that compares between different libraries and orms including sqlx, sqlc, sqlboiler, gorm, and ent https://github.com/gmhafiz/golang-database-library-orm-example
enthistory
What are some alternatives?
bob - SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite
entviz - Visualize Ent schemas with beautiful ERDs on atlasgo.cloud
optional - Optional is a library of optional Go types
edit-twitter-example-app - an example app imitating twitter with an edit button
ent - An entity framework for Go
go-enumer - ✨ Go-Enums with Magic ✨
gorm-seeder - Gorm seeder package
sqltrace - A low-code intrusion library that provides SQL tracing capabilities, suitable for any relational database (Sqlite3, MySQL, Oracle, SQL Server, PostgreSQL, TiDB, TDengine, etc.) and ORM libraries for various relational database (gorm, xorm, sqlx, ent, etc.)
sqlc - Generate type-safe code from SQL
jwt-auth-api - JWT Authentication Implementation in Golang
go8 - Go + Postgres + Chi Router + sqlx + ent + authentication + testing + opentelemetry Starter Kit for API Development