views:

843

answers:

3

How many database systems there are that use JSON for storage or transport? I know of:

I remember I saw yet another vendor in a SO user's profile. That systems was using what they called binary JSON, but I can't remember the name of the product.

Lately, it appears that more and more DB projects are looking towards JSON for persistence storage. Some of them are even embracing HTTP as a transport layer.

+6  A: 

Persevere is another DB that is loaded up with JSON:

http://www.persvr.org/

Primary transport is JSON HTTP/REST

Data is stored as JSON

It has a native JS/JSON client for running directly from the browser.

If you want a schema then it is defined using JSON

Jason
+4  A: 

MongoDb is the one that uses a binary JSON storage format. I don't know if there is another that is document oriented. Most of the others are key value stores and can only retrieve an object based on one key.

Sam Corder
One minor thing to note is that "binary JSON" is sort of misnomer: it should be more like "binary JSON-like format". This because it has both more datatypes than JSON (extension); and because it can not express all legal JSON values and constructs (subset) due to size limitations (size prefixes of limited size).
StaxMan
+1  A: 

Take a look at Basho's Riak. It has a number of things in common with CouchDB: Erlang-based, Javascript MapReduce API, HTTP transport, JSON document format and multi-master replication. It doesn't aim to be quite as simple as CouchDB (CouchDB is more "opinionated"), but they give you a lot of options for adjusting CAP parameters to meet the needs of your application, per-write.

Syd
Also has automatic scale-out and scale-in. Another big plus over CouchDB, for some use cases, is Riak's support for "links" (essentially pointers). It's a real shame it hasn't caught on as much as some of the others...