すにぺっと

[izumin5210]

💪

[izumin5210]

Initialize Redis pool

package main

import (
    "github.com/garyburd/redigo/redis"
)

var redisPool *redis.Pool

func initRedisPool() {
    redisURL := os.Getenv("REDIS_URL")
    if redisURL == "" {
        redisURL = "redis://localhost:6379"
    }
    redisPool = &redis.Pool{
        MaxIdle:     100,
        IdleTimeout: 10 * 60 * time.Second,

        Dial: func() (redis.Conn, error) {
            return redis.DialURL(redisURL)
        },
    }
}

[izumin5210]

RDB connection pooling

db.SetConnMaxLifetime(10 * 60  * time.Second)
db.SetMaxIdleConns(1000)
// db.SetMaxOpenConns(1000) // inifinitie in default

[izumin5210]

Handle errors

package main

var (
    debug = false
)

func handleError(err error) {
    if debug {
        panic(err)
    }
}

[izumin5210]

Disable prepared statement

"%s:%s@tcp(%s:%s)/%s?charset=utf8mb4&parseTime=true&loc=Local&interpolateParams=true",

[agatan]

users := []int{1, 2, 3}
query, args, err := sqlx.In("select * from users where id in (?)", users)
db.Select(&dst, query, args...)