MySQL Shorts is a playlist on the MySQL YouTube channel dedicated to short form tutorials that focus on a single feature or solution to a problem.
This video series covers a variety of different topics. For this post, we will sumamrize all the ‘Shorts’ that highlight MySQL Document Store.
Episode 4
In our 4th episode, we showed how you can create a new document collection in MySQL Document Store.
Episode 5
Episode 5 demonstrates how to import JSON documents into a MySQL Document Store collection.
Episode 8
Dataabse indexes can help improve query performance. Episode 8 of MySQL Shorts walks through the steps to create an index on JSON properties.
Episode 11
For Episode 11, we began a group of videos for retrieving documents from MySQL Document Store. We start by talking about retrieving documents using find().
Episode 12
In Episode 12, we talk about the sytax needed to parameterize user input using bind().
Episode 13
We show how to sort documents using the sort() method in Episode 13.
Episode 14
When retrieving JSON documents, you may not want to return all the data in every document. Thankfully, we learn how to use the fields() method in Episode 14.
Episode 15
For Episode 15, we thought it would be helpful to demnstrate how you can paginate JSON documents using the limit() and offset() methods.
Episode 16
Grouping data is important for showing aggregate values. When dealing with JSON documents, we can use the groupBy() method as outlined in Episode 16.
Episode 17
One of the most powerful features of MySQL Document Store is the ability to use raw SQL to retrieve JSON documents. In Episode 17, we show how this can be done.
Episode 73
Doing a case-insensitive search with MySQL Documetn Store can be cumbersome. For Episode 73, we show how to accomplish this with ease.