Marcio Cunha

Technical Articles

Practical articles, in-depth tutorials, and architectural insights on software engineering, AI, and systems.

All categoriesArquiteturaAutomaçãoBackendCarreiraDevOpsEletrônicaEngenhariaFrontendHardwareIANegóciosProdutividadeRedes
BackendArquitetura•4 min

Snapshot Isolation versus Read Committed: How Database Engines Handle Concurrency

Understand the architectural differences between Snapshot Isolation and Read Committed in relational databases and discover how these choices affect data consistency under high concurrency.

BackendArquitetura•5 min

The Transactional Inbox Pattern for Idempotent Event Consumers

Learn how the Transactional Inbox pattern solves the challenge of processing events exactly once in microservices, ensuring data consistency and high resilience in distributed systems.

BackendArquitetura•6 min

Difference Between BRIN and B-Tree Indexes in PostgreSQL for Chronological Data

Learn how to choose between BRIN and B-Tree indexes in PostgreSQL to optimize tables with massive volumes of chronologically ordered data, saving gigabytes of disk space.

BackendArquitetura•5 min

IETF Idempotency Keys in HTTP Middleware: Ensuring Consistency in Distributed Systems

Learn how to implement the IETF specification draft for idempotency keys in REST APIs. Guard against duplicate requests and network failures using modern HTTP middleware.

BackendArquitetura•5 min

Difference between Parquet and ORC in data compression and reading

Learn how Apache Parquet and Apache ORC columnar formats handle compression and data reading efficiency in modern analytical data lakes.

BackendArquitetura•4 min

Circuit Breaker in Asynchronous PHP with Swoole for Microservices

Learn how to implement the Circuit Breaker pattern in the PHP ecosystem using Swoole to ensure high resilience and prevent cascading failures in modern microservices.

BackendArquitetura•5 min

Difference Between Hash and List Partitioning in Relational Databases

Understand the practical differences between hash and list partitioning in relational databases. Learn when to apply each strategy to optimize queries and scale large data volumes.

BackendArquitetura•4 min

Eventual Consistency in Practice: Implementing the Read-Your-Own-Writes Pattern

Learn how to ensure users immediately see their own updates in distributed databases with eventual consistency, overcoming the hurdles of data replication across geographically separated nodes.

RedesArquitetura•5 min

How the BGP EVPN Protocol Unifies the Control Plane for VXLAN Networks in Data Centers

Learn how combining the BGP EVPN protocol with VXLAN technology eliminates traditional data center network bottlenecks, ensuring high scalability and efficient packet delivery.

BackendArquitetura•5 min

Difference Between B-Tree and GiST Indexes in PostgreSQL for Spatial and Range Searches

Discover when to use B-Tree and GiST indexes in PostgreSQL to optimize spatial queries, ranges, and multidimensional data without compromising database performance.