March 21, 2022
March 19, 2022
Performance Is Less
Is MySQL performance about “more” or “less”? From the title, you can tell that I’m going to argue that it’s about “less”. Here’s the punchline: zero is maximum performance. Let’s see where this philosophical blog post leads us.
March 09, 2022
Ten Database Crack Commandments
In memory of Biggie Smalls, Andy Pavlo presents his 10 Database Commandments - street rules for database management.
March 08, 2022
Postgres Auditing in 150 lines of SQL
PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL.
Changelog #19: Adding new columns in high-frequency ingestion and more
New columns in high-frequency ingestion, passing parameters between pipes and design improvements
March 03, 2022
How to Prevent SQL Injection Attacks in Node.js
Don’t let SQL injection attacks hurt your business.
Speeding up Go's builtin JSON encoder up to 55% for large arrays of objects
This is an external post of mine. Click here if you are not redirected.
March 02, 2022
Database schema design 101 for relational databases
This database schema design guide walks you through walk through the basics of creating and designing schemas for relational databases.
February 27, 2022
MySQL EXPLAIN ANALYZE
As of MySQL 8.0.18, EXPLAIN ANALYZE is an indispensable tool for understanding query execution because it breaks down the query execution stage of response time by measuring each step of the query execution plan.
The information is illuminating, but the output is not intuitive: it requires practice and some understanding of how MySQL executes queries beyond the table join order shown by traditional EXPLAIN output.
This blog post closely examines three different examples of EXPLAIN ANALYZE output.