Generic database interface sql.DB

GORM provides the method DB which returns a generic database interface *sql.DB from the current *gorm.DB

sqlDB, err := db.DB()


sqlDB.Ping()


sqlDB.Close()


sqlDB.Stats()

NOTE If the underlying database connection is not a *sql.DB, like in a transaction, it will returns error

Connection Pool

sqlDB, err := db.DB()


sqlDB.SetMaxIdleConns(10)


sqlDB.SetMaxOpenConns(100)


sqlDB.SetConnMaxLifetime(time.Hour)