Databases using JSON as storage/transport format

Question

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.

score 14 · Answer 1 · answered May 13 '09 at 18:00

14

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

answered May 13 '09 at 18:00

Jason

271
1
2

Sounds interesting, any experiences with performance? – miku Feb 21 '12 at 17:14

score 12 · Accepted Answer · answered Jul 27 '09 at 17:42

12

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.

answered Jul 27 '09 at 17:42

Sam Corder

5,374
3
25
30

2

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 Apr 01 '10 at 06:14

score 9 · Answer 3 · edited Jan 05 '13 at 14:46

9

This is a non-authoritative list.

Source: Wikipedia - Document Oriented Databases

edited Jan 05 '13 at 14:46

Perception

79,279
19
185
195

answered Jan 05 '13 at 08:45

ProllyGeek

15,517
9
53
72

score 4 · Answer 4 · answered Dec 23 '12 at 03:55

4

postgresql recently added a json datatype

postgre json datatype

answered Dec 23 '12 at 03:55

alzclarke

1,725
2
17
20

score 3 · Answer 5 · answered Apr 03 '13 at 12:35

3

MongoDB does not use JSON but BSON.

RethinkDB is a document oriented database with a JSON data model, which supports sharding and replication

answered Apr 03 '13 at 12:35

nairboon

678
5
15

score 2 · Answer 6 · answered Jul 19 '10 at 18:07

2

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.

answered Jul 19 '10 at 18:07

Syd

101
1

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... – user359996 Oct 05 '10 at 01:43

score 2 · Answer 7 · answered Mar 08 '12 at 01:30

2

If you want to store your JSON document in AppEngine's Datastore, you can have a look at Ubud-db, https://bitbucket.org/f94os/ubud-db/wiki Ubud-db is a Document store on AppEngine with a REST-JSON API.

answered Mar 08 '12 at 01:30

sosandstrom

51
3

Databases using JSON as storage/transport format

7 Answers7

Linked