Issue 81 — November 27, 2015
Featured
50 Shades of NULL —
Subtitled "How a Billion Dollar Mistake has Been Stalking a Whole Industry for Decades", this is a look at the history of nil/null values and how NULL works in SQL.
Lukas Eder
What NoSQL Solution Should You Choose? —
Quick summaries of MongoDB, Elasticsearch, OrientDB, Hadoop, and Cassandra, focusing on what each can and can’t do.
Kuzzle opinion
Heroic: A Time Series Database from Spotify —
Heroic is an open-source monitoring system originally built at Spotify to address the problems being faced with large scale gathering and near real-time analysis of metrics.
Spotify code
Have you got SQL fingers? — Watch these free SQL Prompt tips videos for SQL writing hints from top SQL Server MVPs. SQL Prompt is the SQL code productivity add-in for SQL Server Management Studio and Visual Studio. Find out how easily you can write SQL.
Red Gate Software sponsored
Organize Complex Queries Using SQL's 'WITH' —
SQL:1999 introduced the ‘WITH’ clause to define "views" within queries. These with-queries are only visible in a single statement and can be used to improve the structure of this statement without polluting the global namespace.
Markus Winand
Apache Geode: A Distributed, In-Memory Low Latency Database —
The Apache-incubated open source version of a commercial in-memory database called GemFire.
Apache
HyperLogLog in Pure SQL —
Hyperloglog is a very interesting algorithm and you can have an extremely efficient version directly in Postgres. And if you’re not up for building and pulling in your own extensions here’s a raw SQL implementation of it.
Periscope
10 Use Cases Where NoSQL Will Outperform SQL —
Written by a director at Couchbase.
Network World opinion
Jobs
Freelance with Companies like Airbnb, IDEO, & JPMorgan — Work with top clients, set your own rates, and work from anywhere as an elite Toptal developer. Join the most exclusive network of top software engineers in the world.
Toptal
In brief
Leandro Toniut news
Salvatore Sanfilippo news
Redis Performance Dashboard and Autoscaling from RedisGreen — Seamless scaling and analytics backed by support from engineers who have been scaling Redis for years.
RedisGreen tools sponsored
Periscope tutorial
Josh Rendek tutorial
Agata Kwapien tutorial
Matt Ingenthron tutorial
Wolfgang Beer tutorial
Dick Dowdell tutorial
Citus Data tools
Cloudmonix tools
Segment opinion
Martin Goodwell opinion