8 ms·

MongoDB is the New MySQL

74 points by sogrady 15y ago

marshray 15y ago
Great! Now what's the next PostgreSQL?
- hasanove 15y ago
  CouchDB
  - MatthewPhillips 15y ago
    Isn't Couch already out of style?
- aeden 15y ago
  PostgreSQL is the next PostgreSQL.
  - chrisjsmith 15y ago
    The irony of this is that it's actually quite easy to build a document store on top of PostgreSQL that performs very well indeed. I tried it. I used a similar approach to the one described at [1]. You get the advantage of years of experience (never underestimate this!), MVCC, transactions, consistency and replication as well. (yes I know it doesn't "perform" as well as the other NoSQL stores but performance is not without tradeoffs [2]) [1] http://bret.appspot.com/entry/how-friendfeed-uses-mysql http://bret.appspot.com/entry/how-friendfeed-uses-mysql [2] http://www.caradvice.com.au/wp-content/uploads/2006/12/FerrariCrash4.jpg http://www.caradvice.com.au/wp-content/uploads/2006/12/Ferra...
    - dikbrouwer 15y ago
      To me, the biggest advantage of MongoDB is autosharding. If you read the friendfeed article, you'll see that they also have to deal with 'eventual consistency' on the indexes.
      - chrisjsmith 15y ago
        I'd say that's not necessarily an advantage. Sharding is incredibly complicated to get right considering all factors such as balancing and recovery. I'd rather partition the data based on function onto distinct clusters, you know like eBay do. You can update the indexes in a transaction too, so that's not necessarily an issue. MySQL has problems with this due to locking but the MVCC implementation in PostgreSQL allows much better concurrency.
someone13 15y ago
Not sure if this is just me, but the site loads partway and then sits forever* and never loads any further. Anyone else have this problem? * = For a certain value of "forever"
- dgrant 15y ago
  Yeah the site blows, I still can't connect.
  - sogrady 15y ago
    it's not either one of you, it's our setup. that and the fact that i neglected to directly cache the page before it hit, so our server is about to burst into flames. soon as i can get back into to shut things down and cache everything it'll go back to normal. ish. apologies in the meantime.
- SigmundA 15y ago
  Just give it time, it's eventually consistent.
