Tag: database

All the articles with the tag "database".

• Deep Dive: PostgreSQL Connection Pooling & HikariCP Internals in Spring Boot

  1 Jun, 2026

  A highly technical masterclass exploring PostgreSQL's process-per-connection architecture, OS socket constraints, HikariCP's lock-free ConcurrentBag internals, and precision performance tuning for Spring Boot.

• DynamoDB Architecture: Deep Dive into Partitioning and Adaptive Capacity

  1 Jan, 2026

  A deep dive into DynamoDB partition structures, request distribution mechanics, and AWS's Adaptive Capacity algorithms for mitigating hot-partition read/write starvation.

• Database Multitenancy Design: Pooled vs. Siloed Architectures

  1 Jan, 2026

  A deep comparative study of SaaS database multitenancy patterns, detailing PostgreSQL Row-Level Security (RLS) policies and dynamic datasource routing in Spring Boot.