News for hackers. Stuff that matters.
Re:Mongo DB is web scale by EasyCompany on Thursday August 26, 2010 @06:38PM (#1637369)
Totally agree, as i am a beginner programmer, i am totally confused which database to use and when, particularly when. I have read up on so many, so many blog posts that contradict each other, i have looked into coudb, cassandra, mysql, neo4j, hbase, persevere and a few more. I have just decided to learn each one well and judge as my knowledge grows, so i have started with mysql and couchdb.
Re:Mongo DB is web scale by moron4hire on Thursday August 26, 2010 @09:08PM (#1637713)
Personally, I love Postgres; I've been burned by MySQL in the past. Here's the thing, you will be infinitely more employable if you know SQL well, and you'll easily retrain from one RDBMS to another if a better SQL database comes along.
Re:Mongo DB is web scale by alecco on Friday August 27, 2010 @09:17AM (#1638703)
Don't forget MonetDB (performance) and SQLite (simplicity) if your project is mostly reading.
Re:Mongo DB is web scale by Devilboy on Thursday August 26, 2010 @09:08PM (#1637714)
You should try a RBDMS too :P
Re:Mongo DB is web scale by artsrc on Friday August 27, 2010 @07:45AM (#1638514)
There aren't any relational databases doing any thing useful, only non relational databases, like those based on SQL.
Re:Mongo DB is web scale by silentbicycle on Friday August 27, 2010 @11:06AM (#1639013)
To clarify this comment a bit: The conventional RDBMSs people refer to as relational databases (Oracle, Postgres, MySQL, SQLite, etc.) shoot for compatibility with the SQL standard, which diverges from the relational model. For example, you can have duplicate rows in a table, which doesn't make any sense in the (set-based) relational model. SQL is not "purely" relational.

If you read Chris Date's books (I recommend starting with _An Introduction to Database Systems_), he really hammers this point.

There are people who hate SQL because it's too relational, and there are people who hate SQL because it's not relational enough.