News for hackers. Stuff that matters.
Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by baldfat on Tuesday October 13, 2015 @11:33AM (#10381127)
I was kind of shocked how good PostgesSQL did.

I still think PostgresSQL and MariaDB are a better tool for most jobs considered big data.

Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by JamesMcMinn on Tuesday October 13, 2015 @01:11PM (#10381865)
Postgres was actually somewhat crippled in these tests since they used json rather than jsonb for storage, which stores the json in a binary format which doesn't need to be serialised on reads.
Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by lobster_johnson on Tuesday October 13, 2015 @03:00PM (#10382669)
That's not quite correct. The jsonb requires that reads deserialize jsonb into textual JSON, whereas the json type can be sent directly to the client with no processing.

jsonb is superior when:

1. You want to use any of the built-in JSON functions, e.g. for extracting fields from the document.

2. You want to index the JSON (either the entire thing via GIN, or individual fields via ordinary B-tree indexes).

3. You want to save space; jsonb strips whitespace.

jsonb incurs an overhead on both reads and writes since it must serialize to/from textual JSON.

Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by yahliwharton on Tuesday October 13, 2015 @11:44AM (#10381194)
This is not a cluster test. NoSQL databases in general are optimized for scaling horizontally on commodity hardware. That's more tricky in RDBMS.
Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by collyw on Tuesday October 13, 2015 @11:52AM (#10381259)
Most people I have spoken to are using NoSQL on single nodes.
Re:NoSQL Benchmark Compares PostgreSQL, MongoDB, Neo4j, Orie... by brightball on Tuesday October 13, 2015 @12:10PM (#10381393)
I think a lot of people jump on NoSQL solutions when scale out isn't needed because of the permeating "do everything in the application / client" mentality these days.