postgreSQL | Atomic Spin

PostgreSQL

3 Lessons From Nearly Blowing Up a Production Database

Struggling with Postgres production database bloat? Here's how I diagnosed TOAST bloat, tuned autovacuum, and fixed a runaway storage issue.

Developer Tools

Try These 4 Apps to Visualize Redis Stream Data

Having a good visualization tool means having clear insights into your application state. Visualize Redis stream data with 4 different apps.

Development Practices

Using Postgres LISTEN/NOTIFY + Server-Sent Events for Real-Time Web Apps

If your web app uses a Postgres database, you're already most of the way to live updates in the browser. Here's how to use LISTEN/NOTIFY.

PostgreSQL

Improve Your Dev Experience with Dockerized Postgres

Working on a project with a local development environment and a Postgres database? Running Postgres in Docker can make life easier.

PostgreSQL

How to Partition Consecutive Rows with PostgreSQL

You can use PostgreSQL's window function capabilities to partition data over a specific number of consecutive rows preceding any given row.

Developer Tools

Migrate Your Heroku PostgreSQL Database to AWS RDS

Over time, Heroku add-ons may not fit your needs. I’ll share how I was able to successfully complete a migration from Heroku PostgreSQL to RDS.

PostgreSQL

A Simple Search Engine in Postgres

I had a lot of fun researching and experimenting with Postgres full-text search capabilities. Follow along as I build a simple keyword search with Postgres.

Developer Tools

Ingest Inconsistent Tables Quickly Using Postgres’s JSON Columns

Here’s how you can leverage JSON columns to help smooth out the distinctions between tables you are ingesting into a PostgreSQL database.

Prisma

A Simple REST API with Prisma, Part 1: The Setup

Let's create a simple REST API with Prisma. Part one of this two-part series will cover how to get a Prisma schema from your Postgresql database.

Platforms & Languages

Solving the Gaps and Islands Problem in Postgres

I hope this is a straightforward way for you to understand the Gaps and Islands problem so you can apply it in your next project.

Extracurricular Activities

Self-Hosted PostgreSQL with SSL in Docker

Here I share all the configuration details needed to self-host PostgreSQL running in a Docker container, with a valid SSL certificate from Let's Encrypt.

Development

PostgreSQL Isolation Levels: How much money is actually in Piper’s bank account?

PostgreSQL transaction isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable Isolation) illustrated with banking transactions.