For the last several years, MySQL has been my primary database.

PostgreSQL came up from time to time, but I never had a real reason to dive deeply into it.

That changed when I started working on a new project — an AI assistant. The project required PostgreSQL, JSONB, Full-Text Search, and, most importantly, pgvector for vector search.

After spending some time working with PostgreSQL more seriously, I realized that it is not just “another SQL database that is more or less like MySQL”.