oldgregg 15y ago
http://webcache.googleusercontent.com/search?q=cache:redmonk.com/sogrady/2011/07/06/mongodb-is-the-new-mysql/&hl=en&strip=1 http://webcache.googleusercontent.com/search?q=cache:redmonk...
VilleSalonen 15y ago
Most of these Point seem to ring a bit hollow. MongoDB gets criticism: therefore it's the new MySQL? Or because they both use open source licenses? I'm not saying that MongoDB isn't growing. I just think that it's way early to pronounce it as a replacement for MySQL. These kinds of provocative but false titles belong in the cheap tabloids, not on the front page of Hacker News.
- sogrady 15y ago
  [disclosure: i'm the author] i tried to explicitly make the point that MongoDB is not a replacement for MySQL, it is rather following a similar path from a licensing, usage and market reaction standpoint. and that mongo's course within the nosql world may follow the pattern we saw mysql track w/in the relational database market. from this comment, it doesn't seem like i was successful on that score.
  - VilleSalonen 15y ago
    Apparently I managed to overlook your statement about it not being a replacement. It's just that the title of the post seems to be in contradiction with that. MongoDB is indeed an interesting software and it's on a promising start. I'll be interested to see where it's going. Maybe one day the title of your post will be true.
sigzero 15y ago
Wow, I don't think you want that comparison.
- sogrady 15y ago
  depends on your metric, does it not?
  - sigzero 15y ago
    MySQL has always (despite its usage) the red-headed step child of databases.
mikey_p 15y ago
The thing that I've found that makes MongoDB super easy for folks migrating from SQL is that it is easy to add indexes to arbitrary fields, and they work the same way as they do in MySQL. It's just a b-tree and if you can setup MySQL indexes, then you can build smart, well indexed structures and systems with Mongo. Being able to do this without jumping all the way into writing map-reduce bits, but saving the time of setting up a rigid schema, makes it easy to see why MongoDB is so popular. To me, that is why MongoDB is the new MySQL.
- deleted 15y ago
  [deleted]
- St-Clock 15y ago
  I am confused. How hard is it to create an index in MySQL? I don't have much experience with MySQL, but with PostgreSQL, it is very easy. In addition, there are some "advanced" features that may not be provided by MongoDB: you can choose your index type, rebuild the index, update the stats that will help the query optimizer decide if the index should be used at all, etc.
  - j_baker 15y ago
    It's not that the actual command you enter to create an index is hard. It's just that when you have a table with millions or billions of rows, you have to figure out how to create the index without stopping the world for hours.
    - St-Clock 15y ago
      With postgresql, create index does not block read, only write. You can also use the CONCURRENTLY parameter and writes/updates won't be blocked, but the index creation takes longer (the db has to wait until no transaction potentially involving the index has stopped). Not sure what other strategies exist to reliably build an index. http://www.postgresql.org/docs/current/static/sql-createindex.html http://www.postgresql.org/docs/current/static/sql-createinde...
  - 15y ago
KaeseEs 15y ago
I would tend to say that MongoDB is the new MySQL in a different way - it's the default not-really-suitable hammer that the current generation of amateur software carpenters are using to turn every problem into a nail. It's not super elegant, but most of the time it works, sort of. On the bright side, one could say that at least half of the PHP/MySQL tag team has been improved significantly by being replaced with Python/MongoDB, as theological issues aside, Python is a lot less broken than PHP :)
- sogrady 15y ago
  "I would tend to say that MongoDB is the new MySQL in a different way - it's the default not-really-suitable hammer that the current generation of amateur software carpenters are using to turn every problem into a nail. It's not super elegant, but most of the time it works, sort of." that's an excellent - and much shorter - way of putting it.
- superuser2 15y ago
  For what projects (besides enterprise -> Oracle, embedded -> SQLite and Windows -> SQL server) would you consider MySQL inappropriate? What would you use instead? I see people angry about not using the "right tool for the job" all the time with regard to web applications. What other tools do you feel aren't used when they should be?
  - darrenkopp 15y ago
    I have a client synchronization utility that uses MongoDB instead of SQLite because it's lightweight but I have all ease of use of MongoDB. Install it as a windows service with our installer and we are good to go. And in this context, MySql would be way to heavy.
    - stephth 15y ago
      I have a client synchronization utility that uses MongoDB instead of SQLite because it's lightweight but I have all ease of use of MongoDB. Install it as a windows service with our installer and we are good to go. And in this context, MySql would be way to heavy. Your comment is confusing. Can you please explain: You replaced sqlite with mongodb, as an embedded database? How can mongodb run without a server? Are you saying mongodb is more lightweight than sqlite? If so I find this very surprising, can you elaborate?
mechanical_fish 15y ago
"MongoDb Sentiment Distribution" is a riot: http://www.flickr.com/photos/sog/5909237447/in/photostream/ http://www.flickr.com/photos/sog/5909237447/in/photostream/ If sociologists ran The Onion this would be on the front page.
- andypants 15y ago
  There are companies that provide text analysis services to determine the 'temperature' of the text or mood of the writer. The x axis of the graph is unexplained, but the idea (of being able to measure sentiment) isn't crazy.
  - sogrady 15y ago
    it's actually just the code from here: http://jeffreybreen.wordpress.com/2011/07/04/twitter-text-mining-r-slides http://jeffreybreen.wordpress.com/2011/07/04/twitter-text-mi... applied against a mongodb query. obviously not statistically representative; but rather an indication of what an acceptable profile looks like.
    - mechanical_fish 15y ago
      Of course you can measure customer sentiment. You can even measure the correlation between your brand name and a selection of happy words as they appear on Twitter. What you should probably not do, however, is elide the essential difference between these two measurements. Twitter is not a representative sample of anything but Twitter. Much of Twitter is spammers and shills, not customers. A lot of Tweets aren't even from humans. And people can mention MongoDB without knowing the slightest thing about it, and I am sure many do. I'm doing it now.
      - sogrady 15y ago
        where we agree then, i think, is the fact that Twitter's just another datapoint. and from a statistical perspective, it cannot be considered representative of the wider population for any number of reasons, not least the fact that it's observational rather than a random sample. that said, it's an interesting proxy for examining questions of sentiment, and its predictive ability has been examined several times academically within specific contexts (elections and markets - e.g. this one by Cornell http://arxiv.org/abs/1010.3003 http://arxiv.org/abs/1010.3003) and found to be relatively accurate. so agreed, it's not representative. but that doesn't mean it's not interesting and potentially useful.
