Spot over-engineering everything, actually. That's why it's called "over"

As I always say "just use Postgres". Hasn't failed me so far.

MongoDB got replaced by JSONB. Dedicated vector DBs got replaced by pgvector. For Postgres, it's just another index.