PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Fri Apr 28, 2017 7:06 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Wed Jul 20, 2016 12:45 am 
Offline
Forum Newbie

Joined: Wed Jul 20, 2016 12:39 am
Posts: 1
What Database is more recommended for a website that store about 1 million of users? SQL or NoSQL Database??


Top
 Profile  
 
PostPosted: Wed Jul 20, 2016 6:38 am 
Offline
Moderator
User avatar

Joined: Tue Nov 09, 2010 3:39 pm
Posts: 6229
Location: Montreal, Canada
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.

_________________
Supported PHP versions No longer supported versions


Top
 Profile  
 
PostPosted: Wed Jul 20, 2016 3:56 pm 
Offline
Site Administrator
User avatar

Joined: Wed Aug 25, 2004 7:54 pm
Posts: 13385
Location: New York, NY, US
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)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group