#Which stack should I use?

1 messages · Page 1 of 1 (latest)

brave folio
#

Hi, if I want to build an app similar to Nextdoor using Next.js, what database would you recommend? I’ve come across solutions like Firebase or Sanity, but I’m not sure what stack to go with. I come from php world and I’m used to ORMs like Doctrine. I also have a some experience with Sequelize and Mongoose

The goal is to keep things simple, develop quickly, and avoid a tech stack that becomes too expensive to scale. The app will include things like nested categories, KYC, document storage, etc.

What do you use in production for apps like this that are reliable and scalable?

Thanks! 🙏

mystic spearBOT
#
Post created!

🔎 This post has been indexed in our web forum and will be seen by search engines so other users can find it outside Discord

🕵️ Your user profile is private by default and won't be visible to users outside Discord, if you want to be visible in the web forum you can add the "Public Profile" role in id:customize

✅ You can mark a message as the answer for your post with Right click -> Apps -> Mark Solution
(if you don't see the option, try refreshing Discord with Ctrl + R)

brave folio
#

Which stack should I use?

obtuse saffron
#

But it really depends on your data. If you want unstructured document-like data, pick NoSQL, if you need structured data, use Postgres

brave folio
#

Thank you for your suggestion. Since I need geolocation for my jobs, do you think it's a good idea to use Elasticsearch? Or should I use multiple databases for different features? Maybe Supabase with PostgreSQL and PostGIS would be better? But what about scaling? Would Elasticsearch make things simpler?

obtuse saffron
#

I would mix the two

brave folio
#

I also think NoSQL might be simpler, especially since the app is likely to evolve quickly. On the other hand, I’m afraid it might limit me later on. I'm not really sure, since I’ve never had the chance to compare both in depth

obtuse saffron
#

The app will include things like nested categories
Sounds like NoSQL to me

#

I really dont know what your data domain looks like, so I can't comment further

#

Spend some time actually considering both before you pick, otherwise you'll be spending time migrating from one to the other down the line.

brave folio
#

Thank you! What do you mean by mixing both?

obtuse saffron
#

Use both Postgres and Elasticsearch

#

You'd need to ask someone else, but I'm not familiar with elasticsearch being used as the primary database

#

But I've also never used it so 🤷‍♂️

wicked frost
#

You do not use elasticsearch as a primary database imo