Drifting Ruby

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.

rails database mysql search

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.

rails activerecord database

Infrastructure Migration

#374 Nov 6, 2022 free

For various reasons, we may decide to move our services off of one platform onto another. This could be due to pricing, uptime or other reasons. In this episode, we look at migrating a Ruby on Rails application and database from Heroku to Fly.

rails infrastructure database migration

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

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

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

View

Episodes

Sort

Tags

MySQL FULLTEXT Search

Database Transactions

Infrastructure Migration

Searching Multiple Models

Downloading Cloud Database

Multiple Databases

Limiting Text Input

Discussing Race Conditions

Materialized Views in PostgreSQL

Seed like a Pro

Learning Paths

Video Logs new

Blog

Merchandise

Forums new

View

Episodes

Sort

Tags

MySQL FULLTEXT Search

Database Transactions

Infrastructure Migration

Searching Multiple Models

Downloading Cloud Database

Multiple Databases

Limiting Text Input

Discussing Race Conditions

Materialized Views in PostgreSQL

Seed like a Pro