http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660@Rafal i've seen blogs about Postgres's addition of the "dictionary column". If I ever walked into an organization and saw them stuff crap like that into a RDBMS, i'd walk right out the door. Just because the tool now supports this, it doesn't mean there is an sanity to the approach. http://ayende.com/159041/listofparams-and-other-horrible-things-that-you-shouldn-t-bring-to-ravendb#comment4http://ayende.com/159041/listofparams-and-other-horrible-things-that-you-shouldn-t-bring-to-ravendb#comment4Mon, 15 Oct 2012 18:29:03 GMTIt's funny that with few simple (uh, not for everyone) additions a RDBMS can become much more flexible. First is multi-valued fields (array fields), and the second one is a dictionary column (key-value container without a schema). PostgreSQL has them both (hstore and array columns) with querying and indexing capabilities in SQL. I hadn't had a chance to try it yet but it looks like a nice workaround for these limited by flat schema rigidity. And as a cherry on top of that theres the 'GIN' index for full text searching... are these guys trying to compete with NoSQL or what?http://ayende.com/159041/listofparams-and-other-horrible-things-that-you-shouldn-t-bring-to-ravendb#comment3http://ayende.com/159041/listofparams-and-other-horrible-things-that-you-shouldn-t-bring-to-ravendb#comment3Tue, 09 Oct 2012 13:57:14 GMTYeah, the fact that I now know that dynamic objects will work just fine stuffing into RavenDB is something that I think will be really handy :)http://ayende.com/159041/listofparams-and-other-horrible-things-that-you-shouldn-t-bring-to-ravendb#comment2http://ayende.com/159041/listofparams-and-other-horrible-things-that-you-shouldn-t-bring-to-ravendb#comment2Tue, 09 Oct 2012 12:50:10 GMTI think I just had an epiphany.http://ayende.com/159041/listofparams-and-other-horrible-things-that-you-shouldn-t-bring-to-ravendb#comment1http://ayende.com/159041/listofparams-and-other-horrible-things-that-you-shouldn-t-bring-to-ravendb#comment1Tue, 09 Oct 2012 10:38:01 GMT