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.

Multiple Databases
Play
12:33 CC

Multiple Databases

#353 Jun 12, 2022 pro
As an application grows in popularity and usage you'll need to scale the application to support your new users and their data. One way in which your application may need to scale is on the database level. In this episode, we look at reading from a replica database while writing to a primary database. We also look at structuring our application top support multiple databases; each containing their own schema.

Database Transactions
Play
9:47 CC

Database Transactions

#377 Nov 27, 2022 pro
Transactions are protective blocks where SQL statements are only permanent if they can all succeed as one atomic action. In this episode, we explore ActiveRecord Transactions and how to use them.

MySQL FULLTEXT Search
Play
18:59 CC

MySQL FULLTEXT Search

#386 Jan 29, 2023 pro
In this episode, we look at implementing full-text search in MySQL. Using some of the built in functions of MySQL, we are able query tables and add weighted results.