CODEWITHSUNDEEP
mongodbcouchdbnosql
Sonia
Sonia

Reputation: 1044

NoSQL Document DB

I am in a need for a document-oriented database for a project I am working on. I basically have two things I need: Full ACID support and the ability to have references. Scalability is not a major issue since the number of total users is at most 300.

I know MongoDB supports references between documents and CouchDB supports ACID but I have not found one that has both.

I am really trying to avoid implementing either (ACID, References) in the application layer. The obvious fallback is RDBMS with some tree structure implementation which I am also trying to avoid.

Any suggestions?

THANX

Upvotes: 3

Views: 344

Answers (3)

synhershko
synhershko

Reputation: 4492

Checkout RavenDB - it has both ACID and transaction support AND it supports the notion of relations between documents via Includes and Live Projections. Denormalization can probably come in handy, too.

Don't use an RDBMS if your business logic says it doesn't like it.

Upvotes: 4

JasonSmith
JasonSmith

Reputation: 73702

You require ACID and full references, and CouchDB is not good for that.

You do not require scalability either. My guess is a database that is well-known wouldn't hurt either.

For those reasons, a relational database sounds appropriate.

Upvotes: 5

user2665694
user2665694

Reputation:

You mentioned the constraints - you mentioned correctly what CouchDB/MongoDB give you. So based on those facts: use your fallback.

Upvotes: 1

Related Questions