When database tables get large, things can slow down significantly. In this episode, we look at a few things which helps keep databases performant and the client side responsive.

N+1 queries can make an application slow. Having queries called within views can also slow down an app as well as making it less extendable.

Using the paper_trail gem, track changes to model records for auditing purposes and rollback changes when required.

This episode covers different tips and tricks around database migration files.

Continuing from Episode #87, we take a deeper dive into virtual columns in Rails 5.1 and use them to parse JSON Data Types with adding indexes to the virtual column.