What database should my application use?

PostgreSQL, unless you have a specific reason otherwise. It handles relational data, JSON documents, full-text search and vector embeddings for AI features in one engine that scales further than most startups ever need. Exotic databases are for measured problems, not anticipated ones.