Drifting Ruby

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

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

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

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

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

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

Searching Multiple Models

#370 Oct 9, 2022 pro

In this episode, we look at creating a simple and maintainable way to search multiple models. As our application grows and the needs change, other avenues can be explored, but it's important to not prematurely optimize things before they're actually required.

rails search database model

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

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

Downloading Cloud Database

#368 Sep 25, 2022 pro

Sometimes we need to pull down our staging database that is hosted in the cloud. This can be a tedious task as there could be many blockers that add complications in pulling down this data.

rails database cloud

View

Episodes

Sort

Tags

Database, Model and Scopes

Simple and Complex Database Migrations

Seed like a Pro

PostgreSQL Hstore

Multiple Databases

Discussing Race Conditions

Searching Multiple Models

Materialized Views in PostgreSQL

Limiting Text Input

Downloading Cloud Database

Learning Paths

Video Logs new

Blog

Merchandise

Forums new

View

Episodes

Sort

Tags

Database, Model and Scopes

Simple and Complex Database Migrations

Seed like a Pro

PostgreSQL Hstore

Multiple Databases

Discussing Race Conditions

Searching Multiple Models

Materialized Views in PostgreSQL

Limiting Text Input

Downloading Cloud Database