reform VS GORM

However, you can use something like this https://github.com/go-reform/reform to help you with, I will call it automating the code writing. But I have always opted to one of the supported drivers and written a queries myself using for example this https://github.com/go-sql-driver/mysql.

db operation from apps by gorm

If you want some "developer experience", look at https://gorm.io/

"gorm.io/driver/postgres" "gorm.io/gorm" gocache "zgo.at/zcache" ) var cacheHandler *gocache.Cache type StoreDB struct { CreationMutex sync.Mutex cache *gocache.Cache } type Context struct { Schema string } func (s *StoreDB) CreateDBHandler(ctx *Context) *gorm.DB { // Maybe we could use a better mechanism to do this. s.CreationMutex.Lock() defer s.CreationMutex.Unlock() // Double check before moving to Creation precedures if db, found := s.cache.Touch(ctx.Schema, gocache.DefaultExpiration); found { return db.(*gorm.DB) } dsn := fmt.Sprintf("host=%s user=%s password=%s dbname=%s sslmode=disable search_path=%s", getEnv("DB_HOST", "db"), getEnv("DB_USER", "postgres"), getEnv("DB_PASSWORD", "example"), getEnv("DB_NAME", "some-database"), ctx.Schema) db, err := gorm.Open(postgres.Open(dsn), &gorm.Config{}) if err != nil { panic(err) } cacheHandler.Set(ctx.Schema, db, gocache.DefaultExpiration) return db } func (s *StoreDB) GetDBHandler(ctx *Context) *gorm.DB { db, found := s.cache.Touch(ctx.Schema, gocache.DefaultExpiration) if found { return db.(*gorm.DB) } return s.CreateDBHandler(ctx) } func initManager() *StoreDB { cacheHandler = gocache.New(10*time.Minute, 10*time.Minute) cacheHandler.OnEvicted(func(s string, i interface{}) { // https://github.com/go-gorm/gorm/issues/3145 sql, err := i.(*gorm.DB).DB() if err != nil { panic(err) } sql.Close() }) return &StoreDB{ cache: cacheHandler, } }

I agree with /u/in_the_cloud that in principle it would be nicer to push that all the way into GORM itself. Perhaps it's time for a major revision branch there. There is an issue discussing generics but it seems like the beginning of a beginning of a conversation about it. It'll definitely be some work; I can virtually guarantee several passes will be necessary before a 2.x release will be possible. If nothing else, there's the initial conversion which just propagates the generics around, and then a second pass when staring at the end result shows the new ways it can be used to simplify things.

I use https://gorm.io with mariadb