What Can We Learn From SQL’s 50 Year Reign? A Story of 2 Turing Awards
The relational data model was introduced in 1970 and has dominated for 50 years. What led to its success? Building on first principles and Bushnell's law.
Trigger Warning! Setting up Database Tracking with Triggers in Postgres
SQL triggers are less common but can be a great solution for certain situations. I'll provide examples for how to use triggers to enforce data integrity and track changes to a database.
Using indexing to optimize database search performance.
Your intuition about indexing might be broken. Here's how to use indexing to optimize database search performance.