Talk in English - US at PHP Tek 2026
View Slides: https://scott.keck-warren.com/blog/2026/advanced-sql-the-features-youve-been-ignoring-but-shouldnt-phpjs-tek-2026/
Short URL: https://joind.in/talk/0ded8
(QR-Code (opens in new window))
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.
Comments
Please login to leave a comment
Another great Scott Keck-Warren Production full of useful information and clear examples!
Great comprehensive overview on PHP's history with SQL. Went over many SQL features that were formally only known to enterprise DBAs.
Great, concise overview of all the SQL functionality you’ve afraid to use & unsure when to broach it.
Funny how often technology moves over a decade in one direction, only to pivot back the other way. ORMs hide so much of SQL's powerful features. Scott did a great job talking about some of the deeper parts of SQL that used to be pretty common, like stored procedures and views.