I've been looking at the rise of the NoSql movement and the accompanying rise in popularity of document databases like mongodb, ravendb, and others. While there are quite a few things about these that I like, I feel like I'm not understanding something important. Let's say that you are implementing a store application, and you want to ...
I am developing a simple internal use application with an intended user base of around 100 people. The application does a lot of reads and very few writes. The dataset size is fairly small and we do not want to use a RDBMS if possible. In fact, the relational requirements are fairly small. I am looking at using some NoSQL database and I ...
I am evaluating a number of NoSQL implementations (RavenDB and MongoDB at the moment) as a means of solving a specific set of requirements that involve storage/retrieval of data that is schema-less. I want to get some feedback on whether NoSQL is the direction I should be looking in, or if there are other (potentially simpler) options. ...
How is it possible to relete old revisions of couchdb document? ...
Hi everybody, I wanted to make a tryout this weekend with Cassandra + PHP in my testing environment. So after a few hours of headache trying to install it, I finally succeeded and got it running. However, I've tried out the different PHP wrappers for cassandra, and I have totally failed to connect with anyone. SimpleCassie which I want...
I have been doing web programming for few years. All this time, I have been using RDBMS. As a side project, I would like to create a web application and would like to use NoSQL. I have never used NoSQL. So I would like to use a NoSQL solution. Web app is going to be a calendar and article list that are going to be shared among a project ...
Hi everybody, In mysql, I can do the following query, UPDATE mytable SET price = '100' WHERE manufacturer='22' Can this be done with cassandra? Thanks! ...
Hi everybody, We have thought a bit about running a noSQL database for our next project. However, we're not sure about which platform that will give us the best possible availability and has the best built-in replication features/functions to provide this - with the least headache. Right now, Cassandra appears as the best candidate, bu...
Hi everybody, We are about to solve a customer's need of a web based application that holds a big amount of products and their data - including prices, weights, physical volyme, and much more. Everything but the prices are data that is data that will be stored once, and then probably not changed. The prices on the other hand will be u...
Like facebook, everyone has messages on the wall. Are all messages stored in only one table? And it will only display messages belong to the user's ID when loading the page? And if it is then there will be so many rows in that table. Is there any limit of the rows in one table? Or every user has one table only store their own messages? ...
I have an analytics database where I make complex queries. Each of these queries generates thousands of rows. I want to store these results in some kind of on disk cache so I can get the results later on. I can't insert the results back into the database where the results came from as that database is read only. The requirements of this ...
Hey, So I'm looking to run Sphinx over a NoSQL system such as MongoDB, HBase, Cassandra, etc. Right now, we're comparing all the NoSQL systems out there. Basically, we need to query 50+ Million rows of product data with fulltext searches thousands of times a second, so we're trying to find the most efficient NoSQL system. Here is our ...
Hello, I am developing a dating website and I am thinking of using a NoSQL database to store the profiles etc. I am currenly looking into the MongoDB and so far I am very pleased. The only worry is that I read on different websites that MongoDB is unreliable and not good. I looked into the NoSQL alternatives and found no one that fully...
A fairly common requirement in database applications is to track changes to one or more specific entities in a database. I've heard this called row versioning, a log table or a history table (I'm sure there are other names for it). There are a number of ways to approach it in an RDBMS--you can write all changes from all source tables t...
I'm having a system that collects real-time Apache log data from about 90-100 Web Servers. I had also defined some url patterns. Now I want to build another system that updates the time of occurrence of each pattern based on those logs. I had thought about using MySQL to store statistic data, update them by statement: "Update table s...
What kind of projects benefit from using a NoSQL database instead of rdbms wrapped by an ORM? Examples: Stackoverflow similiar sites? Social communities? forums? ...
I've looked at MongoDB/norm (but want a general document-oriented store answer). It seems really nice to work with and I'm interested in knowing when it should be used instead of RDBMS+ORM? What should i use for for instance: Stackoverflow similiar sites Social communities forums (I posted another more general question but it got a...
When running the SAVE command in redis-cli for Redis 1.3.15 it just returns "(error) ERR", BGSAVE does not appear to do anything either. The SHUTDOWN command returns "(error) ERR Errors trying to SHUTDOWN. Check logs.". Killing the Redis process and starting Redis again does not change the save error. Naturally I have tried to check the...
I need a reliable K-V storage to be run in network. Main requirements: Network connectivity has nonblocking twisted API be reliable, production ready. No data loss write performance is more important than read performance support for distributed operation and failover would be great (So I just specify list of nodes) java/ruby/erlang AP...
I have a Cassandra ColumnFamily (0.6.4) that will have new entries from users. I'd like to query Cassandra for those new entries so that I can process that data in another system. My sense was that I could use a TimeUUIDType as the key for my entry, and then query on a KeyRange that starts either with "" as the startKey, or whatever th...