FA
  • Home
  • Articles
  • Projects
  • Now
  • Bookmarks
  • Changelog

Learning

Thoughts on software engineering, productivity and building things that last — written from continuous learning and real problems I faced throughout my career.

Jun 6, 2026
From 6 Hours to 40 Seconds - How a Database Index Saved a Critical Production Job
A scheduled job that should finish in 4 hours started taking 12 and the culprit was a query with no index scanning a table that never stopped growing. See how a single composite index cut processing time from 6h18min down to 40 seconds, and finally understand what indexes are, when to use them, and why they make such a difference in practice.
Databases
Mar 12, 2026
From Commit to Deployment - CI/CD for an AWS API using GitHub Actions, ECS, and Terraform
Learn how to build a complete CI/CD pipeline for an API on AWS using GitHub Actions, ECS, and Terraform to automate deployments.
Cloud
Mar 2, 2023
Integration Testing with Containers
Learn how to create more reliable integration tests using containers to simulate real environments during test execution.
Testing
Feb 13, 2022
How to Use a Fixture Class with xUnit
Learn how to use Fixtures in xUnit to share context, reduce code duplication, and better organize your automated tests.
Testing
May 29, 2021
Creating Active Classes with EJS
Learn how to create dynamic navigation using active classes in EJS to highlight the current page in Node.js applications.
Web Development
© 2026 Fernando Andrade