Drifting Ruby

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.

rails database

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.

rails database audit

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.

rails database 6.0

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.

rails database json

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.

rails infrastructure database migration

UUID in Rails with ActiveUUID

#23 Mar 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.

rails uuid activerecord database

Improving Partial Loading Performance

#145 Aug 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.

rails performance database

ActiveRecord Migrations

#95 Aug 27, 2017 free

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

rails database migration

Database Index Optimization and Migration Maintenance

#53 Nov 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.

rails database performance

Database, Model and Scopes

#150 Sep 9, 2018 pro

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

rails model database

View

Episodes

Sort

Tags

Virtual Columns in MySQL

Auditing with Paper Trail

Working with Large Data

Virtual Columns with JSON Data Types

Infrastructure Migration

UUID in Rails with ActiveUUID

Improving Partial Loading Performance

ActiveRecord Migrations

Database Index Optimization and Migration Maintenance

Database, Model and Scopes

Learning Paths

Video Logs new

Blog

Merchandise

Forums new

View

Episodes

Sort

Tags

Virtual Columns in MySQL

Auditing with Paper Trail

Working with Large Data

Virtual Columns with JSON Data Types

Infrastructure Migration

UUID in Rails with ActiveUUID

Improving Partial Loading Performance

ActiveRecord Migrations

Database Index Optimization and Migration Maintenance

Database, Model and Scopes