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.
