Rate Limiting in Postgres
A step-by-step guide describing how to implement rate limiting in Postgres using advisory locks and counters
Valeri KarpovRead guide
Valeri KarpovUsing Postgres as a Key-Value Store with hstore and JSONB
A step-by-step guide describing how to use hstore and JSONB for storing key-value pairs in Postgres
Valeri KarpovRead guide
Using LISTEN and NOTIFY for Pub/Sub in PostgreSQL
A step-by-step guide describing how to use LISTEN and NOTIFY for pub/sub in Postgres
Valeri KarpovRead guide
Caching Layer in Postgres
A step-by-step guide describing how to use materialized views for caching in Postgres
Valeri KarpovRead guide
Graph Queries in Postgres
A step-by-step guide describing how to use ltree and pgRouting for analyzing graph data in Postgres
Valeri KarpovRead guide
Timeseries Data in Postgres
A step-by-step guide describing how to use TimescaleDB for timeseries data in Postgres
Valeri KarpovRead guide
Geospatial Search in Postgres
A step-by-step guide describing how to use PostGIS for geospatial search in Postgres
Valeri KarpovRead guide
Vector Search in Postgres
A step-by-step guide describing how to use pgvector for vector search in Postgres
Valeri KarpovRead guide
Queue System using SKIP LOCKED in OptiTech Postgres
A step-by-step guide describing how to structure a tasks table for use as a task queue in Postgres
Valeri KarpovRead guide
Document Store using JSONB in Postgres
A step-by-step guide describing how to use Postgres as a document store using JSONB
Valeri KarpovRead guide
Full Text Search using tsvector with OptiTech Postgres
A step-by-step guide describing how to implement full text search with tsvector in Postgres
Valeri KarpovRead guide