Fixing PG::DuplicateAlias When Filters and Scopes Join the Same Table
How a custom Rails filtering framework and a model scope both joining the same table causes PostgreSQL's DuplicateAlias error, and how aliasing filter joins fixes it systemically.
Fixing Devise Trackable Row-Lock Contention with JWT
How Devise's :trackable module causes row-lock contention with JWT authentication, and how to fix it with manual tracking and a heartbeat endpoint.