mark_l_watson 15y ago
Not sure if I totally agree with the article, but MongoDB really is developer friendly: easy to set up and admin, slaves make create sources of analytics data (put a slave on each server that has analytics applications), useful for both large and small projects, etc. Personally, PostgreSQL and MongoDB meet just about all of my non-graph data store needs. For graph data, I keep switching between Neo4j, Sesame, and AllegroGraph - can't make up my mind since they have different capabilities (Sesame and AG for fast indexed SPARQL queries, Neo4j for graph traversal).
- Joakal 15y ago
  Not to mention, a very friendly community if you seek help on their mailing list!
trebor 15y ago
Allow me to play devil's advocate for a moment. MongoDB is not the new MySQL, because software with as much inertia and adoption as MySQL will not see easy or even complete replacement. Case-in-point: IE6. IE6 is still with us today, as much as we hate it. You can make all the arguments for a modern browser that you want, but businesses and a few people say, "But I like it better." Are there easy code migrations to MongoDB? No! Are there easy query migrations? Not really. It isn't a linear transition from one to the other. So no only do you have to rewrite your software, but you've got to pitch your SQL references out the window along with your queries. I believe that Postgres will replace MySQL. It's mature, SQL-based and similar enough that only tweaks are needed to get a code base running. Oh, and it's free. New projects may support MongoDB, but I'd be surprised if Wordpress ever came out with a version to support it. Just my 2¢.
programminggeek 15y ago
I think that one of the reasons that MongoDB is getting traction is that many people don't use relational databases in a relational way for many projects. Lots of data just isn't as relational as we hope it would be and also people are terrible at modeling data in a relational way. Relational databases were designed around the idea of minimizing storage footprint, and we have nearly infinite storage capacity relative to many databases, so many devs don't care about only having one copy of a piece of data in the DB. Also, SQL is great as a data retrieval language, but it is awful for inputting data. Yes, it works, but writing data to MongoDB in general has felt more natural than generating SQL to shotgun in data. You could argue that ORM's solve a lot of the uglyness of inputting data into a DB and I agree with you, but you still have to deal with table migrations and being able to just add a field in your code and not have to go hold the database's hand or write a migration to make it work is incredibly convenient. In the end, MongoDB solves a lot of convenience issues for programs that don't need relational data or programmers who don't want to use an ORM, create SQL strings, or write migrations to get their database to store their data. It's not for everybody, but if it fits your needs, it solves some problems much more conveniently than MySQL.
- IgorPartola 15y ago
  I agree with your first comment: a lot of people suck at creating models that are relational. It's also difficult to use relational data outside of a relational system: when you retrieve it from your RDBMS and get it as, say, a Python dictionary. This is the big problem with using SQL for the web. However, I disagree with your other statements: (1) we do not have infinite storage. Most data stores keep everything in RAM, and that is pretty limited. (2) It's really easy to input data into SQL. There are in fact a bunch of methods to do so (almost all still rely on SQL). (3) (more of a comment, than disagreement) ORM's don't solve much. They just remove the need for engineering a data access API and trade it for performance and cleanliness of code.
  - cdcarter 15y ago
    Lots of datastores don't keep everything in RAM though. CouchDB uses up a whole ton of disk, because disk is cheap and the way the database is structured the disk reads aren't even a problem for performance.
