Category: Databases

Working with data: PostgreSQL schema design, indexes, query optimization, transactions, caching in Redis and fighting the N+1 problem.

Databases 14 July 2026 12 min read

PostgreSQL Full-Text Search vs Elasticsearch: When Built-in Search Is Enough in 2026

A deep dive into PostgreSQL Full-Text Search vs Elasticsearch: architecture, performance, Go and Laravel examples, and a decision matrix for real-world projects.

Databases 6 July 2026 14 min read

PostgreSQL Performance Optimization: Indexes, Partitioning, and EXPLAIN ANALYZE in Practice

A practical guide to PostgreSQL optimization for mid-level and senior developers: analyzing slow queries, indexing strategies, table partitioning, and configuration tuning.

Databases 14 March 2026 11 min read

PostgreSQL: indexes that actually work

How to read a query plan, choose an index type and avoid creating useless indexes that only slow down writes.

Databases 1 December 2025 9 min read

Caching in Redis in practice: strategies and invalidation

Caching patterns, fighting the cache stampede and proper invalidation — so that the cache speeds up the system rather than breaking its correctness.