This week in #dev (Mar 24, 2023) It’s all about databases in this edition! thoughtbot April 7, 2023 This Week In Dev Active Record PostgreSQL Databases
Query by Duration in Active Record How do you even save a “duration”, let alone query for records by that value? It’s actually easier than you think. Steve Polito June 7, 2022 Rails Databases PostgreSQL Active Record SQL
Testing Techniques: The I/O Table Leverage the power of the I/O table mindset to make your tests as maintainable and readable as possible. Thiago Araújo Silva April 21, 2022 Testing Ruby Databases PostgreSQL
Choosing the right database index type A quick introduction to which database index types are right for the task at hand in Postgresql. Greg Fisher December 16, 2021 PostgreSQL SQL Databases Performance
Recurring Events and PostgreSQL Scheduling, recurring events and relative dates have always been hard. Until now. Jonas Meinerz March 24, 2020 PostgreSQL Dates Interval Rails Ruby Duration Web Databases
Querying the oldest and newest records within an SQL group How to find the oldest or most recent record associated with a particular foreign key. Jack Wilson September 18, 2017 PostgreSQL SQL Databases Rails
Advanced Postgres Performance Tips What do you do when indexes aren’t enough? Caleb Hearth July 29, 2016 PostgreSQL Databases SQL Performance
Reading a Postgres EXPLAIN ANALYZE Query Plan Take a guided tour through a query plan for a “simple” SQL query. Caleb Hearth July 26, 2016 PostgreSQL Databases SQL Performance