Must read resources for NoSQL developers.
Can you recommend any resources every NoSQL developer should be familiar with? ...
nosql
how to Solve the "Digg" problem in MongoDB
A while back,a Digg developer had posted this blog ,"http://about.digg.com/blog/looking-future-cassandra", where the he described one of the issues that were not optimally solved in MySQL. This was cited as one of the reasons for their move to Cassandra. I have been playing with MongoDB and I would like to understand how to impleme...
Is there any good guide for using the Cassandra Command line Interface?
I wanted to try out Cassandra, and thought the easiest way to get up and running would be via the command line. I was wondering if there is a good guide to using the cli tool that is shipped with Cassandra. I am primarily looking for options to create column families, super columns, insert sample data and query them. The documentation on...
What permissions do I need to grant to run RavenDB in Server mode?
I'm reading through Rob Ashton's excellent blog post on RavenDB: http://codeofrob.com/archive/2010/05/09/ravendb-an-introduction.aspx and I'm working through the code as I read. But when I try to add an index, I get a 401 error. Here's the code: class Program { static void Main(string[] args) { using (var documentStor...
'schema' design for a social network
I'm working on a proof of concept app for a twitter style social network with about 500k users. I'm unsure of how best to design the 'schema' should I embed a user's subscriptions or have a separate 'subscriptions' collection and use db references? If I embed, I still have to perform a query to get all of a user's followers. e.g. Giv...
Graph-structured databases and Php
I want to use a graph database using php. Can you point out some resources on where to get started? Is there any example code / tutorial out there? Or are there any other methods of storing data that relate to each other in totally random/abstract situations? - Very abstract example of the relations needed: John relates to Mary, both ...
Document-oriented database - What if the document definitions change?
As I understand it, you can enter any non-structured information into a document-oriented database. Let's imagine a document like this: { name: 'John Blank', yearOfBirth: 1960 } Later, in a new version, this structure is refactored to { firstname: 'John', lastname: 'Blank', yearOfBirth: 1960 } How do you do this with Docu...
How does CouchDB perform for a regularly updated dataset?
I am planning on using CouchDB on a project. But as the querying mechanism involves writing views (which are a lot like indexes on regular RDMBMS's) I was wondering, if the document database keeps getting updated a lot ( a write heavy database) would CouchDB perform well compared to a regular RDBMS? Or do we have to compact/re-index the ...
NoSQL or Ehcache caching ?
I'm building a Route Planner Webapp using Spring/Hibernate/Tomcat and a mysql database, I have a database containing read only data, such as Bus Stop Coordinates, Bus times which is never updated. I'm trying to make the app run faster, each time the application is run it will preform approx 1000 reads to the database to calculate a rout...
How to combine conditional operator in NoRM driver for MongoDB
Hi guys In mongo native api it is possible to do following: db.collection.find({ "field" : { $gt: value1, $lt: value2 } } ); // value1 < field < value How could I achieve the same with NoRM Best regards, Dmitry Egorov ...
Use cases for NoSQL
NoSQL has been getting a lot of attention in the industry recently. I'm really interested in what peoples thoughts are on the best use-cases for its use over relational database storage. What should trigger a developer into thinking that particular datasets are more suited to a NoSQL solution. I'm particularly interested in MongoDB and C...
Are there any Design Guidelines for Documental Databases?
Just wondering if there are any kind of guidelines for when you are designing a document-oriented db and I am talking especially about CouchDb. I know that being schemaless things can take the shape that we want but, are there any best practices? Thanks in advance! =D ...
Perform case-insensitive lookup on an Array in MongoDB?
So, I've decided to get my feet wet with MongoDB and love it so far. It seems very fast and flexible which is great. But, I'm still going through the initial learning curve and as such, I'm spending hours digging for info on the most basic things. I've search throughout the MongoDB online documentation and have spent hours Googling th...
File Storage for Web Applications: Filesystem vs DB vs NoSQL engines
I have a web application that stores a lot of user generated files. Currently these are all stored on the server filesystem, which has several downsides for me. When we move "folders" (as defined by our application) we also have to move the files on disk (although this is more due to strange design decisions on the part of the origina...
Can DBRefs contain additional fields?
I've encountered several situations when using MongoDB that require the use of DBRefs. However, I'd also like to cache some fields from the referenced document in the DBRef itself. {$ref:'user', $id:'10285102912A', username:'Soviut'} For example, I may want to have the username available even though the user document is referenced. ...
What options are there for Free for commercial use NoSql Datastores for the .NET world?
I've been looking around.... MongoDB seems to require a commercial license. http://www.mongodb.org/display/DOCS/Licensing RavenDB has quite a costly scheme. http://ravendb.net/licensing CouchDB, seems to be free for commercial use? But requires Apache, which is a bit of a pain. Are there any other good options for .NET? ...
Neo4j Performing shortest path calculations on stored data
I would like to store the following graph data in the database, graph.makeEdge( "s", "c", "cost", (double) 7 ); graph.makeEdge( "c", "e", "cost", (double) 7 ); graph.makeEdge( "s", "a", "cost", (double) 2 ); graph.makeEdge( "a", "b", "cost", (double) 7 ); graph.makeEdge( "b", "e", "cost", (double) 2 ); Then run the Dijskra algorighm...
Searching by key in Apache CouchDB
Is it possible to search by key value in Apache CouchDB? Given the sample data below (spaced for readability): { "_id":"a754a63dcc7f319b02f7ce6de522ca26", "_rev":"1-5bd88e53fe0869b8ce274b49a2c1ddf5", "name":"john smith", "email":"[email protected]", "username":"jsmith" } Could I query the database for the user j...
NoSQL vs Relational Coding Styles
When building objects that make use of data stored in a RDBMS, it's normally pretty clear what you're getting back, as dictated by the tables and columns being queried. However, when dealing with NoSQL, document-based systems, it's less clear what is being retrieved. What are common methods of keeping track of structure in which data...
MongoDB Schema Design - Real-time Chat
I'm starting a project which I think will be particularly suited to MongoDB due to the speed and scalability it affords. The module I'm currently interested in is to do with real-time chat. If I was to do this in a traditional RDBMS I'd split it out into: Channel (A channel has many users) User (A user has one channel but many messag...