Data Engineering

Creating information from data

Readable EXPLAIN ANALYZE for PostgreSQL

Understanding a query plan is necessary for query optimization, but the raw output can be borderline unreadable!

This tool helps:

https://explain.depesz.com/

A Deep Dive into Database Attacks [Part III]: Why Scarlett Johansson’s Picture Got My Postgres Database to Start Mining Monero

A post-mortem of a fascinating attack against a database honeypot.

https://www.imperva.com/blog/deep-dive-database-attacks-scarlett-johanssons-picture-used-for-crypto-mining-on-postgre-database/

On Rocks and Sand

Storage consumption becomes a major cost-driver when ingesting billions of events a day. Small optimizations can provide for big savings.

https://blog.2ndquadrant.com/on-rocks-and-sand/