Exactly my advice to everyone: If you're in doubt, choose PostgreSQL. It's a strong SQL database. Yet, you can store, index and search documents in a jsonb column. You have built-in full-text search. You have PostGIS. And you can scale and shard using Citus.