nwmcsween 15y ago
MongoDB and MySQL aren't comparable, one is a document store the other is a relational store.
Detrus 15y ago
HN Trends mentions of the other NoSQL contenders are pretty close to MongoDB. http://hntrends.jerodsanto.net/?q=MongoDB%2C+MySQL%2C+Redis%2C+Cassandra%2C+CouchDB http://hntrends.jerodsanto.net/?q=MongoDB%2C+MySQL%2C+Redis%... I think it's early to call a NoSQL winner/hammer now but I personally expected one eventually, http://www.quora.com/Will-there-be-a-new-de-facto-standard-of-databases http://www.quora.com/Will-there-be-a-new-de-facto-standard-o... although others aren't so sure. Just seems more convenient to use one database even if it's not an ideal fit for every task.
- Joakal 15y ago
  MySQL is still most used among the HN audience. There was a 'what database are you using?' poll last month I believe.
- sogrady 15y ago
  Google's got a bit more spread than HN: http://www.google.com/insights/search/#cat=0-5&q=mongodb%20%2B%20mongo%2Ccassandra%2Ccouchbase%20%2B%20couchdb%20%2B%20membase%2Chbase%2C&date=today%2012-m&cmpt=q http://www.google.com/insights/search/#cat=0-5&q=mongodb...
stevemoy 15y ago
According to the chart in the linked article (http://www.flickr.com/photos/sog/5909237515/ http://www.flickr.com/photos/sog/5909237515/), MySQL has had 73 (I assume distinct) committers in the past 12 months, but the most recent commit was over one year ago. I'll admit that I'm not familiar with Ohloh, but I don't see how both of those statements can be true.
antihero 15y ago
What advantages does MongoDB have over something like Redis?
- msbarnett 15y ago
  They're really different tools with different use-cases; I'm not sure it makes sense to directly compare them. Redis is a fast key-value store with the nice property that values can be things like lists and sets instead of just plain strings. MongoDB is a full-on document store for JSON-ish documents with support for complex ad hoc javascript queries over those documents, indexing, map-reduce style aggregation, and other fun arbitrarily complex search and collection scenarios that don't map into a simple key-value look up system.
  - antihero 15y ago
    Ah, fair enough. That's pretty cool. I find that if I want to store something complex like a dict/hash in redis, I simply encode it in JSON and store it as a string.
josephcooney 15y ago
The article says: A decade later, MySQL – a feature-poor database relative to the commercial alternatives at the time – was the most popular relational database on the planet. I would have thought the most popular relational database on the planet would be SQLite....since it ships with every android and iOS device, and with Firefox and Chrome.
- josephcooney 15y ago
  Oh, and I forgot Microsoft Access....does it count as 'relational'?
  - z92 15y ago
    MS Access is ACID compliant.
tedsuo 15y ago
I like and use both mongo and mysql. Where I think mysql shines is when you've been working on an applicaiton for 5 years, and end up connecting every piece to every other piece in ways you never imagined doing at the start. I think that's a lot trickier to do well in mongo, which favors denormalization since it's a document store. Given that most db's do not actually grow beyond what you can put on a single box, I suspect a lot of people may be avoiding problems they don't have while picking up problems they don't need by blindly switching to mongo. That said, when you have a problem that mongo solves well, boy howdy is it nice.
shapeshed 15y ago
MySQL and MongoDB have strengths and weaknesses based on use case. MongoDB isn't a drop in replacement for MySQL and you probably wouldn't choose it for something like a message queue.
frsyuki 15y ago
The article doesn't describe but one of the biggest difference is scalability. MongoDB supports horizontal scaling as a built-in feature. It's known that MySQL can be scaled out by sharding but you lose ACID with it. Of course scalability is required only when the service goes well. But it's important to considerate it if you intend to be successful. It can be said scaled MySQL is a no-SQL. MongoDB is the New MySQL with this point of view.

74 points by sogrady 15y ago

marshray 15y ago

Great! Now what's the next PostgreSQL?

hasanove 15y ago
CouchDB
- MatthewPhillips 15y ago
  Isn't Couch already out of style?
aeden 15y ago
PostgreSQL is the next PostgreSQL.
- chrisjsmith 15y ago
  The irony of this is that it's actually quite easy to build a document store on top of PostgreSQL that performs very well indeed. I tried it. I used a similar approach to the one described at [1]. You get the advantage of years of experience (never underestimate this!), MVCC, transactions, consistency and replication as well. (yes I know it doesn't "perform" as well as the other NoSQL stores but performance is not without tradeoffs [2]) [1] http://bret.appspot.com/entry/how-friendfeed-uses-mysql http://bret.appspot.com/entry/how-friendfeed-uses-mysql [2] http://www.caradvice.com.au/wp-content/uploads/2006/12/FerrariCrash4.jpg http://www.caradvice.com.au/wp-content/uploads/2006/12/Ferra...
  - dikbrouwer 15y ago
    To me, the biggest advantage of MongoDB is autosharding. If you read the friendfeed article, you'll see that they also have to deal with 'eventual consistency' on the indexes.
    - chrisjsmith 15y ago
      I'd say that's not necessarily an advantage. Sharding is incredibly complicated to get right considering all factors such as balancing and recovery. I'd rather partition the data based on function onto distinct clusters, you know like eBay do. You can update the indexes in a transaction too, so that's not necessarily an issue. MySQL has problems with this due to locking but the MVCC implementation in PostgreSQL allows much better concurrency.

