Using CouchDB, I currently have a document which represents an idea, you can rate this idea. Every idea is one document and every rating is a different document. I am doing this like this to avoid concurrent access problems when people are rating an idea. My documents look like that (I have simplified them): An idea: { "_id": "idea1"...
I am looking at implementing a CouchDB server to provide ad-hoc searching of some metadata that we store for an internal business operation. We store a number of "attributes" like size, source, submit date, and URL for the "jobs" in our internal process. This is all well and good in our relational database, but our users would like to ...
I have tried MongoMapper and it is feature complete (offering almost all AR functionality) but i was not very happy with the performance when using large datasets. Has anyone compared with Mongoid? Any performance gains ? ...
do any of these nosql type databases have GUI explorers where you can run queries, view the "tables" and their attributes etc? ...
I'm looking a way to automate schema migration for such databases like MongoDB or CouchDB. Preferably, this instument should be written in python, but any other language is ok. ...
I need to design / architect / develop a web based social network type application. Basic functionality: - users create accounts on the system - users agree to "friend" each other - users create content within system - users specifies which friends may view/edit content that they created Surely this core functionality has been cr...
I am trying to use this software called InfoGrid for a project that I am building. Can someone please point me to some basic getting started articles. I don't see any documentation on the site. Peopl with enough reputations, please edit the question and add the tag InfoGrid to this question. ...
I'm a .NET programmer and want to have a look at a alternative to RDBMS. What is the moste mature choice at the moment (most mature drivers and most functionality in the database)? I have looked at MongoDB and I'm pleased with it. ...
Hi, I have gone through some articles regarding Bigtable and NOSQL. It is very interesting that they avoid JOIN operations. As a basic example, let's take Employee and Department table and assume the data is spread across multiple tables / servers. Just want to know, if data is spread across multiple servers, how do we do JOIN or UNI...
I have heard that Amazon uses a key-value data store - that it does not use a traditional relational normalized db. Speaking as someone who only has used the traditional approach, how does this work? Don't you need to do the following? select * from book where book_id = n Or a: select * from book where author_id = y How can you b...
Do you know any SQLite-like database that stores its data in easily readable plain text format (like multi-line json or yaml)? I'd like to store some data along with my project in version control system but if I use sqlite I can't merge data changes that occurred in different working copies. I don't want to use just some kind of config...
Has any of you had any experience with using NoSQL (non-relational) databases to store spatial data? Are there any potential benefits (speed, space, ...) of using such databases to hold data for, say, a desktop application (compared to using SpatiaLite or PostGIS)? I've seen posts about using MongoDB for spatial data, but I'm interested...
I'm thinking about using/implementing some kind of an embedded key-value (or document) store for my Windows desktop application. I want to be able to store various types of data (GPS tracks would be one example) and of course be able to query this data. The amount of data would be such that it couldn't all be loaded into memory at the sa...
I've been thinking for a while about modeling typical ecommerce site with ebay-like taxonomy and attributes dependent on a particular product category. First attempt was choosing between EAV and Table Per Class db inheritance modeling. I've chosen the latter because of the performance, but what it meant was creating dedicated table for ...
Hi, Is there a key value store that will give me the following: Allow me to simply add and remove nodes and will redstribute the data automatically Allow me to remove nodes and still have 2 extra data nodes to provide redundancy Allow me to store text or images up to 1GB in size Can store small size data up to 100TB of data Fast (so w...
I recently came across http://www.fossil-scm.org/index.html/doc/tip/www/theory1.wiki by D. Richard Hipp, the developer responsible for SQLite. it go me thinking, is Fossil the only NoSQL database that uses SQL? Do others uses SQL as a 'High Level Scripting Language'? ...
Anyone have any recommendations for a non-relational/partially-relational DB with a .NET API? ...
I am having trouble grasping how to filter embedded documents in MongoDB, and am starting to think I should be using a relational association, but that feels wrong in the document-store context. Sticking with a typical blog/comment system, I have a collection of blogs, and each blog has many comments. The comments are stored as embedde...
Hello all, I'm working on an application that I'm going to write with C and i am considering to use a nosql db for storing timeseries data with at most 8 or 9 fields. But in every 5 minutes there will huge write operations such as 2-10 million rows and then there will be reads(but performance is not as crucial in read as in the write op...
Hi, Has anyone had any experience with the Esent database engine? I've been taking a look at what it's used for, and am getting excited. Active Directory is implemented on top of an Indexed Sequential Access Method (ISAM) table manager, historically called "Jet." This same table manager is used by Exchange, File Replication service ...