Guides
Practical tutorials, production patterns, frontend integrations and migrations. Each guide takes a concrete use case and addresses it to the end.
Next.js, SSR & Fullstack#
Artificial intelligence and integrations#
- RAG & pgvector
HNSW vector search, OpenAI/Gemini embeddings and LLM streaming.
- Webhooks & HMAC
Cryptographic reception and verification of outgoing events in Node, Python, Go.
Policies and access control#
- Row-Level Security
3 patterns worked, testing with pg_prove, debug of policies.
- Multi-tenant RBAC
Application roles, org hierarchies, dynamic scopes.
Deployment & performance#
- Preview databases per pull request
A database branch per pull request, created and deleted from CI.
- Multi-region deployment
Logical replication, failover, data residency.
- Performance audit
EXPLAIN ANALYZE, slow queries, index strategy.