someone13 15y ago

Not sure if this is just me, but the site loads partway and then sits forever* and never loads any further. Anyone else have this problem? * = For a certain value of "forever"

dgrant 15y ago
Yeah the site blows, I still can't connect.
- sogrady 15y ago
  it's not either one of you, it's our setup. that and the fact that i neglected to directly cache the page before it hit, so our server is about to burst into flames. soon as i can get back into to shut things down and cache everything it'll go back to normal. ish. apologies in the meantime.
SigmundA 15y ago
Just give it time, it's eventually consistent.

oldgregg 15y ago

http://webcache.googleusercontent.com/search?q=cache:redmonk.com/sogrady/2011/07/06/mongodb-is-the-new-mysql/&hl=en&strip=1 http://webcache.googleusercontent.com/search?q=cache:redmonk...

VilleSalonen 15y ago

Most of these Point seem to ring a bit hollow. MongoDB gets criticism: therefore it's the new MySQL? Or because they both use open source licenses? I'm not saying that MongoDB isn't growing. I just think that it's way early to pronounce it as a replacement for MySQL. These kinds of provocative but false titles belong in the cheap tabloids, not on the front page of Hacker News.

sogrady 15y ago
[disclosure: i'm the author] i tried to explicitly make the point that MongoDB is not a replacement for MySQL, it is rather following a similar path from a licensing, usage and market reaction standpoint. and that mongo's course within the nosql world may follow the pattern we saw mysql track w/in the relational database market. from this comment, it doesn't seem like i was successful on that score.
- VilleSalonen 15y ago
  Apparently I managed to overlook your statement about it not being a replacement. It's just that the title of the post seems to be in contradiction with that. MongoDB is indeed an interesting software and it's on a promising start. I'll be interested to see where it's going. Maybe one day the title of your post will be true.

sigzero 15y ago

Wow, I don't think you want that comparison.

sogrady 15y ago
depends on your metric, does it not?
- sigzero 15y ago
  MySQL has always (despite its usage) the red-headed step child of databases.

mikey_p 15y ago

The thing that I've found that makes MongoDB super easy for folks migrating from SQL is that it is easy to add indexes to arbitrary fields, and they work the same way as they do in MySQL. It's just a b-tree and if you can setup MySQL indexes, then you can build smart, well indexed structures and systems with Mongo. Being able to do this without jumping all the way into writing map-reduce bits, but saving the time of setting up a rigid schema, makes it easy to see why MongoDB is so popular. To me, that is why MongoDB is the new MySQL.

deleted 15y ago
[deleted]
St-Clock 15y ago
I am confused. How hard is it to create an index in MySQL? I don't have much experience with MySQL, but with PostgreSQL, it is very easy. In addition, there are some "advanced" features that may not be provided by MongoDB: you can choose your index type, rebuild the index, update the stats that will help the query optimizer decide if the index should be used at all, etc.
- j_baker 15y ago
  It's not that the actual command you enter to create an index is hard. It's just that when you have a table with millions or billions of rows, you have to figure out how to create the index without stopping the world for hours.
  - St-Clock 15y ago
    With postgresql, create index does not block read, only write. You can also use the CONCURRENTLY parameter and writes/updates won't be blocked, but the index creation takes longer (the db has to wait until no transaction potentially involving the index has stopped). Not sure what other strategies exist to reliably build an index. http://www.postgresql.org/docs/current/static/sql-createindex.html http://www.postgresql.org/docs/current/static/sql-createinde...
- 15y ago

KaeseEs 15y ago

I would tend to say that MongoDB is the new MySQL in a different way - it's the default not-really-suitable hammer that the current generation of amateur software carpenters are using to turn every problem into a nail. It's not super elegant, but most of the time it works, sort of. On the bright side, one could say that at least half of the PHP/MySQL tag team has been improved significantly by being replaced with Python/MongoDB, as theological issues aside, Python is a lot less broken than PHP :)

