3 ms·

You're kidding right ? PostreSQL can't horizontally scale easily or properly handle JSON right now compared to MongoDB. It also has a fixed schema which makes

You're kidding right ? PostreSQL can't horizontally scale easily or properly handle JSON right now compared to MongoDB. It also has a fixed schema which makes database migrations a necessary evil again. Sorry but the idea that PostgreSQL is a feature by feature replacement is pretty laughable.

y0ghur7_xxx 14y ago
> PostreSQL can't horizontally scale easily Sure you can. Skype did it, Hitachi¹ did it. ¹http://www.pgcon.org/2008/schedule/events/57.en.html http://www.pgcon.org/2008/schedule/events/57.en.html > properly handle JSON right now Well it has V8 running on it. > It also has a fixed schema You don't need to use it like that if you don't want to.
- taligent 14y ago
  Easily being the appropriate word here. In that article you wrote they had to manually setup sharding. With something like CouchDB I can press a button to add a new node in the cluster. Again. Easily is what I am talking about. And again V8 is nice and all but it is rather bolted on as opposed to something that is was built from scratch to support JSON. This shows in terms of feature support and most importantly ease of use. I can't just annotate HashMaps, Lists etc in my Java classes and have them serialized to PostgreSQL in JSON format. I am just saying that PostgreSQL is a great and all but it is not a proper JSON document store style database anymore than hacking SQL on top of MonogDB would make it a RDBMS.
  - einhverfr 14y ago
    I noticed that Mattdebord's post qualified it by saying feature-for-feature replacement of Mongodb for us. He didn't claim it was for everyone. Why all the hate?
    - pbreit 14y ago
      That's just taligent begin taligent.
  - ryan_f 14y ago
    Not sure "press the button" is the case for some. I can't speak for CouchDB but I know many people finding it not so easy for MongoDB.
mattdeboard 14y ago
You don't actually know how we use it, so you are thoroughly unqualified to criticize what I've said.
einhverfr 14y ago
Maybe not easily but it can far more flexibly than MongoDB. Take a look at Postgres-XC which offers a two-tiered clustering solution for Postgres inspired by Teradata. A bit complex, but you don't give up your formal proof of data integrity in order to get it.

y0ghur7_xxx 14y ago

> PostreSQL can't horizontally scale easily Sure you can. Skype did it, Hitachi¹ did it. ¹http://www.pgcon.org/2008/schedule/events/57.en.html http://www.pgcon.org/2008/schedule/events/57.en.html > properly handle JSON right now Well it has V8 running on it. > It also has a fixed schema You don't need to use it like that if you don't want to.

taligent 14y ago
Easily being the appropriate word here. In that article you wrote they had to manually setup sharding. With something like CouchDB I can press a button to add a new node in the cluster. Again. Easily is what I am talking about. And again V8 is nice and all but it is rather bolted on as opposed to something that is was built from scratch to support JSON. This shows in terms of feature support and most importantly ease of use. I can't just annotate HashMaps, Lists etc in my Java classes and have them serialized to PostgreSQL in JSON format. I am just saying that PostgreSQL is a great and all but it is not a proper JSON document store style database anymore than hacking SQL on top of MonogDB would make it a RDBMS.
- einhverfr 14y ago
  I noticed that Mattdebord's post qualified it by saying feature-for-feature replacement of Mongodb for us. He didn't claim it was for everyone. Why all the hate?
  - pbreit 14y ago
    That's just taligent begin taligent.
- ryan_f 14y ago
  Not sure "press the button" is the case for some. I can't speak for CouchDB but I know many people finding it not so easy for MongoDB.

mattdeboard 14y ago

You don't actually know how we use it, so you are thoroughly unqualified to criticize what I've said.

einhverfr 14y ago

Maybe not easily but it can far more flexibly than MongoDB. Take a look at Postgres-XC which offers a two-tiered clustering solution for Postgres inspired by Teradata. A bit complex, but you don't give up your formal proof of data integrity in order to get it.