Category
Working with data: PostgreSQL schema design, indexes, query optimization, transactions, caching in Redis and fighting the N+1 problem.
An in-depth guide to advanced PostgreSQL features in Laravel: window functions, CTEs, recursive queries, full-text search, and Redis caching.
A deep dive into PostgreSQL Logical Replication: replication slot architecture, Change Data Capture via pgoutput and Debezium, microservices integration, and CDC implementation in Go.
A deep dive into Elasticsearch as a full-featured analytics engine in 2026: aggregations, index design, comparison with ClickHouse and PostgreSQL, Kibana integration, and Go/PHP pipelines.
A deep dive into MySQL's built-in Full-Text Search: index types, ngram configuration for Cyrillic, SQL examples, relevance scoring, and an honest comparison with Elasticsearch for backend developers.
A practical guide to setting up a fault-tolerant MySQL cluster using Group Replication with automatic failover, monitoring, and MySQL Router integration — no third-party tools required.
A complete guide to pgvector: installation, embedding generation, HNSW indexes, hybrid search, and comparison with Elasticsearch. Practical examples in Go, PHP, and Laravel.