- SQL Optimizations in PostgreSQL: IN vs EXISTS vs ANY/ALL vs JOIN.
- Migrating to Aurora: easy except the bill.
- Traveling Salesman problem with PostGIS and pgRouting.
- Don’t let collation versions corrupt your PostgreSQL indexes.
- How to check and resolve Bloat in PostgreSQL.
- Visualizing the world’s watersheds for #worldwaterday.
- Designers and Statisticians Disagree On What Makes a Good Information Graphic.
- Kafka, GDPR and Event Sourcing. While I’m not using Kafka, this article explains an approach for privacy-safe immutable data that could be used for backups that contain data that can be deleted in the future.
- Encrypted db indexes for searching on encrypted data.
- Writing Robust Bash Shell Scripts.
- Troubleshooting Performance Issues Due to Disk and RAM.
- Oportunidades de manera equitativa. A topic that is not often tackled!