sql
2 articles
SQL Interview Questions for Experienced Engineers, Settled on Two Real Databases
The SQL questions experienced engineers get, run on PostgreSQL 17 and MySQL 8.4 — including a REPEATABLE READ that silently lost an update on one of them.
DatabasesMySQL vs PostgreSQL: The Differences That Actually Matter
A concrete comparison of MySQL and PostgreSQL: MVCC and VACUUM, clustered index vs heap, isolation defaults, transactional DDL, and replication durability.
Databases