Blog Archives

Nifty PostgreSQL Common Table Expression Update

D’ja ever want to target a specific group of rows that meet a condition in a database table, join it with information from other tables, and then perform an update on them in a single command? PostgreSQL’s Common Table Expressions

Posted in PostgreSQL

Fun with race conditions, concurrency, and deadlocks

Sometimes, wheels have to be a little squeaky before we can learn how to properly oil them. Once, a race condition was discovered within our Rails codebase that required a deep dive into concepts of concurrency which I hadn’t yet

Posted in PostgreSQL, Ruby on Rails