Watch video #1 (Bitwise operations) here: https://youtu.be/Kf8SWqljM18 Watch video #2 (storing as JSON) here: https://www.youtube.com/watch?v=cDzrY-QW4Ck To learn more about PlanetScale, head to https://planetscale.com/youtube! 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

To learn more about PlanetScale, head to https://planetscale.com/youtube! You don't *always* need joins, and sometimes it's faster to not use them 🤯 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

To learn more about PlanetScale, head to https://planetscale.com/youtube! Follow along as I help debug a database related SaaS problem over Twitter. PlanetScale Insights: https://planetscale.com/features/insights ----- 00:00 Getting rekt 03:20 A demo of the problem 04:35 Rows read, via EXPLAIN 05:16 Rows read, via EXPLAIN ANALYZE 06:15 Rows read, via innodb_rows_read 07:11 Adding an index 08:28 Calling my shot ----- 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

Storing feature flags as JSON in MySQL. This is the second of three videos, exploring different ways to store flags. The first video: https://www.youtube.com/watch?v=Kf8SWqljM18 More about JSON in MySQL: https://www.youtube.com/watch?v=QZBxgX2OWbI --- 00:00 JSON in MySQL 01:02 Find users with the flag 02:51 Finding users without the flag 04:25 Adding or removing a flag 07:19 Using JSON object keys 09:37 Using a JSON array 12:17 Comparison of objects and arrays --- To learn more about PlanetScale, head to https://planetscale.com/youtube! 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

This video is a tutorial on using bits & bitmasks for storing feature flags in a database. It involves compressing all data into a single integer column and using bitmasks to activate specific features. While this method is technically interesting and efficient for compact data storage, it can be convoluted to understand there's no way to properly index it. In future videos, alternative techniques such as storing the flags in a JSON column or a separate table using a many-to-many relationship will be discussed. You can watch the second video (storing as JSON) here: https://www.youtube.com/watch?v=cDzrY-QW4Ck. To learn more about PlanetScale, head to https://planetscale.com/youtube! ------ 00:00 Feature flags 00:57 Bits and bytes 02:42 Bitwise operators 03:58 Querying with bitmasks 09:06 Adding and removing flags 13:17 Finding unused flags and indexing 14:54 Pros and cons ------ 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

To learn more about PlanetScale, head to https://planetscale.com/youtube! MySQL has first party support for JSON documents and it can be a really nice escape hatch from the rigid structure of a relational database. To learn more, check out some videos from our free course: * https://planetscale.com/learn/courses/mysql-for-developers/schema/json * https://planetscale.com/learn/courses/mysql-for-developers/indexes/indexing-json-columns Or some of our blog posts: * https://planetscale.com/blog/indexing-json-in-mysql * https://planetscale.com/blog/the-mysql-json-data-type The SQL for the products table shown in the video is available here: https://www.digitalocean.com/community/tutorials/working-with-json-in-mysql. --------------- 00:00 MySQL supports NoSQL 01:15 When to use JSON 04:20 JSON versus TEXT columns 07:00 Efficient JSON storage 07:45 Creating JSON objects with SQL 11:00 Extracting JSON from the document 14:40 JSON arrays 17:20 Querying on JSON columns 18:50 Query an array's items 19:40 Indexing JSON documents 22:48 Generated columns 26:00 JSON blob storage 27:09 Making JSON invisible 29:00 Updating documents in place --------------- 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

Functional indexes and generated columns are a way to index things that aren't traditionally indexable, like JSON columns, data normalizations, or calculations. To learn more about PlanetScale, head to https://planetscale.com/youtube! Case insensitive searching video: https://www.youtube.com/watch?v=ML24GRzXF9w Generated hash indexes video: https://www.youtube.com/watch?v=5aezDBaNfcc -------- 00:00 Functional indexes and generated columns 00:45 What is a functional index? 02:11 Example 1: Indexing the end of a string 05:05 Example 2: Case sensitive indexing 07:37 Example 3: Indexing a TEXT or BLOB 09:54 Example 4: Indexing a date part 12:57 Example 4.5: Indexing a date part, semantically 16:25 Example 5: Grouping by functional index 19:08 Example 6: Calculating age 21:09 Example 7: Data normalization 24:04 Example 8: Indexing a raw calculation 26:23 Example 9: Combining multiple statuses, and composite indexes 31:02 Example 10: Indexing JSON parts -------- 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

To learn more about PlanetScale, head to https://planetscale.com/youtube! Using generated columns to stop freeloaders from signing up! Good idea, bad idea? Who's to say. Is it awesome: absolutely. Check out our other video on generated columns: https://www.youtube.com/watch?v=5aezDBaNfcc ------ 00:00 Infinite email addresses 01:18 Users table example 01:58 How to prevent it 03:00 Coming up with the formula 04:45 The generated column 06:23 Enforcing uniqueness 07:41 Is this a good idea? ------ 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

To learn more about PlanetScale, head to https://planetscale.com/youtube! You can find TablePlus at https://tableplus.com. ---- 00:00 It's called TablePlus 01:32 TablePlus website 02:45 Features 03:55 My TablePlus 06:53 Themes 07:23 DBngin 08:43 Stay tuned for more ---- 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale

To learn more about PlanetScale, head to https://planetscale.com/youtube! You can find TablePlus at https://tableplus.com. 💬 Follow PlanetScale on social media • Twitter: https://twitter.com/planetscale • Discord: https://discord.gg/pDUGAAFEJx • TikTok: https://www.tiktok.com/@planetscale • Twitch: https://www.twitch.tv/planetscale • LinkedIn: https://www.linkedin.com/company/planetscale