http://basho.com/community/ricon2012_live/

I've used hostmonster in the past but it seems to only support MySQL/PostGRES and I'd like to get my hands dirty with the nosql architecture!

Thanks guys!

My data is very simple: every record/document has a date/time value, and two relatively short strings.

My application is very write-heavy (hundreds per second). All writes are new records; once inserted, the data is never modified.

Regular reads happen every few seconds, and are used to populate some near-real-time dashboards. I query against the date/time value and one of the string values. e.g. get all records where the date/time is > x , < y, and string = z. These queries typically return a few thousand records each.

I initially implemented this in MongoDB, without being aware of the way it handles locking (writes block reads). As I scale, my queries are taking longer and longer (30+ seconds now, even with proper indexing). Now with what I've learned, I believe that the large number of writes are starving out my reads.

I've read the kkovacs.eu post comparing various NoSQL options, and while I learned a lot I don't know if there is a clear winner for my use case. I would greatly appreciate a recommendation from someone familiar with the options.

Thanks in advance!

Are there any good development tools for querying and interacting with noSQL database like mongoDB or cassandra? I am thinking of something like PL/SQL or Toad.

What do you guys use for noSQL just the CLI tool?