Using constraints in Postgres and querying LLMs in the terminal.
Some helpful tips to fixing slow database queries before they become a problem.
Clarifying a few possible ways to implement transactional workflows when working with external APIs.
Measure query speed with Postgres’ EXPLAIN ANALYZE.
Some tips on how to do many-to-many SQL queries without a normal join table.
Learn how to strike a balance between flexibility and data integrity with a partial index and validations.
A look at the Postgres array type and good old join tables, each with their advantages and disadvantages.
How do you manage queries when your Rails application isn’t the only thing reading your database?
Highlights of what happened in our #dev channel on Slack this week.
Learn about an unexpected limitation with this API and how to combat it universally.