MirahLabs Engineering Blog

Technical insights, tutorials, and architectures written by our design and backend engineers.

Active Filters: Tag: postgresql Clear All
Artificial Intelligence April 30, 2026

Building Production RAG Pipelines with LangChain and PostgreSQL pgvector

How to build Retrieval-Augmented Generation (RAG) systems that ground LLM responses in private documents using LangChain orchestration and PostgreSQL's pgvector extension.

⏱️ 21 min read Read Article
Software Architecture April 14, 2026

Database Sharding Strategies: When and How to Shard PostgreSQL

Database sharding distributes data across multiple PostgreSQL instances to scale beyond what a single server can handle. Learn horizontal sharding strategies, Citus, and when sharding is actually necessary.

⏱️ 22 min read Read Article
Cloud Computing April 02, 2026

Automated Database Migrations in CI/CD Pipelines

Running schema migrations reliably in automated pipelines requires careful ordering and rollback strategies. This guide covers Alembic, Flyway, and migration safety patterns.

⏱️ 20 min read Read Article