Use PostgreSQL for the production capstone

The Course uses PostgreSQL with full-text search and pgvector for its production capstone. This keeps structured queries, metadata filters, lexical retrieval, vector retrieval, and hybrid ranking in one inspectable system; specialized search or vector databases remain valid alternatives when their scale or operational strengths justify the added infrastructure.