sqlx

more about golang db sql

数据库连接池增强

1. MaxOpenConns:10
2. MaxIdleConns:0
3. ConnMaxLifetime:10s

MySQL增强

1. 自动增强连接属性: charset=utf8mb4&parseTime=true&loc=Local&timeout=10s&writeTimeout=10s&readTimeout=10s
2. 增强GormDB建表选项: db.Set("gorm:table_options", "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4")
3. MySQLDump

Utilities

1. ExecSQL
2. SplitSqls

Resources

1. Interceptors for database/sql
2. Generate type safe Go from SQL sqlc.dev
3. Golang SQL Database Layer for Layered Architecture. fs02.github.io/rel
4. dbq Zero boilerplate database operations for Go