SQL (MySQL) vs NoSQL (CouchDB) [closed]

by

Here’s a quote from a recent blog post from Dare Obasanjo.

SQL databases are like automatic
transmission and NoSQL databases are
like manual transmission. Once you
switch to NoSQL, you become
responsible for a lot of work that the
system takes care of automatically in
a relational database system. Similar
to what happens when you pick manual
over automatic transmission. Secondly,
NoSQL allows you to eke more
performance out of the system by
eliminating a lot of integrity checks
done by relational databases from the
database tier. Again, this is similar
to how you can get more performance
out of your car by driving a manual
transmission versus an automatic
transmission vehicle.

However the most notable similarity is
that just like most of us can’t really
take advantage of the benefits of a
manual transmission vehicle because
the majority of our driving is sitting
in traffic on the way to and from
work, there is a similar harsh reality
in that most sites aren’t at Google or
Facebook’s scale and thus have no need
for a Bigtable or Cassandra.

To which I can add only that switching from MySQL, where you have at least some experience, to CouchDB, where you have no experience, means you will have to deal with a whole new set of problems and learn different concepts and best practices. While by itself this is wonderful (I am playing at home with MongoDB and like it a lot), it will be a cost that you need to calculate when estimating the work for that project, and brings unknown risks while promising unknown benefits. It will be very hard to judge if you can do the project on time and with the quality you want/need to be successful, if it’s based on a technology you don’t know.

Now, if you have on the team an expert in the NoSQL field, then by all means take a good look at it. But without any expertise on the team, don’t jump on NoSQL for a new commercial project.

Update: Just to throw some gasoline in the open fire you started, here are two interesting articles from people on the SQL camp. 🙂

I Can’t Wait for NoSQL to Die (original article is gone, here’s a copy)

Fighting The NoSQL Mindset, Though This Isn’t an anti-NoSQL Piece
Update: Well here is an interesting article about NoSQL
Making Sense of NoSQL

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. In SQL Server how to get the count of child if both parent and child are available [closed]
  3. Delete the entire content of all table in a Database [closed]
  4. MySQL select 10 random rows from 600K rows fast
  5. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  6. Get a list of dates between two dates
  7. Calculate a running total in MySQL
  8. Simulate lag function in MySQL
  9. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  10. Get record counts for all tables in MySQL database
  11. How to get the difference in years from two different dates?
  12. How do I check if a column is empty or null in MySQL?
  13. Use MySQL spatial extensions to select points inside circle
  14. INSERT … ON DUPLICATE KEY (do nothing)
  15. MySQL create stored procedure syntax with delimiter
  16. Mysql Convert Column to row (Pivot table )
  17. Merge two tables in one SQL query and make the date values unique
  18. How to find non-existing data from another Table by JOIN?
  19. MySQL/SQL: Update with correlated subquery from the updated table itself
  20. Mysql insert random datetime in a given datetime range
  21. Greatest value of multiple columns with column name?
  22. MySQL UPDATE syntax with multiple tables using WHERE clause
  23. Are SELECT type queries the only type that can be nested?
  24. Strings as Primary Keys in MYSQL Database [closed]
  25. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  26. mysql – Dynamic column alias
  27. Select data from “show tables” MySQL query
  28. What is dynamic SQL?
  29. INSERT INTO Table from multiple tables
  30. mySQL query to search all tables within a database for a string?

Leave a Comment