Choosing a database is hard. They each have their pros and cons, and without much experience it is hard to determine which is the best fit for your project. In this episode Johan Brandhorst joins us to talk about Postgres. When is it a good fit? How well does it scale? What libraries exist in Go for using Postgres?

Leave us a comment

Changelog++ members save 2 minutes on this episode because they made the ads disappear. Join today!

Sponsors:

• Linode – Our cloud of choice and the home of Changelog.com. Deploy a fast, efficient, native SSD cloud server for only $5/month. Get 4 months free using the code changelog2019 OR changelog2020. To learn more and get started head to linode.com/changelog.
• The Brave Browser – Browse the web up to 8x faster than Chrome and Safari, block ads and trackers by default, and reward your favorite creators with the built-in Basic Attention Token. Download Brave for free and give tipping a try right here on changelog.com.
• Fastly – Our bandwidth partner. Fastly powers fast, secure, and scalable digital experiences. Move beyond your content delivery network to their powerful edge cloud platform. Learn more at fastly.com.

Featuring:

• Johan Brandhorst – Twitter, GitHub, Website
• Jon Calhoun – Twitter, GitHub, Website
• Mat Ryer – Twitter, GitHub, LinkedIn, Website
• Johnny Boursiquot – Twitter, GitHub, Website

Show Notes:

• Ingres - the project that Postgres evolved from.
• jackc/pgx - Go Postgres library mentioned on the show.
• lib/pq - Go Postgres library mentioned on the show.
• Masterminds/squirrel - SQL query builder mentioned by Johan as his unpopular opinion.
• ory/dockertest - A tool for running tests with docker containers; useful for spinning up Postgres instances for testing.

Panelist Jon Calhoun also wrote two blog posts covering topics mentioned on the show:

• Why do we import SQL drivers with the underscore (_)
• What is SQL injection?

Special guest Johan Brandhorst gave a talk about Postgres and Go at GopherCon EU:

• A Journey to Postgres Productivity with Go

Something missing or broken? time-137.md">PRs welcome!