Database Encoding
Play
10:32 CC

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.

PostgreSQL Hstore
Play
12:28 CC

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.

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.

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.

Database, Model and Scopes
Play
15:36 CC

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.