sogrady 15y ago
"I would tend to say that MongoDB is the new MySQL in a different way - it's the default not-really-suitable hammer that the current generation of amateur software carpenters are using to turn every problem into a nail. It's not super elegant, but most of the time it works, sort of." that's an excellent - and much shorter - way of putting it.
superuser2 15y ago
For what projects (besides enterprise -> Oracle, embedded -> SQLite and Windows -> SQL server) would you consider MySQL inappropriate? What would you use instead? I see people angry about not using the "right tool for the job" all the time with regard to web applications. What other tools do you feel aren't used when they should be?
- darrenkopp 15y ago
  I have a client synchronization utility that uses MongoDB instead of SQLite because it's lightweight but I have all ease of use of MongoDB. Install it as a windows service with our installer and we are good to go. And in this context, MySql would be way to heavy.
  - stephth 15y ago
    I have a client synchronization utility that uses MongoDB instead of SQLite because it's lightweight but I have all ease of use of MongoDB. Install it as a windows service with our installer and we are good to go. And in this context, MySql would be way to heavy. Your comment is confusing. Can you please explain: You replaced sqlite with mongodb, as an embedded database? How can mongodb run without a server? Are you saying mongodb is more lightweight than sqlite? If so I find this very surprising, can you elaborate?

mechanical_fish 15y ago

"MongoDb Sentiment Distribution" is a riot: http://www.flickr.com/photos/sog/5909237447/in/photostream/ http://www.flickr.com/photos/sog/5909237447/in/photostream/ If sociologists ran The Onion this would be on the front page.

