Andrew Atkinson

PostgreSQL 15 shipped in late 2022 (See PostgreSQL 15 Release Notes), including interesting new features like SQL MERGE. I wanted to give them a try.

PostgreSQL DevOps

Hello. I recently tweeted asking the following question.

PostgreSQL Rails

Conferences PostgreSQL DevOps

In this post you will be presented with 2 truths and a lie related to PostgreSQL and Ruby on Rails.

Ruby on Rails PostgreSQL Open Source

We just upgraded to 3.0 of PgHero (Check the CHANGELOG.md). I learned about the availability of the new version from the Postgres.fm 🎧 podcast.

Ruby on Rails PostgreSQL Open Source

This past week I had the privilege of presenting at and attending RailsConf 2022 Conference in Portland, OR. My presentation was titled Puny to Powerful PostgreSQL Rails Apps. This post will focus mainly on my presentation experience.

Ruby on Rails PostgreSQL Open Source Conferences Events

Recently I had the opportunity to travel to NYC to present at PGConf NYC 2021.

PostgreSQL Open Source Conferences Events

In the StaffEng book, there is a section called Work on What Matters.

Productivity

Duplicate rows can happen when a database unique constraint is missing. Once found, finding and deleting duplicates in a fast way is necessary before the constraint can be added.

PostgreSQL Databases Tips

By using UNLOGGED tables, we can insert rows at a higher rate when compared with a logged table (the default). But there’s a trade-off.

PostgreSQL Databases Tips