GitHub - ankane/strong_migrations: Catch unsafe migrations in development

Learn how PlanetScale uses GitHub Actions and PlanetScale to automate schema changes on our own application.

A while back, I wrote Careful with That Lock, Eugene about an idea for how to check if a database migration is likely to disturb production. That post came about after having an inspiring chat with a colleague about the advantages of transactional migration scripts and the ability to check the postgres system catalog views before committing a transaction. Over the past few weeks, I’ve been experimenting with this idea to test if I can use it to build valuable safety checks for DDL migrations. Kind of like shellcheck, but for database DDL migrations.

Personal Site Andrew Atkinson. PostgreSQL. Ruby on Rails, Elasticsearch, Kubernetes, Vim. Author High Performance PostgreSQL for Rails Pragmatic Programmers

Learn how to dramatically speed up PostgreSQL full-text search by persisting TSVectors and using GIN indexes in Rails apps.

Open Source at Instacart

Last week's article, Super Fast Rails, received many funny reactions. But for some people, that was too much.

Updated 2024-09-17 to reflect updated PgBouncer support for protocol-level prepared statements 🐘 To start, I want to say that I’m appreciative that PgBouncer exists and the work its open source maintainers put into it. I also love working with PostgreSQL, and I’m thankful for the incredible amount of work and improvements that go into it as well. I also think community and industry enthusiasm around Postgres is at an all time high.

Over on BlueSky, Gregory Brown suggested a #20daygemchallenge. Post gems you’ve either used time and time again, or have inspired you in some way, in no particular order. Mohit Sindhwani suggested writing about them at the end, which sounded like a great idea! I’m breaking it into two parts. Here’s my breakdown of my first 10 gems posted: First is HTTParty: https://github.com/jnunemaker/httparty HTTPart is the OG http gem. It’s widely used and dead simple.

The official guide is a great place to start, but there’s more you can do to make life easier. :tangerine: Based on lessons learned in the early...

Many companies start out with a single web application. As the team and codebase grow, things feel less organized and common tasks like booting the...

Despite being a core part of most apps architecture, database schema changes are rarely a core part of code reviews – that needs to change.