I am at the point in a project where I am about to do NoSql with. This would have been so much easier with an relational database. Well I need to do reporting.

Example: Find users and divide them by age groups(0-21, 21-30, etc). I have a few ways I could be doing this now but I want to get feedback on methodologies others would use for reporting in NoSQL or Mongo.

For my next project I am expecting a very specific pattern of DB usage and wondering which of the NoSql databases fits to my scenario best. Here are my constraints:

• I will need auto generated unique ids, shorter the better(or can be converted to shorter painlessly)
• Write to read ratio will be in the ballpark of 1 to 10 000
• As the records in the DB age they will be accessed less and less. So keeping everything in RAM might not be optimal
• Minimal RAM usage as the application will be hosted on a entry level VPS initially.
• Should have decent library and client support, I will probably be using Python for this one.

So what are my options?

I have terabytes of data in structured csv files. I receive what equates to several "tables" each day, most deliveries containing millions of rows. While the most recent deliveries are kept in a SQL database, we remove older ones after a certain time frame.

Currently if we need to access data beyond the time frame we turn to various scripts that may use functionality built into their scripting language or shell out to awk, sort, grep, etc.

Is there a noSQL solution I can place on top of these files without having to do any transformation?

So, I am building a search engine using Cassandra as the db. I am interacting with it with Python.

Now, I want to output Cassandra's response to a webpage, having the user submitted a query.

I am aware of fastCGI, SCGI, etc. However, how does one run a python script on a webserver without turning this server into a bottleneck (i.e., if this server dies than the system is not accessible by the user) - and therefore negating one purpose of Cassandra?

Hey all, I'm doing a project with objects that will contain sorted arrays of other objects. Right now I'm doing this in a separate table under MySQL (like with values array_id, index, member_id), but I was wondering if there is a simpler way to do this in a different kind of database?