News for hackers. Stuff that matters.
Re:Building a MongoDB Clone in Postgres by gbog on Monday June 04, 2012 @07:40PM (#4066579)
Ahem, lists and maps seem a very easy thing to do in SQL. Where you get to the limits of the relational model is when three structure diversity is out of your hands, for instance a big bunch of parametrized messages.
Re:Building a MongoDB Clone in Postgres by taligent on Monday June 04, 2012 @08:10PM (#4066666)
Lists/Maps require extra tables which means more scripts, more migrations, more backups, more worry.

With MongoDB all I have to do is add Map<String,String> myMap to a Java class and that's it.

Re:Building a MongoDB Clone in Postgres by dstorrs on Tuesday June 05, 2012 @03:22AM (#4067732)
Actually, Postgres has had an Array data type since at least v8.0. http://www.postgresql.org/docs/8.0/static/arrays.html

But yes, you're right that maps require a join table.

Re:Building a MongoDB Clone in Postgres by masklinn on Tuesday June 05, 2012 @01:02PM (#4069504)
> But yes, you're right that maps require a join table.

Not in postgres: http://www.postgresql.org/docs/9.1/static/hstore.html