databases - Abrarqasim Blogs

pg_stat_statements: The Four Queries I Run Before Adding an Index

The four pg_stat_statements queries I run before touching an index, why sorting by total time beats mean time, and what the extension can never tell…

Rayyan | August 20, 2026 | 10 min

Databases

Postgres Stored Procedures in PHP: What plx Actually Fixes

plx lets you write a Postgres stored procedure in PHP, Go or Ruby that transpiles to plpgsql. I tried it, and here is where the…

Rayyan | August 17, 2026 | 10 min

Databases

Valkey vs Redis in 2026: The Fork I Actually Migrated To

Valkey vs Redis in 2026: what the license fork actually changed, why the migration is a one-line container swap, and when I would still stay…

Rayyan | July 27, 2026 | 7 min

Backend

Postgres Full-Text Search in 2026: When I Reach For It Over Elasticsearch

Real experience with Postgres full-text search in 2026: when tsvector and GIN indexes beat Elasticsearch, and the queries I actually ship in production.

Rayyan | July 8, 2026 | 9 min