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.
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
to just pass Q1, by the way..
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#.
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.
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.
Calculating Tupper’s Self-Referential Formula With SQL
— This is very geeky but very cool.
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.
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.”
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?
Big Data Driving Hyperscale Datacenter Surge
— A surge in data analytics work is good news for companies supplying datacenters.
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.
Elasticsearch To Soon Gain Built-In SQL Support
This Week in Elasticsearch
Amazon Aurora Now Compatible with MySQL 5.7
Amazon Web Services
Proper Indexing Is Key to Database Performance, Let Percona Show You How
Configuring sql.DB for Better Performance
Powering PHP with JanusGraph
Creating Fast, Lightweight Testing Databases in Docker
How to Find Unused Indexes in MongoDB
How to Pivot Data with SQL
Solving a 'Reindeer Ordering' Logic Puzzle with SQL
Running a 400+ Node Elasticsearch Cluster
How Apache Kafka Inspired Salesforce's Platform Events Architecture
Making 30x Performance Improvements on Yelp’s MySQLStreamer
3 Essential DBA Career Priorities For 2018
— Could ‘self-driving’ databases change the game for DBAs in 2018?
Jeff Erickson (Oracle)
What Is Time Series Data and Why Should You Care?
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.
MongoDB Tools: A Directory of MongoDB Tools
issue 2 of our new MongoDB newsletter
just went up too.