Drifting Ruby

View

Episodes

Sort

Database Encoding

#264 Oct 18, 2020 pro

In this episode, we look at the encoding and some problems that an older Ruby on Rails application may face when it comes to storing emojis and how to fix them.

database rails

PostgreSQL Hstore

#259 Sep 13, 2020 pro

The hstore data type is very useful in many cases, such as semi-structured data or rows with many attributes.

database rails

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

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.

rails database

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

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

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

ActiveRecord Migrations

#95 Aug 27, 2017 free

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

rails database migration

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

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.