This section is all about practical examples that combine everything we've learned up to this point.
1:03
Generating an MD5 hash of a column is a way to create a very fast equality lookup on very large values.
6:52
If you need to enforce a uniqueness constraint across multiple columns you can use an generated MD5 column to keep that index very very small.
6:12
There are several different ways to store flags, or true/false values, in MySQL. In this video we'll look at how to store multiple values in a single integer column.
9:40
When storing a boolean value, it's sometimes nice to know when that specific boolean was turned on. Using a timestamp as a boolean can accomplish both of those purposes in one column.
3:53
Sometimes your application needs to claim rows and process them. There are several ways to do this, but in this video we'll look at one that doesn't require locking.
5:53
Calculating statistics over historical data can be inefficient as data grows. Using a summary table is one way to work around that.
5:27
Extremely wide tables with lots of big columns can be expensive to query and maintain. In some circumstances it makes sense to put some of those columns in a secondary table.
6:08
Pagination is a feature that almost every web developer has had to implement. Offset / limit is the most common form of pagination, and we'll cover the benefits and drawbacks of this method.
8:35
Cursor pagination is another way to paginate records that covers some of the shortfalls of offset / limit, but introduces a few drawbacks of its own.
7:28
We're not done with pagination yet! There is one modification of the offset / limit style pagination that can help keep it performant as you reach deeper pages.
6:14
Using simple latitude and longitude columns, we'll look at how we can use approximate conditions to quickly perform geographic searches.
7:17
You made it! You finished the course!
1:25
Feedback or questions? Reach out to our team at education@planetscale.com.