We are looking at using a NoSQL database system for a large project. Currently, we have read a bit about MongoDB and Cassandra, though we have absolutely no experience with either. We are very proficient with traditional relational databases like MySQL and Microsoft SQL, but the NoSQL (key/value store) is a new paradigm for us. So basic...
I'm trying to use MongoDB with my POCOs. Using mongodb-csharp library (http://github.com/samus/mongodb-csharp), I've got everything working, but I have to have my Ids set to OIds which requires me to reference the mongodb-csharp library from within my entities assembly. This doesn't seem right. I've searched online but I can't seem to fi...
I've been diving into MongoDB with kind help of MongoKit and MongoEngine, but then I started thinking whether the data mappers are necessary here. Both mappers I mentioned enable one to do simple things without any effort. But is any effort required to do simple CRUD? It appears to me that in case of NoSQL the mappers just substitute one...
I'm trying to set up an automated process to regularly transform and export a large MS SQL 2008 database to MongoDB. There is not a 1-1 correspondence between tables in SQL and collections in MongoDB -- for example the Address table in SQL is translated into an array embedded in each customer's record in Mongo and so on. Right now I ha...
Howdy guys, I'm pretty new to mongodb (only work with it for one small project) and I wanted to have your tips on how to organize my documents. My brain is not (yet) nosql formatted. I have a collection storing all kind of informations and I want to add tags to it. There will be 1-5 tags by document. I want to be able to search by tags ...
I have code like this in a Rails 3 app I'm working on <% @positions.each do |position| %> <tr class="<%= cycle("", "alternate") %>"> <td><%= position.name %></td> <td class="actions"> <%=link_to 'edit', edit_position_path(position), :class => 'edit' %> | <%=link_to 'delete', position_path...
Hi there I'm trying to run a query where I want to ignore records with a certain email address... @foo = Bar.all(:email => 'xxx') <--- Except I want to negate where this email address exists. Please let me know how I can do it. Thanks! ...
I seem to be unable to properly mount my mongoDB database as a drive using gridfs-fuse. Here are the steps I am following: I followed the directions listed here: http://www.coffeepowered.net/2010/02/24/serving-files-out-of-gridfs-part-2/. I am running Mac OS X Leopard (64 bit) and have mongodb running and linked at /opt/mongo. Scons ru...
I want to have dynamic fields in my database records. For example: I want to build an application for users to create their own forms. A user could create the following forms: Personal profile: Full Name Street Job Phone Home Work Mobile Interests Interest 1 Interest 2 Interest 3 Work: First name Last name Work Department ...
I have just started using mongoDb as my backend for PHP. I am simply using find() query for one of my needs. I want only first 100 results but also want to get total available results. I am trying this. $cursor = $this->dbReference->dbName->find($query); if($count != 0) { $cursor->skip($startIndex); ...
Hello all, I'm pretty new to rails and mongoid and I have a problem with extracting a string out of a query. I have a class Filteroption class Fieldoption include Mongoid::Document field :name, :type => String field :option_id, :type => Integer end and with this entries +--------------------------+-------------...
I need to store some objects of this classes: public class Category{ public ObjectId Id {get;set;} public string Name {get;set;} public string Description {get;set;} public List<Product> Products {get;set;} } public class Product{ public ObjectId Id {get;set;} public string Name {get;set;} public string Desc...
I am attempting to store over 200 million key value pairs. The value for over 50% of the keys will change over the course of the week, and about 5% of the rows will be permanently removed. Using traditional SQL solutions, this has proven to cause a large amount of fragmentation, causing table bloat (4x the original table size), and som...
I think these three are the most popular non-relational db:s out there at this moment. I want to give them a try, but I wonder which one of these are most suitable for Rails when it comes to Gem, documentation and tutorial support. Eg. if I install a very good gem that is for Rails but this just use AR and mongodb, then it would be a p...
If you have RDBMS you probably have to use Solr to index your relational tables to fully nested documents. Im new to non-sql databases like Mongodb, CouchDB and Cassandra, but it seems to me that the data you save is already in that document structure like the documents saved in Solr/Lucene. Does this mean that you don't have to use So...
I've read the MongoDB documentation, and it comes with a warning about 32-bit systems; particularly that they're capped at 2 GB of available RAM for Mongo. So I was wondering if that statement meant anything in regards in running MongoDB in a low memory setting like Linode's 512mb of RAM based VPS. I doubt it matters but with a 64-bit ...
I have stumbled upon Mongoid which has great documentation: http://mongoid.org/docs/associations/ But I have heard that MongomMapper is de-facto for Rails. Where do I find API documentation for using Mongomapper? ...
MongoDB has two popular ORMs for Rails: MongoID and MongoMapper. Are there CouchDB ORM:s for Rails 3? ...
Hello all, I just began using Mongoid last week. I am running into this association problem which I am unsure if my approach is correct. So i thought I would ask for some opinion I have a User model and a Project model class User include Mongoid::Document field :email end class Project include Mongo...
From MongoDB's webpage I understand that they are not supporting transactions fully, if any. I wonder if they are ever going to support it in the future so that I can store financial information in them, instead of using a RDBMS for it. And how is it with CouchDB, do they support transactions? ...