gophersql
Database/SQL talk for Denver Gophers. Drivers and code examples are on the package page.
Recommended Drivers
Examples
Import syntax, the empty _
import
Building the connection string
Knowing the parameterization scheme
Exec
versus Query
Scanning into pointers
Closing rows
The scanner interface
Cross-platform issues
Talk struct
with the database!
Issues
Zero-initialization
Default INSERT
values and dealing with NULL
values with pointers or Null types.
Closing rows and duplicate connections with :memory:
The case of the disappearing table.
Scanning into an interface
Strings are scanned as []byte
, resulting in unexpected json
output.
No interface for connections and transactions
Build one to test instances requiring a connection
Packages
A list of popular projects
And my own: Aspect - cross-dialect query construction, schema declarations, and talking a variety of types with the database (including structs and slices)