}

Articles tagged "postgresql"

Page 1 of 2

python fastapi postgresql jwt docker
17 min readIntermediate

FastAPI Tutorial 2026: Build a Production REST API with PostgreSQL, JWT Auth, and Docker

FastAPI tutorial 2026: build a production REST API with async PostgreSQL (SQLAlchemy 2.0), JWT authentication, Pydantic v2 validation, Alembic migrations, and Docker Compose deployment.

postgresql database sql search devops
15 min readIntermediate

PostgreSQL Full-Text Search Tutorial 2026: tsvector, GIN Indexes, Ranking, and Autocomplete

PostgreSQL full-text search tutorial 2026: tsvector, tsquery, GIN indexes for sub-50ms searches on 1M rows, ts_rank relevance ranking, multi-language stemming, autocomplete with pg_trgm, and when to use Elasticsearch instead.

postgresql databases performance sql indexes
10 min readIntermediate

PostgreSQL EXPLAIN ANALYZE: Fix Slow Queries with Proper Indexes (2026)

Master PostgreSQL EXPLAIN ANALYZE in 2026. Read query plans, create B-tree, partial, GIN, and expression indexes. Real case study: 30-second query reduced to 50ms step by step.

python fastapi api postgresql
3 min readIntermediate

FastAPI Tutorial 2026: Build a REST API with PostgreSQL, Auth, and Async

FastAPI tutorial 2026: build a production REST API with PostgreSQL, JWT authentication, and async endpoints. Complete guide with Pydantic models, testing, and Uvicorn deployment.

postgresql backup restore pg_dump pg_basebackup
7 min readIntermediate

PostgreSQL Backup and Restore: pg_dump, pg_basebackup and Point-in-Time Recovery (2026)

Complete PostgreSQL backup and restore guide: pg_dump for logical backups, pg_basebackup for physical backups, WAL archiving, and Point-in-Time Recovery (PITR) in 2026.

rag langchain pgvector postgresql python
7 min readIntermediate

RAG with Python, LangChain and PostgreSQL pgvector as Vector Store (2026)

Build a RAG pipeline with Python, LangChain, and PostgreSQL pgvector. Load documents, create embeddings, store in pgvector, and query with an LLM. Complete working example.

python ai postgresql pgvector rag
4 min readIntermediate

Build a RAG System from Scratch with Python and pgvector (No LangChain, 2026)

Build a RAG chatbot from scratch using Python and PostgreSQL pgvector — no LangChain needed. Covers chunking, embeddings with Ollama, vector search, and a working chat-with-docs example.

python postgresql pip
4 min readBeginner

SOLVED: error: pg_config executable not found (psycopg2 pip install)

Fix "error: pg_config executable not found" when pip install psycopg2 fails. Install postgresql-dev headers or use psycopg2-binary instead.

docker compose docker containers devops postgresql
7 min readBeginner

Docker Compose Getting Started Guide (2026): Complete Tutorial

Docker Compose v2 getting started guide 2026. Install Compose, compose.yml structure, multi-container app with Postgres and Redis, environment variables, depends_on, and essential commands.

PostgreSQL Database UTF-8 Encoding SQL
6 min readIntermediate

PostgreSQL: Create Database with UTF-8 Encoding [Complete Guide]

Create PostgreSQL database with UTF8 encoding. Fix template encoding errors. Guide covers locale, collation, and encoding conversion.