Working with Large Data
Play
15:42 CC

Working with Large Data

#201 Aug 4, 2019 free
When database tables get large, things can slow down significantly. In this episode, we look at a few things which helps keep databases performant and the client side responsive.

Virtual Columns in MySQL
Play
4:38 CC

Virtual Columns in MySQL

#87 Jul 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.

Auditing with Paper Trail
Play
6:30 CC

Auditing with Paper Trail

#96 Sep 4, 2017 free
Using the paper_trail gem, track changes to model records for auditing purposes and rollback changes when required.

Virtual Columns with JSON Data Types
Play
7:10 CC

Virtual Columns with JSON Data Types

#88 Jul 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.

Infrastructure Migration
Play
14:09 CC

Infrastructure Migration

#374 Nov 6, 2022 free
For various reasons, we may decide to move our services off of one platform onto another. This could be due to pricing, uptime or other reasons. In this episode, we look at migrating a Ruby on Rails application and database from Heroku to Fly.