Using MySQL to stop freeloaders (in only 8 minutes)

Опубликовано: 18 Октябрь 2024
на канале: PlanetScale
36,479
1.7k

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:    • Faster database indexes (straight fro...  

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