- Published on
Building a type-safe, schema-agnostic search system in PostgreSQL: EAV indexing with ltree over dynamic schemas, hybrid retrieval (pgvector + pg_trgm) across structured and unstructured data, a Pydantic query DSL used by PydanticAI agents for structured, type-safe query generation.