andypants 15y ago
There are companies that provide text analysis services to determine the 'temperature' of the text or mood of the writer. The x axis of the graph is unexplained, but the idea (of being able to measure sentiment) isn't crazy.
- sogrady 15y ago
  it's actually just the code from here: http://jeffreybreen.wordpress.com/2011/07/04/twitter-text-mining-r-slides http://jeffreybreen.wordpress.com/2011/07/04/twitter-text-mi... applied against a mongodb query. obviously not statistically representative; but rather an indication of what an acceptable profile looks like.
  - mechanical_fish 15y ago
    Of course you can measure customer sentiment. You can even measure the correlation between your brand name and a selection of happy words as they appear on Twitter. What you should probably not do, however, is elide the essential difference between these two measurements. Twitter is not a representative sample of anything but Twitter. Much of Twitter is spammers and shills, not customers. A lot of Tweets aren't even from humans. And people can mention MongoDB without knowing the slightest thing about it, and I am sure many do. I'm doing it now.
    - sogrady 15y ago
      where we agree then, i think, is the fact that Twitter's just another datapoint. and from a statistical perspective, it cannot be considered representative of the wider population for any number of reasons, not least the fact that it's observational rather than a random sample. that said, it's an interesting proxy for examining questions of sentiment, and its predictive ability has been examined several times academically within specific contexts (elections and markets - e.g. this one by Cornell http://arxiv.org/abs/1010.3003 http://arxiv.org/abs/1010.3003) and found to be relatively accurate. so agreed, it's not representative. but that doesn't mean it's not interesting and potentially useful.

mark_l_watson 15y ago

Not sure if I totally agree with the article, but MongoDB really is developer friendly: easy to set up and admin, slaves make create sources of analytics data (put a slave on each server that has analytics applications), useful for both large and small projects, etc. Personally, PostgreSQL and MongoDB meet just about all of my non-graph data store needs. For graph data, I keep switching between Neo4j, Sesame, and AllegroGraph - can't make up my mind since they have different capabilities (Sesame and AG for fast indexed SPARQL queries, Neo4j for graph traversal).

Joakal 15y ago
Not to mention, a very friendly community if you seek help on their mailing list!

trebor 15y ago

Allow me to play devil's advocate for a moment. MongoDB is not the new MySQL, because software with as much inertia and adoption as MySQL will not see easy or even complete replacement. Case-in-point: IE6. IE6 is still with us today, as much as we hate it. You can make all the arguments for a modern browser that you want, but businesses and a few people say, "But I like it better." Are there easy code migrations to MongoDB? No! Are there easy query migrations? Not really. It isn't a linear transition from one to the other. So no only do you have to rewrite your software, but you've got to pitch your SQL references out the window along with your queries. I believe that Postgres will replace MySQL. It's mature, SQL-based and similar enough that only tweaks are needed to get a code base running. Oh, and it's free. New projects may support MongoDB, but I'd be surprised if Wordpress ever came out with a version to support it. Just my 2¢.

programminggeek 15y ago

I think that one of the reasons that MongoDB is getting traction is that many people don't use relational databases in a relational way for many projects. Lots of data just isn't as relational as we hope it would be and also people are terrible at modeling data in a relational way. Relational databases were designed around the idea of minimizing storage footprint, and we have nearly infinite storage capacity relative to many databases, so many devs don't care about only having one copy of a piece of data in the DB. Also, SQL is great as a data retrieval language, but it is awful for inputting data. Yes, it works, but writing data to MongoDB in general has felt more natural than generating SQL to shotgun in data. You could argue that ORM's solve a lot of the uglyness of inputting data into a DB and I agree with you, but you still have to deal with table migrations and being able to just add a field in your code and not have to go hold the database's hand or write a migration to make it work is incredibly convenient. In the end, MongoDB solves a lot of convenience issues for programs that don't need relational data or programmers who don't want to use an ORM, create SQL strings, or write migrations to get their database to store their data. It's not for everybody, but if it fits your needs, it solves some problems much more conveniently than MySQL.

IgorPartola 15y ago
I agree with your first comment: a lot of people suck at creating models that are relational. It's also difficult to use relational data outside of a relational system: when you retrieve it from your RDBMS and get it as, say, a Python dictionary. This is the big problem with using SQL for the web. However, I disagree with your other statements: (1) we do not have infinite storage. Most data stores keep everything in RAM, and that is pretty limited. (2) It's really easy to input data into SQL. There are in fact a bunch of methods to do so (almost all still rely on SQL). (3) (more of a comment, than disagreement) ORM's don't solve much. They just remove the need for engineering a data access API and trade it for performance and cleanliness of code.
- cdcarter 15y ago
  Lots of datastores don't keep everything in RAM though. CouchDB uses up a whole ton of disk, because disk is cheap and the way the database is structured the disk reads aren't even a problem for performance.

