nosql

[bitWISE]

Any of you played with any of the nosql offerings yet?

[Eraser]

More than a year ago a colleague of mine was exploring CouchDB. While I wasn't really involved with his work on that, he was sitting right next to me so whenever he was enthusiastic about something, he couldn't help but show me. He was pretty happy with how it worked.

I work at a different company so I'm not sure if CouchDB really ended up being used though, but he was impressed by it.

What exactly are you looking for if I may ask?

[bitWISE]

Mostly I've just been intrigued by it (I first heard about the concept with Cassandra) but haven't gotten around to making an attempt to use it. The distributed aspect is obviously enormously beneficial but the thing I can't wrap my head around is non-relational data and queries.

Specifically, I'm looking at developing server architecture for a hobby project in such a way that I can run it on cheap linux servers. The server code will be running C# over mono but as far as database goes I'm not really sure. I would be storing real-time game data to maintain a persistent world and perhaps static data as well.

[^misantropia^]

Check out MongoDB but take note that you trade consistency for scalability.

[bitWISE]

Thanks for the suggestion. I had forgotten about that one but so far I'm loving it. Whenever something open-source "just works" out of the box (and in Windows no less!) it makes me very happy. So far I've played around with the PHP driver in WAMP. I'm loving the idea of not having to manually define anything first since it creates what it needs on the fly. Not to mention the almost non-existent syntax. Less time worrying about the boring shit and more time for the fun stuff!

Nearly 80mb to store two fields in one collection in one database seems like a ton of overhead though. Will be interesting to see how it grows.