Drifting Ruby

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

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.