All Questions

88
votes
15answers
130966 views

Storing Data in MySQL as JSON

I thought this was a n00b thing to do. And, so, I've never done it. Then I saw that FriendFeed did this and actually made their DB scale better and decreased latency. I'm curious if I should do this. ...
74
votes
7answers
23829 views

Can I do transactions and locks in CouchDB?

I need to do transactions (begin, commit or rollback), locks (select for update). How can I do it in a document model db? Edit: The case is this: I want to run an auctions site. And I think how to...
64
votes
6answers
36866 views

Pros/cons of document-based databases vs. relational databases

I've been trying to see if I can accomplish some requirements with a document based database, in this case CouchDB. Two generic requirements: CRUD of entities with some fields which have unique i...
216
votes
3answers
53469 views

Difference between CouchDB and Couchbase

Are there any essential differences between CouchDB and Couchbase which makes one or the other preferable to use?
32
votes
1answers
11268 views

Best way to do one-to-many "JOIN" in CouchDB

I am looking for a CouchDB equivalent to "SQL joins". In my example there are CouchDB documents that are list elements: { "type" : "el", "id" : "1", "content" : "first" } { "type" : "el", "id" : "2...
24
votes
12answers
24122 views

Full-text search in NoSQL databases

Has anyone here have any experience deploying a real online system that had a full text search in any of the NoSQL databases? For example, how does the full-text search compare in MongoDB, Riak and ...
168
votes
5answers
36831 views

Why should I use document based database instead of relational database?

Why should I use document based database like CouchDB instead of using relational database. Are there any typical kinds of applications or domains where the document based database is more suitable th...
135
votes
10answers
26196 views

Use cases for NoSQL

NoSQL has been getting a lot of attention in our 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 t...
42
votes
3answers
12566 views

Pagination in CouchDB?

How would I go about implementation the queries required for pagination? Basically, when page 1 is requested, get the first 5 entries. For page 2, get the next 5 and so on. I plan to use this via th...
11
votes
1answers
2494 views

How can I use my sql knowledge with Cloudant/CouchDB?

Some developers who have a good knowledge of querying SQL databases struggle to implement the equivalent query patterns in Cloudant/CouchDB. How can these developers translate their SQL knowledge to ...

Previous Next