This practical Go database/sql tutorial covers 39 lessons spanning core concepts like connection pools, transactions, and isolation levels, compares ORMs (GORM, Bun, XORM) and lightweight tools (sqlx, sqlc, Squirrel), and addresses logging, migration, testing, and production practices using modernc.org/sqlite for runnable examples.
Go’s database/sql package can deadlock when a Scan holds a read lock, a cancelled context triggers Close, and Columns attempts another read lock, but the new closingMutex introduced in Go’s source replaces the generic sync.RWMutex to allow reads during pending writes, preventing the deadlock.
This article explains how Go’s standard database/sql package uses a driver registration mechanism to integrate third‑party MySQL drivers, detailing the global driver map, registration function, init process, and a complete example showing how to define, register, and use a custom MySQL driver.
This article explains Go’s built‑in database/sql package, detailing the Open function’s signature and workflow, the DB struct’s key fields, and how classic design patterns such as Singleton, Factory, Proxy, and Strategy are applied to achieve safe, flexible, and high‑performance database connection pooling.
This article details the development of a Go MySQL driver that fully supports Seata's AT distributed‑transaction mode, covering background, design decisions, driver specifics, initialization steps, code examples, and how it lowers the barrier for Go microservices to use distributed transactions.
