Things I wish I knew about MongoDB a year ago

Re:Things I wish I knew about MongoDB a year ago by thibaut_barrere on Thursday October 18, 2012 @03:28AM (#4667793)

Adding column per searchable field is precisely what I wanted to avoid :-)

If you need to store multiple forms types, it gets hairy very fast.

MongoDB allows to query inside the data (which is not a blob in that case).

[ Parent | on HN ]

Re:Things I wish I knew about MongoDB a year ago by jeltz on Thursday October 18, 2012 @07:06AM (#4668225)

So does PostgreSQL, but I have no idea about MySQL. You can run xpath queries against XML documents, and you can also index specific xpath queries (there is no general indexing infrastructure for XML in PostgreSQL). For JSON no path lookup functions are included in the core yet, but I assume there are extensions which add them.

[ Parent | on HN ]