Episodes

Simple and Complex Database Migrations

Episode #173 2-17-2019 pro

In this episode, we look at database migrations and different ways to generate the schema.

Database, Model and Scopes

Episode #150 9-9-2018 pro

In this episode, we take a look at some tips and tricks around the database schema and model scopes.

Improving Partial Loading Performance

Episode #145 8-5-2018 free

N+1 queries can make an application slow. Having queries called within views can also slow down an app as well as making it less extendable.

Auditing with Paper Trail

Episode #96 9-4-2017 free

Using the paper_trail gem, track changes to model records for auditing purposes and rollback changes when required.

ActiveRecord Migrations

Episode #95 8-27-2017 free

This episode covers different tips and tricks around database migration files.

Virtual Columns with JSON Data Types

Episode #88 7-9-2017 free

Continuing from Episode #87, we take a deeper dive into virtual columns in Rails 5.1 and use them to parse JSON Data Types with adding indexes to the virtual column.

Virtual Columns in MySQL

Episode #87 7-2-2017 free

In Ruby on Rails 5.1.0, generated virtual column support was added for MySQL and MariaDB. Using generated and stored columns can leverage heavy calculations to the SQL side.

Database Index Optimization and Migration Maintenance

Episode #53 11-6-2016 free

Adding indexes to your databases can increase the SQL search performance on your tables. As your application grows, migration files can become out of hand, use squasher to squish them down to a single file.

UUID in Rails with ActiveUUID

Episode #23 3-2-2016 free

Some cases require non-auto incrementing primary keys as well as multiple master writes without id conflicts. With ActiveUUID, we can configure our table's primary key with confidence without added complexity.