stringintech's blog

PostgreSQL Buffer Cache: A Practical Guide

Dec 7, 20247 min read

Before adding indexes or application-level caching to optimize PostgreSQL performance, it's worth understanding how a relational database like...

Understanding JWT Authentication: Spring Security's Architecture and Go Implementation

Nov 30, 20245 min read

After setting up JWT stateless authentication (available here), I wanted to understand what happens under Spring Security's abstractions by...

Optimizing PostgreSQL Mass Deletions with Table Partitioning

Oct 6, 20243 min read

In database management, handling large-scale data operations efficiently is critical. One common challenge is executing mass deletions on large tables...