Issue 190 — February 9, 2018
RavenDB 4.0 Released: A Transactional NoSQL Database — A fully transactional all-in-one document database. 4.0 is 10x faster than 3.0 and it now runs on Windows, Linux, Mac and in Docker.
Ayende Rahien news
An Advanced SQL Window Function Quiz — "A lot has changed since SQL-92," they say, so why not test out your knowledge. You’ll need to be familiar with
SUM and HAVING to just pass Q1, by the way.. Andy Boot tools
Use SQL in MongoDB? But of Course You Can. We'll Show You How — And there's so much more to discover. Like SQL Import & Export. Or our innovative Query Code that lets you instantly generate code from our Query Builder in Node.js, Python, or C#.
Studio 3T sponsored
Standard SQL Features Where PostgreSQL Beats Competitors — Code-heavy slides from a talk given at FOSDEM PgDay that cover filters, BOOLEAN tests, XMLTABLE, and inverse distribution functions.
Markus Winand
Find the Longest Continuous Number of Days a Stock Went Up — We all love a good, thorough SQL tutorial, right? This is a great walkthrough of bringing together several SQL features in a relatively advanced way.
Dimitri Fontaine tutorial
Calculating Tupper’s Self-Referential Formula With SQL — This is very geeky but very cool.
JooQ tutorial
Why 2018 Will Be The Year of the Data Engineer — Every indicator I’ve seen in recent years shows no possibility of work slowing down for good data engineers and data from Glassdoor and Indeed seems to confirm it.
Datanami opinion
How Erasure Coding Changes Hadoop Storage Economics — "The introduction of erasure coding with Hadoop 3.0 will allow users to cram up to 50% more data into the same cluster."
Datanami story
Your Database Should Work Like a CDN (Says CockroachDB) — Could distributed database performance (both in terms of latency and uptime) be dramatically improved with CDN-like multi-region deployments?
Sean Loiselle opinion
Big Data Driving Hyperscale Datacenter Surge — A surge in data analytics work is good news for companies supplying datacenters.
Datanami news
PostgreSQL 10.2, 9.6.7, 9.5.11, 9.4.16, and 9.3.21 Released — Fixes security, data corruption, and parallel query issues.
postgresql.org news
This Week in Elasticsearch news
Amazon Web Services news
Percona sponsored
Alex Edwards tutorial
Don Omondi tutorial
Kevin Barresi tutorial
Dharshan Rangegowda tutorial
Markus Winand tutorial
Damir Sudarevic tutorial
Anton Hägerstrand story
Alexey Syomichev story
Abrar Sheikh story
3 Essential DBA Career Priorities For 2018 — Could ‘self-driving’ databases change the game for DBAs in 2018?
Jeff Erickson (Oracle) opinion
InfluxData sponsored
Oracle NoSQL Database Now Downloadable in an Easier VM Format — If you want to get started quickly with Oracle’s NoSQL database in VirtualBox or VMWare Workstation, say.
Michael Schulman tools
MongoDB Tools: A Directory of MongoDB Tools — And issue 2 of our new MongoDB newsletter just went up too.
Ian Whalen tools