4 ms·
Why not just use postgresql?
by bfrog 14y ago
Why not just use postgresql?
- WALoeIII 14y agoAgreed, start with a known entity. Take the one special table that is killing you and move it to a special database (Riak/Cassandra etc) suited for that task only once you understand exactly what you need.
- tptacek 14y agoI think Kiip agrees with you completely too.
- jasonmccay 14y agoI find it a better course of action to work on properly understanding your data problem and then evaluate the options available instead of just sticking with the stand-by solution ("Well, we've always done x!"). Just like with anything in technology ... there is going to be pain as you escalate the level of complexity and what you are trying to accomplish.
- mitchellh 14y agoI disagree, based on experience. On the surface, MongoDB did solve our data problem, and we thought we sufficiently researched the technology that it would work, even attending multiple MongoDB conferences and talking to 10gen employees. The issue was that underlying architectural decisions in MongoDB ended up biting us and limiting us rather significantly. It could be argued that this is because MongoDB is a rather new piece of tech (I disagree, I think MongoDB is fundamentally flawed, but it doesn't matter in this argument). Because of our experience, going with the standby IS the best choice, until you _need_ something else. Riak was a change necessitated by its fast growth such that horizontally scaling was necessary when you're in an environment such as EC2. Ignoring MongoDB specifically, the IDEA of MongoDB simply isn't correct here, a Dynamo-style K/V store is the correct option, and Riak happens to be a fantastic one.
- taligent 14y agoBecause Postresql is not a NoSQL database despite the recent lipstick additions. I love the database but it is not optimal if you have a fluid schema like many use cases have today.
- deleted 14y ago[deleted]
- lwat 14y agoI recently asked if anyone could point me to an (open source) app on github or wherever that has a 'fluid schema' on a NoSQL system and nobody was able to show me one. Do you have a concrete example I can look at please?
- lwat 14y agoNothing? For something as common as you say I'd have thought there would be many examples out there. I don't get how this can be touted so often when there's no concrete use cases for this 'feature'.