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.

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.

Database Index Optimization and Migration Maintenance
Play
4:54 CC

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.

UUID in Rails with ActiveUUID
Play
5:11 CC

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.