Drifting Ruby

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.

rails database infrastructure

Limiting Text Input

#350 May 22, 2022 pro

User experience is important and there are little things that we can do to help improve this experience. By giving real time feedback on text inputs to approaching limits on fields, the user can modify and update their text accordingly before they submit the form. In this episode, we look at database level, model validations and limiting text input on the client side.

rails validations database stimulusjs

Discussing Race Conditions

#348 May 8, 2022 pro

In this episode, we have a look at some causes of race conditions and go about some ways to troubleshoot and mitigate them.

rails model database background processing

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 rails postgresql query

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 development rails

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

View

Episodes

Sort

Tags

Multiple Databases

Limiting Text Input

Discussing Race Conditions

Materialized Views in PostgreSQL

Seed like a Pro

Database Encoding

PostgreSQL Hstore

Working with Large Data

Simple and Complex Database Migrations

Database, Model and Scopes

Learning Paths

Video Logs new

Blog

Merchandise new

View

Episodes

Sort

Tags

Multiple Databases

Limiting Text Input

Discussing Race Conditions

Materialized Views in PostgreSQL

Seed like a Pro

Database Encoding

PostgreSQL Hstore

Working with Large Data

Simple and Complex Database Migrations

Database, Model and Scopes