RE: SQLite déjà vu again

2014-11-03 Thread ILT (O)
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

 

 

 



Re: SQLite déjà vu again

2014-11-03 Thread Greg Keogh

 Does NoSQL = NoDBA?

 https://www.simple-talk.com/opinion/opinion-pieces/does-nosql--nodba


Ah yes, a different type of DBA will evolve.


 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.


When I'm round-tripping stuff from managed code and any database I expect
natural feeling CLR type support, I don't want to have to transform data as
it goes in and out. I received a rapid reply from a BrightstarDB developer
who had added Guid property support into their developer branch. I don't
know if that includes support for Guids as primary keys, as I couldn't coax
their latest source download into compiling.

Cheers, Greg

P.S. Have you moved to Vic from WA?