Simple and Complex Database Migrations
Play
19:14 CC

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.

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.

Searching Multiple Models
Play
19:34 CC

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.

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.

Limiting Text Input
Play
18:41 CC

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.