61: I'm Not Telling You My Birthday

About this Episode

"Send me an email every year for my birthday" is an easy thing for a human to understand but it can be deceptively tricky to do with computers. Also tricky for (some) computers: SELECT * FROM. Wait... what?

• DATE_PART or EXTRACT
• Triggers
• Using EXPLAIN
• Using ANALYZE
• VACUUM
• Derek's (mostly useless) Approximately Gem

Support The Bike Shed