golang-database-library-orm-example
postgres
Our great sponsors
golang-database-library-orm-example | postgres | |
---|---|---|
4 | 1 | |
21 | 199 | |
- | 5.0% | |
0.0 | 7.4 | |
about 1 year ago | 25 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
postgres
-
GOlang URL shortener service using postgres, redis, bulma
It does not use external libraries except the gorm for postgres database and minimal redis module redigo.
What are some alternatives?
bob - SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite
urlsh - Golang URL shortener and bookmarker service with UI, API, Cache, Hits Counter and forwarder using postgres and redis in backend, bulma in frontend. Think of it as self hosting ready url shortener.
optional - Optional is a library of optional Go types
GORM - The fantastic ORM library for Golang, aims to be developer friendly
ent - An entity framework for Go
redigo - Go client for Redis
gorm-seeder - Gorm seeder package
go - The Go programming language
sqlc - Generate type-safe code from SQL
igor - igor is an abstraction layer for PostgreSQL with a gorm like syntax.
jwt-auth-api - JWT Authentication Implementation in Golang