News for hackers. Stuff that matters.

A comment on Why some NoSQL DBs only let you perform transactions on a single data item.

Re:Why some NoSQL DBs only let you perform transactions on a... by judah on Friday October 30, 2015 @10:13AM (#10477904)
On the .NET stack, RavenDB[0] supports transactions on multiple items[1].

RavenDB is a nice middle ground: eventual consistency for queries for speed, but ACID for create, update, and load (one or more items by ID).

It uses transactions throughout, so a failure in the midst of 10 writes will rollback all of them, as one would expect in a traditional relational database.

[0]: http://ravendb.net/

[1]: http://ravendb.net/docs/article-page/3.0/csharp/start/gettin...

[ Parent | on HN ]
Re:Why some NoSQL DBs only let you perform transactions on a... by polskibus on Friday October 30, 2015 @10:44AM (#10478088)
It does indeed look nice, however the pricing looks worse than MS SQL in the long run (for the enterprise version).
[ Parent | on HN ]
Re:Why some NoSQL DBs only let you perform transactions on a... by judah on Monday November 02, 2015 @03:15PM (#10494847)
It's free for open source projects.

For commercial enterprise, Raven is effectively $788/core/year [0]. Quite reasonable, IMO.

Contrast this with MS SQL Server Enterprise, which appears to be $14,000/core one-time cost [1].

(Disclaimer: I'm a part-time employee for RavenDB. But I loved and used Raven on my own projects before becoming an employee.)

[0]: http://ravendb.net/buy [1]: http://www.microsoft.com/en-us/server-cloud/products/sql-ser...

[ Parent | on HN ]
Re:Why some NoSQL DBs only let you perform transactions on a... by arosenbaum on Friday October 30, 2015 @02:41PM (#10479683)
How can one possibly be eventually consistent for reads and ACID for updates? Unless you are saying the datasets available for fast queries cannot be updated consistently...Or are you just saying, you can read from replicas but maintain a single master...
[ Parent | on HN ]
Re:Why some NoSQL DBs only let you perform transactions on a... by judah on Monday November 02, 2015 @03:11PM (#10494813)
Direct reads (by ID) and writes are ACID.

Complex queries are eventually consistent.

Hope this helps. I'm @judahgabriel if you have more questions.

[ Parent | on HN ]