Comment by Meble on "Building Scalable Databases: Are Relational Databases Compatible with Large Scale Websites?"

suppressed@unknown.org (Meble) — Fri, 12 Mar 2010 18:59:41 GMT

I agree with Addy. btw. very interesting text about relational databases vs. hi-websites

Posted by: Meble

Comment by Addy on "Building Scalable Databases: Are Relational Databases Compatible with Large Scale Websites?"

suppressed@unknown.org (Addy) — Wed, 10 Mar 2010 22:51:02 GMT

While most sql vs nosql discussions typically focus on the functional and architectural differences, there are additional considerations which are just as important: - Stability/maturity: The commercial SQL products (ORA/MSSQL) have been around for decades and are rock solid. Most NOSQL codebases have sprung up in the last 1-2 years and haven't been widely adopted. SQL WINS. - Documentation/knowledge: The leading SQL products are well documented and have established best practices for development and operations. NOSQL is still a nascent technology with most implementations being one-offs or at least heavily customized, which implies a longer learning curve and increased risk. SQL WINS. - Developer availability/cost: SQL is a core competency for a large chunk of the overall developer population. NOSQL knowledge is still rare, both at the individual and the organizational levels. This means that developers with the required skillsets are hard to find, hard to qualify and hard to retain. SQL WINS. - Cost: Commercial SQL licenses aren't cheap, especially in datacenter configurations. The per-server or per-core licensing expenses for a large scale deployment can easily reach into the millions, which makes SQL much less attractive than the NOSQL alternatives which are typically OSS (=free). SQL = EPIC FAIL on this one. NOSQL WINS. - 3rd party vendor ecosystem. SQL products have a 20 year head start with a rich ecosystem of vendors offering supplemental SQL solutions for managability, backup/restore, monitoring, development, etc. SQL WINS.

Posted by: Addy

Dare Obasanjo aka Carnage4Life - Comments on Building Scalable Databases: Are Relational Databases Compatible with Large Scale Websites?

Comment by Meble on "Building Scalable Databases: Are Relational Databases Compatible with Large Scale Websites?"

Comment by Addy on "Building Scalable Databases: Are Relational Databases Compatible with Large Scale Websites?"