Which is the most cost effective database for search to build mvp?

Question

I am building a social a commerce app with search feature for my app and I may have thousands.  Which database would be most cost effective. I am building flutter + firebase right now.

Heard Supabase is awesome, but also Mongo DB with a backend is obviously a future option. Also still considering SQL Db with may be GraphQL. Anyone with experience here?

Diogo Quintas · Accepted Answer

If you are building a fully fledged text search, i'd strongly recommend a search engine.

You have off the shelf products like: Algolia, Constructor.io, etc

Or if you want more homegrown solutions: elasticsearch, Atlas Search (mongDB atlas)

I've built search experiences based on elasticsearch and atlas search - quite easy to get a functional, usable search but starts to get complicated once you want to optimise it

Claudiu Cogalniceanu · Answer

I’m using Postgres, and it works quite well. I have more than 50000 entries

Which is the most cost effective database for search to build mvp?

Replies