Store 8 feature flags in 1 integer (Bitwise operations in MySQL)

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:    • Storing feature flags as JSON (with indexing)  .

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:   / planetscale  
• Discord:   / discord  
• TikTok:   / planetscale  
• Twitch:   / planetscale  
• LinkedIn:   / planetscale