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.

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.

Seed like a Pro
Play
19:05 CC

Seed like a Pro

#284 Feb 21, 2021 pro
Seeding your database is often an overlooked part of development and it has a lot of benefits that can help uncover issues within your application. However, maintaining the seeds.rb can be difficult and things can get out of hand quickly. In this episode, learn how to manage and maintain the seeds file.

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.

Simple and Complex Database Migrations
Play
19:14 CC

Simple and Complex Database Migrations

#173 Feb 17, 2019 pro
In this episode, we look at database migrations and different ways to generate the schema.