News for hackers. Stuff that matters.
Re:Don't use MongoDB by jacques_chester on Monday November 07, 2011 @06:38AM (#3205855)
Informative replies, thank you.

> 1) You can write a function which determines whether a zipcode_id matches the constraint and check on that, or

Ah, this old chestnut. Been there, written the PL/SQL trigger, got the t-shirt. Agreed that there isn't a purely declarative approach here.

> You can't just index the path.

Postgres might be the winner here, if someone sufficiently motivated came along and wrote a custom index type for this use case.

There are no comments on this comment yet.