Focusing in on PostgreSQL

July 9, 2020, 2 p.m. (2 years, 4 months ago)
0 Comments

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

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

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:

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

Something missing or broken? PRs welcome!

Login to Add New Comment
No comments have been posted yet, be the first one to comment.
Similar Podcasts
It's Go Time! It's Go Time!
In this inaugural show Erik, Brian, and Carlisia kick things off by sharing some recent Go news that caught their attention, what to expect from this show, ways to get in touch, and more. Discuss on Changelog News Changelog++ members support our work, get closer to the metal, and make the ads disa...
Sarah Adams on Test2Doc and Women Who Go Sarah Adams on Test2Doc and Women Who Go
On this show we’re joined by Sarah Adams. We talk about creating safe spaces for women to get started in the Go community, about Women Who Go, and take a deep dive into her Test2Doc open source project. Discuss on Changelog News Changelog++ members support our work, get closer to the metal, and ma...
State of Go Survey and Go at Heroku State of Go Survey and Go at Heroku
Ed Muller from Heroku join us to discuss his State of Go survey, vendoring and versioning, the Heroku Go Buildpack, how they use Go at Heroku, and more. Discuss on Changelog News Changelog++ members support our work, get closer to the metal, and make the ads disappear. Join today! Sponsors ...
Jessie Frazelle on Maintaining Open Source, Docker, dotfiles Jessie Frazelle on Maintaining Open Source, Docker, dotfiles
Jessie Frazelle joins us this week to talk about being an open source maintainer, Docker’s pull request acceptance workflow, dotfiles, getting started with public speaking. Discuss on Changelog News Changelog++ members support our work, get closer to the metal, and make the ads disappear. Join tod...
Matt Holt on CaddyServer, the ACME Protocol, TLS Matt Holt on CaddyServer, the ACME Protocol, TLS
This episode wins the contest for the most protocols discussed. Matt Holt joined the show to to talk about TLS, Let’s Encrypt, the ACME protocol, CaddyServer, and a host of other important information security issues. Discuss on Changelog News Changelog++ members support our work, get closer to th...
Similar Tutorials
How to Create & Setup Dokku Applications & Databases
How to Create & Setup Dokku Applications & Databases
As I have mentioned many of times before, Dokku rocks! Dokku is a free and open-source project that helps you build and manage the lifecycle of your applications. Dokku does is it by leveraging the power of Docker and Heroku Buildpacks. It's perfect for solo developers or small teams ...
Fix PostgreSQL error: Stale postmaster.pid file on macOS
Fix PostgreSQL error: Stale postmaster.pid file on macOS
Sometimes when you mac shuts down unexpectedly while running a PostgreSQL database it can result in the following error: Stale postmaster.pid file. The data directory contains an old postmaster.pid file. FATAL: lock file “postmaster.pid” already exists Fix PostgreSQL error: Stale pos...
How to Install & Configure Strapi with PostgreSQL
How to Install & Configure Strapi with PostgreSQL
If you have used Strapi before, you know how fast and easy it is to install with the "--quickstart" flag that includes SQLite as a default database. However, if you want to use a database like MongoDB or PostgreSQL the install and configuration requires a little bit more att...