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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
julioemc2
Forum Newbie
Posts: 1
Joined: Wed Jul 20, 2016 12:39 am

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

Post by julioemc2 »

What Database is more recommended for a website that store about 1 million of users? SQL or NoSQL Database??
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

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

Post 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.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

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

Post 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...
(#10850)
Post Reply