PostgreSQL

• 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.

React

• Workshop State-management in React with Context and Hooks.

AWS

• Graviton2 instances for Amazon Aurora.

Python

• Python Memory Issues: Tips and Tricks.

Data visualization

• Visualizing the world’s watersheds for #worldwaterday.
• Designers and Statisticians Disagree On What Makes a Good Information Graphic.

Misc

• 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!
• OKRs.