Marcio Cunha

Technical Articles

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

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

Database Table Partitioning: How to Handle Overgrown Databases

Learn how table partitioning solves performance bottlenecks in massive databases. Explore practical strategies, trade-offs, and when to adopt this architecture.

BackendArquitetura•12 min

Database Indexes: How They Work and When They Hurt Performance

Explore the internal mechanics of relational database indexes and learn why excessive or incorrect usage can destroy your system's performance. A comprehensive guide covering B-Trees, table scans, and engineering trade-offs.

BackendArquitetura•12 min

PostgreSQL JSONB: When to Use JSON Data Inside a Relational Database

Discover how PostgreSQL combines the rigidity of relational databases with the flexibility of the JSONB format to handle semi-structured data without sacrificing performance.

BackendArquitetura•12 min

TimescaleDB: When to Transform PostgreSQL into a Time-Series Database

Discover when it is worth using TimescaleDB to manage time-series data on top of PostgreSQL. Evaluate architecture, trade-offs, and practical performance.

DevOpsRedes•12 min

Bastion Host: How to Centralize and Secure SSH Access to Your Servers

Learn how to design and implement a Bastion Host to safeguard cloud infrastructure, centralize SSH traffic with complete auditability, and avoid exposing sensitive ports to the internet.

BackendDevOps•12 min

Consul: Service Discovery, Health Checks, and Distributed Configuration

Learn how HashiCorp Consul solves the challenges of service localization, application health monitoring, and dynamic configuration management in modern distributed architectures.

BackendArquitetura•12 min

Service Discovery: How Applications Find Other Services Automatically

Learn how service discovery solves the dynamic addressing problem in modern microservices architectures, ensuring resilience and high availability.

DevOpsArquitetura•12 min

OpenTelemetry in Practice: How to Unify Metrics, Logs, and Traces

Discover how OpenTelemetry solves modern observability chaos. Connect metrics, logs, and traces into a single framework to debug distributed systems with surgical precision.

DevOpsRedes•12 min

eBPF Explained: How to Observe Linux from Within Without Modifying Your Applications

Discover how eBPF has revolutionized observability and security in the Linux operating system, allowing safe code execution inside the kernel without recompiling or altering applications.

BackendArquitetura•12 min

PostgreSQL Table Partitioning for Billions of Rows

Learn how to scale massive tables in PostgreSQL using declarative partitioning, partition pruning strategies, and optimized write operations in Node.js.