MongoDB doesn’t support keys with a dot in them so you’re going to have to preprocess your JSON file to remove/replace them before importing it or you’ll be setting yourself up for all sorts of problems. There isn’t a standard workaround to this issue, the best approach is too dependent upon the specifics of the … Read more
The main difference is that document stores (e.g. MongoDB and CouchDB) allow arbitrarily complex documents, i.e. subdocuments within subdocuments, lists with documents, etc. whereas column stores (e.g. Cassandra and HBase) only allow a fixed format, e.g. strict one-level or two-level dictionaries.
I’ve only just started with non-relational DBs, and I am still trying to wrap my head around it and figure out what the best model would be. And I can only speak for CouchDB. Still, I have some preliminary conclusions: Have you come up with alternate designs that work much better in the non-relational world? … Read more
Redis Commander is great if you’re using node.js already. Super simple to get going with NPM: npm install -g redis-commander redis-commander Then point your browser at the address in the console
How to design table like this in mongodb? First, to clarify some naming conventions. MongoDB uses collections instead of tables. I think there are no foreign keys! Take the following model: student { _id: ObjectId(…), name: ‘Jane’, courses: [ { course: ‘bio101’, mark: 85 }, { course: ‘chem101’, mark: 89 } ] } course { … Read more
Here’s a quote from a recent blog post from Dare Obasanjo. SQL databases are like automatic transmission and NoSQL databases are like manual transmission. Once you switch to NoSQL, you become responsible for a lot of work that the system takes care of automatically in a relational database system. Similar to what happens when you … Read more
If you have virtual memory functionality turned on (EDIT: now deprecated), then Redis starts to store the “not-so-frequently-used” data to disk when memory runs out. If virtual memory in Redis is disabled (the default) and the maxmemory parameter is set (the default), Redis will not use any more memory than maxmemory allows. If you turn … Read more
What I ideally want to do is call LogTable.DeleteItem(user_id) – Without supplying the range, and have it delete everything for me. An understandable request indeed; I can imagine advanced operations like these might get added over time by the AWS team (they have a history of starting with a limited feature set first and evaluate … Read more
All the answers for how to store many-to-many associations in the “NoSQL way” reduce to the same thing: storing data redundantly. In NoSQL, you don’t design your database based on the relationships between data entities. You design your database based on the queries you will run against it. Use the same criteria you would use … Read more