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.

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.

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.

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.

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.