Focusing in on PostgreSQL
July 9, 2020, 2 p.m. (4 years, 5 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?
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
changelog2019ORchangelog2020. 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:
Special guest Johan Brandhorst gave a talk about Postgres and Go at GopherCon EU:
Something missing or broken? PRs welcome!
No comments have been posted yet, be the first one to comment.
Similar Podcasts
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.
Join the discussionChangelog++ members support our work, get closer to the metal, and make the ads disappear. Jo...
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.
Join the discussionChangelog++ members support our work, get closer to the metal, and make the ad...
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.
Join the discussionChangelog++ members support our work, get closer to the metal, and make the ads disappear. Join today!Sponsors:Linode – Our clou...
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.
Join the discussionChangelog++ members support our work, get closer to the metal, and make the ads disappear. Join today!Sponso...
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.
Join the discussionChangelog++ members support our work, get closer to the metal, ...
Mentioned Topics
Database Management
Data Management is a process that comprises all disciplines related to managing data as a resource. It applies to both physical and digital data, however, in this day and age most database management refers to later. Database management has become more vi...
SQL
The domain-specific language SQL is used top map relational data in a relational database management system. The language is also used for streaming and fetching of the data from the database.
...
Database Design
...
PostgreSQL
PostgreSQL, also known as Postgres, is a relational database management system (RDBMS) that is free and open-source. The software is widely popular for storing relation data for web-base applications. PostgreSQL emphasise extensibility and technical stand...
Go
Go (Golang) is a programming language that is statically typed and compiled. The language was designed by Robert Griesemer, Rob Pike, and Ken Thompson at Google. Go compiles down to machine code which makes the language really fast. On top of that, the la...
Similar Tutorials
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
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
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...