Log in to watch this talk
You need to be logged in to access this video. If you don't have an account, purchase a virtual pass for the latest php[tek] conference to get access to the full video library.
Advanced SQL: The Features You’ve Been Ignoring (But Shouldn’t)
While your app sleeps, your database dreams... of being useful. This talk pulls back the curtain on powerful, often-ignored features hiding inside every relational database: triggers that act like observers, stored procedures that encapsulate logic, views that simplify access, and replication that scales without tears. We’ll walk through real examples, why these tools matter, and how you can start using them without falling into vendor traps or overengineering doom.
Scott Keck-Warren