StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONoSQL technologies, use cases, strengths and weaknesses
text
Body
copied!<p>I really interesting in non relational databases, but due the many reason familiar only with the small part of it. So I want to list <strong>all NoSQL technologies you use with basic use cases, pros and cons.</strong> </p> <p>If you have some specific issues during the work with some technologies, interesting experience, etc. you are welcome to share it with community.</p> <hr> <p>Personally I worked with:</p> <p><strong>Mongodb:</strong></p> <p>Usecases: For my opinion is one of the best if you need good aggregation features, automatic replication. Good in scale. Have many features which allow using it like everyday use database and if for some reason you don't want to use SQL solution - Mongo could be the great choice. Also mongo is great if you need dynamic queries. And also mongodb support indexing - it's also important feature.</p> <p><em>Pros</em>: Fast, good scale, easy to use, internal geospatial Indexes</p> <p><em>Cons</em>: Comparatively slow write operation, blocking atomic operation could make a lot of problems. Memory consuming process could "eat" all available memory.</p> <p><strong>Couchdb:</strong> </p> <p>Usecases: I use it in Wiki liked project and I think for that cases is the perfect database. The fact that each document automatically saves in new revision during update helps to see all the changes. For accumulating, occasionally changing data, on which pre-defined queries are to be run. </p> <p><em>Pros</em>: Easy to use, REST oriented interface, versions.</p> <p><em>Cons</em>: Problem with performance when amount of docs is quite huge (more than half a million), a bit pure query features (could be solving with adding Lucene)</p> <p><strong>SimpleDB:</strong></p> <p>Usecases: This is dataservice from Amazon, the cheapest from the all stuff they provide. Very limited in features so the main use case is using it if you want to use Amazon service, but paying as less ass possible.</p> <p><em>Pros</em>: Cheap, all data stored like text - simple to operate, easy to use.</p> <p><em>Cons</em>: Very much limitation (document size, collections size, attribute count, attribute size). The way that all data stored like a text also creating additional problems during sorting by date or by number (because it use lexicographical sorting, which need some workaround when saving date or numbers).</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload