Live data from Hacker News

PostgreSQL Outperforms MongoDB in New Round of Tests

blogs.enterprisedb.com

11–20 of 171 posts

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#11
post #8

Since when MongoDB is considered as a database comparable with PostgreSQL?)

That's not really relevant, since the point is that Postgres can do what MongoDB does but faster.

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata.

People are switching to MongoDB because the developer and deployment experience is so good.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#13
post #8

Since when MongoDB is considered as a database comparable with PostgreSQL?)

That's not really relevant, since the point is that Postgres can do what MongoDB does but faster.

... and far more safely. No one should be using MongoDB in production (or if you do, please never let me store data in your service).

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#14

Will be great if PostgreSQL ends up as a storage engine option in MongoDB like InnoDB. Then you have the better engine of PostgreSQL with the superior clustering, sharding and end user experience of MongoDB. That said these articles are pretty pointless. Performance isn't the reason companies are switching to MongoDB.

How about implementing MongoDB API on top of the PostgreSQL? Then sell it companies which started with MongoDB, but run into some scalability/reliability issues.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#15
post #8

Earlier quoted context omitted.

That's not really relevant, since the point is that Postgres can do what MongoDB does but faster.

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

Capability is not the same thing as usability. Postgres is demonstratively more capable than Mongo, it's just not perceived as usable.

There's a deep lesson here to be learned. One that can make you rich.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#16
post #8

Earlier quoted context omitted.

That's not really relevant, since the point is that Postgres can do what MongoDB does but faster.

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

Hate to say so, but many are switching to MongoDB because it's the current new kid on the block.

I found that many companies have incredibly bad, not use-case driven reasons to pick their DB. Not that MongoDB is a bad database, but it has it's fair share of issues. Granted, this is the case for every database, but if you pick any database without being aware of those, you end up in a world of pain.

(Context: I consult for backend systems in general)

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#17

Will be great if PostgreSQL ends up as a storage engine option in MongoDB like InnoDB. Then you have the better engine of PostgreSQL with the superior clustering, sharding and end user experience of MongoDB. That said these articles are pretty pointless. Performance isn't the reason companies are switching to MongoDB.

How about implementing MongoDB API on top of the PostgreSQL? Then sell it companies which started with MongoDB, but run into some scalability/reliability issues.

As sad as it may be, with the use of schema-enforcing ORMs and the popularity of MongoDB, this will be a viable business in the near future.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#18

Will be great if PostgreSQL ends up as a storage engine option in MongoDB like InnoDB. Then you have the better engine of PostgreSQL with the superior clustering, sharding and end user experience of MongoDB. That said these articles are pretty pointless. Performance isn't the reason companies are switching to MongoDB.

Got a friend recently who used mongodb as first choice for an easy db. He got crazy, dropped it after a month, recoded the thing for postgres in 2 weeks and its been working ever since.. and hes now another die hard postgres fan.

Sooo I don't know.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#19

Will be great if PostgreSQL ends up as a storage engine option in MongoDB like InnoDB. Then you have the better engine of PostgreSQL with the superior clustering, sharding and end user experience of MongoDB. That said these articles are pretty pointless. Performance isn't the reason companies are switching to MongoDB.

How about implementing MongoDB API on top of the PostgreSQL? Then sell it companies which started with MongoDB, but run into some scalability/reliability issues.

Pretty sure it's easier to add PostgreSQL as a storage engine:

http://engineering.objectrocket.com/2014/07/18/experimental-...

Than to fix up the sharding and clustering in PostgreSQL. It's been an issue for quite a few years now and still not mainlined. I think most PostgreSQL users are simply scaling them vertically.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#20
post #8

Earlier quoted context omitted.

That's not really relevant, since the point is that Postgres can do what MongoDB does but faster.

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

>because the developer and deployment experience is so good. That was ironic, right?

http://php.net/manual/en/mongo.sqltomongo.php

Post reply on HN