DEV Community

Go Time

Focusing in on PostgreSQL

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?

Discuss on Changelog News

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

Notes and Links

  • 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:

Episode source