nwmcsween 15y ago

MongoDB and MySQL aren't comparable, one is a document store the other is a relational store.

Detrus 15y ago

HN Trends mentions of the other NoSQL contenders are pretty close to MongoDB. http://hntrends.jerodsanto.net/?q=MongoDB%2C+MySQL%2C+Redis%2C+Cassandra%2C+CouchDB http://hntrends.jerodsanto.net/?q=MongoDB%2C+MySQL%2C+Redis%... I think it's early to call a NoSQL winner/hammer now but I personally expected one eventually, http://www.quora.com/Will-there-be-a-new-de-facto-standard-of-databases http://www.quora.com/Will-there-be-a-new-de-facto-standard-o... although others aren't so sure. Just seems more convenient to use one database even if it's not an ideal fit for every task.

Joakal 15y ago
MySQL is still most used among the HN audience. There was a 'what database are you using?' poll last month I believe.
sogrady 15y ago
Google's got a bit more spread than HN: http://www.google.com/insights/search/#cat=0-5&q=mongodb%20%2B%20mongo%2Ccassandra%2Ccouchbase%20%2B%20couchdb%20%2B%20membase%2Chbase%2C&date=today%2012-m&cmpt=q http://www.google.com/insights/search/#cat=0-5&q=mongodb...

stevemoy 15y ago

According to the chart in the linked article (http://www.flickr.com/photos/sog/5909237515/ http://www.flickr.com/photos/sog/5909237515/), MySQL has had 73 (I assume distinct) committers in the past 12 months, but the most recent commit was over one year ago. I'll admit that I'm not familiar with Ohloh, but I don't see how both of those statements can be true.

antihero 15y ago

What advantages does MongoDB have over something like Redis?

msbarnett 15y ago
They're really different tools with different use-cases; I'm not sure it makes sense to directly compare them. Redis is a fast key-value store with the nice property that values can be things like lists and sets instead of just plain strings. MongoDB is a full-on document store for JSON-ish documents with support for complex ad hoc javascript queries over those documents, indexing, map-reduce style aggregation, and other fun arbitrarily complex search and collection scenarios that don't map into a simple key-value look up system.
- antihero 15y ago
  Ah, fair enough. That's pretty cool. I find that if I want to store something complex like a dict/hash in redis, I simply encode it in JSON and store it as a string.

josephcooney 15y ago

The article says: A decade later, MySQL – a feature-poor database relative to the commercial alternatives at the time – was the most popular relational database on the planet. I would have thought the most popular relational database on the planet would be SQLite....since it ships with every android and iOS device, and with Firefox and Chrome.

josephcooney 15y ago
Oh, and I forgot Microsoft Access....does it count as 'relational'?
- z92 15y ago
  MS Access is ACID compliant.

tedsuo 15y ago

I like and use both mongo and mysql. Where I think mysql shines is when you've been working on an applicaiton for 5 years, and end up connecting every piece to every other piece in ways you never imagined doing at the start. I think that's a lot trickier to do well in mongo, which favors denormalization since it's a document store. Given that most db's do not actually grow beyond what you can put on a single box, I suspect a lot of people may be avoiding problems they don't have while picking up problems they don't need by blindly switching to mongo. That said, when you have a problem that mongo solves well, boy howdy is it nice.

shapeshed 15y ago

MySQL and MongoDB have strengths and weaknesses based on use case. MongoDB isn't a drop in replacement for MySQL and you probably wouldn't choose it for something like a message queue.

frsyuki 15y ago

The article doesn't describe but one of the biggest difference is scalability. MongoDB supports horizontal scaling as a built-in feature. It's known that MySQL can be scaled out by sharding but you lose ACID with it. Of course scalability is required only when the service goes well. But it's important to considerate it if you intend to be successful. It can be said scaled MySQL is a no-SQL. MongoDB is the New MySQL with this point of view.