Databases

Most applications have to work with at least one type of database. SQL databases are common enough that the Go standard library offers a unified way to connect and use them. This chapter shows some of the patterns you can use to work with the standard library implementation of the SQL package.

Many databases offer nonstandard extensions, in terms of both functionality and query language. Even if you use the standard library to interface with a database, you should always check the vendor-specific database driver to understand potential limitations, implementation differences, and the supported SQL dialect.

Here, it might be useful to mention NoSQL databases. The Go standard library does not offer a NoSQL database package. This is because, unlike SQL, most NoSQL databases have nonstandard query languages that are purpose-built for the specific database. NoSQL databases built for specific workloads perform much better than a general-purpose SQL database. If you are using...