SQL/PostgreSQL/PostGIS/Aurora

• Practical SQL for Data Analysis.
• Schedule jobs with pg_cron on your Amazon RDS for PostgreSQL or Amazon Aurora for PostgreSQL databases.
• Control Runaway Postgres Queries With Statement Timeout.

Node

• 502 errors at AWS ELB with Express:
  • Check your server.keepAliveTimeout.
  • Dealing with Intermittent 502’s between an AWS ALB and Express Web Server.

TinyBird/ClickHouse

• Coming from Postgres? Read this.

Podcast episodes

• Corecursive: The Untold Story of SQLite.

Misc

• What I learned from Software Engineering at Google.