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

Reading Optimization in Relational Databases Using Filter Predicate Partial Indexes

Discover how partial indexes based on filtering predicates reduce storage consumption and accelerate queries in relational databases.

ArquiteturaBackend•4 min

Event-Driven Architecture: Ensuring Strict Order in Dynamic Partitions

Learn how to design distributed systems capable of maintaining strict event ordering even when partitions change dynamically. A practical guide on trade-offs, routing, and consistency.

BackendArquitetura•4 min

Conflict Resolution in Distributed Databases Using Causal Version Vectors

Learn how distributed databases handle simultaneous writes across multiple nodes using causal version vectors to guarantee consistency without freezing applications.

IABackend•5 min

Implementation of Sparse Attention Mechanisms in Language Models for Computational Load Reduction

Explore how sparse attention optimizes memory and processing in large language models, enabling efficient handling of long contexts.

BackendArquitetura•4 min

Horizontal Scalability Bottleneck Analysis in Pub/Sub Messaging Systems

Discover the main performance bottlenecks and hidden challenges when scaling publish-subscribe messaging systems. Learn how network limits, partitions, and concurrency impact large-scale data delivery.

BackendArquitetura•4 min

Migrating Monolithic Relational Databases to Distributed Architectures with Hash Key Sharding

Learn how to migrate traditional relational databases to distributed architectures using hash key partitioning to scale high-volume systems without losing consistency.

BackendArquitetura•5 min

Asynchronous Processing of Financial Transactions with Idempotency and Outbox Pattern

Learn how to design highly reliable financial systems by combining asynchronous processing, the Transactional Outbox Pattern, and idempotency keys to prevent duplicate charges and data loss.

IABackend•4 min

Optimizing LLM Code Generation via Structured Prompts and Context Caching

Learn how combining structured prompt engineering and context caching accelerates AI code generation while significantly cutting operational costs.

BackendEngenharia•5 min

Measuring Technical Debt with Cyclomatic Complexity and Hotspots

Learn how to quantify technical debt by combining code complexity metrics and real version control change frequency. Discover how to prioritize refactoring where operational risk is highest.

BackendArquitetura•4 min

Low-Latency Data Synchronization in Event-Driven Architectures with Apache Kafka and Topic Compaction

Learn how to keep databases and microservices synchronized in real time using Apache Kafka and topic compaction to retain the latest state without wasting storage.