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. ...
Hi, We're developing a really big project and I was wondering if anyone can give me some advice about what DB backend should we pick. Our system is compound by 1100 electronic devices that send a signal to a central server and then the server stores the signal info (the signal is about 35 bytes long). How ever these devices will be se...
I am trying to perform a regex query using pymongo against a mongodb server. The document structure is as follows { "files": [ "File 1", "File 2", "File 3", "File 4" ], "rootFolder": "/Location/Of/Files" } I want to get all the files that match the pattern *File. I tried doing this as such db.collectionName.find...
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 ...
Hello, Our company is working on a project that requires a database with 30-50 million rows of product data. These rows contain text that needs to be searched concurrently thousands of times per second. Moreover, each search needs to take less than one second to execute. So, all in all, we have a 50M row database that needs to be searc...
Hi, I have a couple of sqlite dbs (i'd say about 15GBs), with about 1m rows in total - so not super big. I was looking at mongodb, and it looks pretty easy to work with, especially if I want to try and do some basic natural language processing on the documents which make up the databases. I've never worked with Mongo in the past, no w...
Hi, I'm a beginner with MongoDB and I've some questions: When I'm connected to Mongo, and i execute show dbs I see 2 databases: admin and local. What's their role? Then if I execute an insert command like db.foo.insert({"value":"mongo"}), the test database appears. Why? How can i specify a custom name for a database? With show dbs I g...
For my blog, I want to incorporate my own commenting system without relying on the default wordpress commenting system. I need the comments module to utilize mongodb instead of mysql and the module needs support for the following: Threaded comments Comment Voting The votes on comments need to be aggregated per each comment author f...
I have a special list (a sort of queue, as in the data structure, not as in a work queue) that I want to store in MongoDB. I need to access and manipulate this single list often in my application - and I don't have several of the same type of list. It would be easiest to store it in a single document, but the problem I'm having is figur...
Hello, We are planning to deploy a Rails 2.3.8 application which uses MongoDB, on our website. Our present web hosting provider is hostgator and they do not provide support for mongodb. So, what are the best/cheap hosting companies out there where I can have full stack of Ruby on Rails and MongoDB? We are looking for cheapest hosting ...
I'm new to rails and mongodb, and have a simple form attempting to create a category tree. Whenever I refresh the page, a new entry is put into the database. I'm not clicking the 'submit' button, just page refresh. The form looks like this <%= form_for Activity.create do |f| -%> <%= f.text_field :activity_name % > <%= f.submt "a...
What sort of tools are available to monitor memory usage in methods running from delayed_job? I have looked at memorylogic, oink, bleakhouse but they all either seem designed to work with controllers or I am missing something. Any examples of how delayed_job memory leaks (not with the gem itself but the code it is running) are detected ...
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...
I'm building a simple short URL service, ala bitly, for our company use. And I would like to use mongodb to store the data, but I will need some kind of simple interface to add/edit short url to long url mappings. The mongo documents will be very simple, something like this: { shortUrlSlug: 'pbbs', fullUrl: 'http://example.com/pean...
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...
Is there a preferred way to query mongo with a limit and know whether there will be more results if I query for the next page with skip/limit? What I have been doing is asking for one more document than I need, slicing it off the end, and using the existence of that extra document to know whether another query will give at least one mor...
We're deploy an Instant messenger (AJAX), for it we write a comet server who will handle the communication now we want to store the sent messages to a DB, which DB engine one give the best performance? We talk about 5000 Insert/sec, i think MySQL and PostgreSQL was out of the game, any proposals? HamsterDB, SQLite, MongoDB ...? We don'...
When I have two MongoDB documents like this... db.test.insert( {"value" : "10123"} ); db.test.insert( {"value" : "160"} ); The result of a query like: db.test.find({"value" :{$gt : "12"} }); is.. { "_id" : ObjectId("4c6d1b92304326161b678b89"), "value" : "160" } It's obvious, that a string comparison is made, so that my first va...
I have 100,000 queries, and I need to create a google-like 'Suggestions' system. Much like this I need it to be pretty quick, and if possible allow for some more in-depth options (like sorting, etc.). Can anyone recommend a database system I could use for this that could handle searching through 100k+ queries while still keeping spee...
Attempting to start the WEBrick server on a Rails 3 / Ruby 1.9.1 with Mongoid errors with: "MongoDB 1.4.0 not supported, please upgrade to 1.6.0 (Mongoid::Errors::UnsupportedVersion)" ... but mongo --version: MongoDB shell version: 1.6.1 Anyone else seen this? Pretty new to Ruby so apologies if I'm asking a stupid questi...