DB Weekly
Issue 43 — December 19, 2014
Supported by

DB Weekly will be taking a break over the holiday season and should be back on Friday, January 9. Have a happy holiday season!

ACM Queue
Rick Richardson analyzes how picking a database technology is really about making smart tradeoffs and compromises in the face of your data model and required performance level.

With the new JSONB data type for PostgreSQL, users no longer have to choose between relational and non-relational data stores: they can have both at the same time.

Emir Ozer
Generates fake but valid data-filled databases for testing purposes, currently with support for SQLite, MySQL, Postgres, and MongoDB.

Rackspace   Sponsored
Want to learn some Hadoop, eh? Well, get ready to drink from the fire hose, because the Hadoop ecosystem is crammed full of software, much of which duplicates efforts, and much of which is named so similarly that it’s very confusing for newcomers. Learn more about the core pieces of Hadoop functionality.


Mac App Store
Supports MySQL, PostgreSQL, SQLite, MongoDB and Redis.

Dave Finnegan
Covers MongoDB’s data model, high availability through replication, scalability through sharding, and more.

Alexander Stocko
kdb+ is a high performance time-series column-oriented database implemented in the K language and widely deployed within the financial sector.

Erick Tryzelaar
We covered MDBM last week.

A look at FoundationDB fresh off the back of their feat of hitting 14.4 million random writes per second on a cluster last week.

SQL, NoSQL, KnowSQL are all overloaded terms. Postgres has long taken a liberal approach to datatypes and schema-less datatypes play very well in its world. Here’s a broader article that hints at much of this if you need a case vs. relational/NoSQL because with Postgres you really can have your cake and eat it too.

Given FoundationDB’s clear focus on performance, the answer obviously quickly veers towards yes.


    In brief