Hacker News Reader

The article didn't answer the question for me of how to query for the absence of a property, without getting an entire document collection first.

I was really hoping there was a secret to search against null or undefined.

Is there a NoSQL solution that does allow for such queries?

View on HN

With CouchDB you can do it. You create a view filters on the absence or prescense of that field. I'm not sure if that answers your question, as I don't know how other nosql databases handle indexing.

I'll investigate the constraints of CouchDB, thanks!

If you want to include Postgres jsonb columns in that then a partial index of the expression of a NOT of the jsonb contains jsonb operator.

Reply on news.ycombinator.com