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.
[ Parent
| on HN ]
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.
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.
> But yes, you're right that maps require a join table.
Not in postgres: http://www.postgresql.org/docs/9.1/static/hstore.html