Databases · By wshobson

Covers distance metrics, index types and tuning for similarity search on vector databases, from semantic search to RAG retrieval.

wshobson/agents

Designs event stores for event-sourced systems: requirements, a comparison of EventStoreDB, PostgreSQL, Kafka, DynamoDB and Marten, and stream and versioning practices.

wshobson/agents

Covers building read models and materialized views from event streams in CQRS and event-sourced systems, including live, catch-up, persistent and inline projections.

wshobson/agents

Build retrieval-augmented generation systems: pick a vector database and embedding model, choose retrieval and reranking strategies, and start from a LangGraph pipeline.

wshobson/agents

Tune vector indexes for latency, recall and memory: pick an index type by data size, adjust HNSW parameters and choose a quantization level.

wshobson/agents

A skill your agent uses when designing or reviewing a PostgreSQL-specific schema.

wshobson/agents