Store 8 feature flags in 1 integer (Bitwise operations in MySQL) скачать в хорошем качестве

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