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.

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.

Materialized Views in PostgreSQL
Play
13:43 CC

Materialized Views in PostgreSQL

#324 Nov 21, 2021 pro
Using Scenic, you can bring the power of SQL views to your Rails application without having to switch your schema format to SQL. Scenic provides a convention for versioning views that keeps your migration history consistent and reversible and avoids having to duplicate SQL strings across migrations.

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.