News for hackers. Stuff that matters.
Re:MongoDB shares jump more than 30% in $192M IPO by mi100hael on Thursday October 19, 2017 @04:33PM (#15511328)
I'd argue the opposite is true. NoSQL requires you to be more intentional with your schema design since you can only query keys. As a database grows with complexity, you can find yourself in a world of pain with NoSQL if you all of a sudden need to query something in a different manner. At least with SQL you have more options with WHERE clauses & indexes even if performance might not be top notch.
Re:MongoDB shares jump more than 30% in $192M IPO by HodGreeley on Thursday October 19, 2017 @06:15PM (#15512008)
Not sure of others, but not true with Couchbase. You have queries just as flexible as with SQL.
Re:MongoDB shares jump more than 30% in $192M IPO by philliphaydon on Thursday October 19, 2017 @09:56PM (#15513033)
One of the reasons I love PostgreSQLs jsonb type is you get the power of relational database and power of (nosql?) Document database at the same time. i haven’t run into any query I couldn’t write against a jsonb doc. Granted dot notation on json would be nicer than ‘prop’ > ‘prop’ > ‘prop’, but I don’t feel limited.