Page 1 of 1

What Database for an E-commerce website for a lot of people

Posted: Wed Jul 20, 2016 12:45 am
by julioemc2
What Database is more recommended for a website that store about 1 million of users? SQL or NoSQL Database??

Re: What Database for an E-commerce website for a lot of peo

Posted: Wed Jul 20, 2016 6:38 am
by Celauran
There's a joke in there about NoSQL being web scale. Seriously, though, can't go wrong with Postgres. If your data is going to be structured and normalized, SQL all the way. Lack of joins in NoSQL would be a pain. Of course, it doesn't have to be an either/or proposition. You can always use both and leverage their strengths where appropriate.

Re: What Database for an E-commerce website for a lot of peo

Posted: Wed Jul 20, 2016 3:56 pm
by Christopher
Really, any of the major open source database will work. There are other parts to scaling than the database. And the question is not SQL vs NoSQL, but relational vs key-value store. That depends on the data and how it is read/written. And you don't need to use just one or even two databases -- use a relational one, a key-value store for big data sets, and for something like Redis can also be added to the mix. Plus, many key-value stores allow SQL access.

But I think you are asking the wrong question. I'd ask, what database do we know best to build a website quickly now? Because honestly, scaling out databases is much easier than attracting customers...