Greg, there is an article on the Red Gate / Simple-Talk website that you may be interested to read –
Does NoSQL = NoDBA? https://www.simple-talk.com/opinion/opinion-pieces/does-nosql--nodba In passing, the author mentions a number of other NoSQL database systems - MongoDB, CouchDB, Cassandra, Riak, Voldemort. What interested me was the discussion of the CAP Theorem (in the context of distributed systems, Big Data) and “eventual consistency” of NoSQL queries, versus the enforced consistency of relational databases. >From my reading, the absence of (a wider range of) typed data fields for NoSQL >databases is probably because of their irrelevance - and the absence of GUID >fields is of no concern in the context of their principal use cases. _____ Ian Thomas Albert Park, Victoria From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Saturday, November 01, 2014 7:35 AM To: ozDotNet Subject: Re: SQLite déjà vu again Well, it's not all hugs and puppies, as BrightstarDB failed my very first test to use it in a real application. Its Entity Framework like layer does not support Guid properties. This is utterly inconceivable and unexpected, and it renders the library completely useless to me. I have posted into their forum suggesting that adding unconditional support for Guids must be of the highest priority -- Greg K On 31 October 2014 18:36, Greg Keogh <g...@mira.net> wrote: On 30 October 2014 19:19, <osjasonrobe...@gmail.com> wrote: BrightstarDB - http://brightstardb.com/ may be of interest… After fiddling with this for half an hour I'm starting to think this product is a work of art! It's pleasing to discover a managed product that is well thought-out, elegantly layered, (quite) well documented, well tooled, uncluttered, and free. I had the samples working in minutes without a glitch, and most importantly they worked in a really familiar style. You can work with two lower levels of API or at the higher "entity" level. They have VS templates to add interfaces from which a T4 template will generate EF-like entities. In fact they've mimicked EF with amazing fidelity, even relationship collections. It's weird to find a NoSql database that supports "joins". I don't know yet how much of EF's IQueryable behaviour they've reproduced. They foolishly seem to have created their own query language called SPARQL. I'm going to investigate BrightstarDB in much more detail and I'll report any startling news. Anyone else here using it? Greg K