---
title: "#190: RavenDB 4.0 Released"
publication: "DB Weekly"
issue: 190
published_at: "2018-02-09"
canonical_url: "https://dbweekly.com/issues/190"
---

Database Weekly 190   

This week's database news -[Read this on the Web](http://dbweekly.com/issues/190) 

[Database Weekly](http://dbweekly.com) Issue 190 — February 9, 2018     

[RavenDB 4.0 Released: A Transactional NoSQL Database](https://ayende.com/blog/181857-A/ravendb-4-0-is-out?Key=840274a1-9118-4b04-8eac-92122820ebd1) — 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 Rahiennews [An Advanced SQL Window Function Quiz](http://www.windowfunctions.com/) — _“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 Boottools [Use SQL in MongoDB? But of Course You Can. We'll Show You How](https://studio3t.com/download/?utm_source=Newsletter&utm_medium=DBWeekly&utm_campaign=Feb2018) — 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 3Tsponsored [![\](https://copm.s3.amazonaws.com/df8de44e.png)](https://studio3t.com/download/?utm_source=Newsletter&utm_medium=DBWeekly&utm_campaign=Feb2018) [Standard SQL Features Where PostgreSQL Beats Competitors](https://modern-sql.com/blog/2018-02/standard-sql-features-where-postgresql-beats-its-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](http://tapoueh.org/blog/2018/02/find-the-number-of-the-longest-continuously-rising-days-for-a-stock/) — 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 Fontainetutorial [Calculating Tupper’s Self-Referential Formula With SQL](https://blog.jooq.org/2018/02/05/calculating-tuppers-self-referential-formula-with-sql/) — This is very geeky but very cool. JooQtutorial [Why 2018 Will Be The Year of the Data Engineer](https://www.datanami.com/2018/02/05/2018-will-year-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. Datanamiopinion [How Erasure Coding Changes Hadoop Storage Economics](https://www.datanami.com/2018/02/07/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.”_ Datanamistory [Your Database Should Work Like a CDN (Says CockroachDB)](https://www.cockroachlabs.com/blog/distributed-database-performance/) — Could distributed database performance (both in terms of latency and uptime) be dramatically improved with CDN-like multi-region deployments? Sean Loiselleopinion [Big Data Driving Hyperscale Datacenter Surge](https://www.datanami.com/2018/02/07/big-data-driving-hyperscale-datacenter-surge/) — A surge in data analytics work is good news for companies supplying datacenters. Datanaminews [PostgreSQL 10.2, 9.6.7, 9.5.11, 9.4.16, and 9.3.21 Released](https://www.postgresql.org/about/news/1829/) — Fixes security, data corruption, and parallel query issues. postgresql.​orgnews [Elasticsearch To Soon Gain Built-In SQL Support](https://www.elastic.co/blog/this-week-in-elasticsearch-and-apache-lucene-2018-02-05) This Week in Elasticsearchnews [Amazon Aurora Now Compatible with MySQL 5.7](https://aws.amazon.com/about-aws/whats-new/2018/02/amazon-aurora-is-compatible-with-mysql-5-7/) Amazon Web Servicesnews [Proper Indexing Is Key to Database Performance, Let Percona Show You How](https://learn.percona.com/cp-indexes-recording) Perconasponsored [Configuring sql.DB for Better Performance](http://www.alexedwards.net/blog/configuring-sqldb) Alex Edwardstutorial [Powering PHP with JanusGraph](https://compose.com/articles/powering-php-with-janusgraph/) Don Omonditutorial [Creating Fast, Lightweight Testing Databases in Docker](https://medium.com/fintech-studios-engineering/creating-fast-lightweight-testing-databases-in-docker-2a8164d2f519) Kevin Barresitutorial [How to Find Unused Indexes in MongoDB](https://scalegrid.io/blog/how-to-find-unused-indexes-in-mongodb/) Dharshan Rangegowdatutorial [How to Pivot Data with SQL](https://modern-sql.com/use-case/pivot) Markus Winandtutorial [Solving a 'Reindeer Ordering' Logic Puzzle with SQL](https://www.damirsystems.com/reindeer-ordering/) Damir Sudarevictutorial [Running a 400+ Node Elasticsearch Cluster](http://underthehood.meltwater.com/blog/2018/02/06/running-a-400+-node-es-cluster/) Anton Hägerstrandstory [How Apache Kafka Inspired Salesforce's Platform Events Architecture](https://engineering.salesforce.com/how-apache-kafka-inspired-our-platform-events-architecture-2f351fe4cf63) Alexey Syomichevstory [Making 30x Performance Improvements on Yelp’s MySQLStreamer](https://engineeringblog.yelp.com/2018/02/making-30x-performance-improvements-on-yelps-mysqlstreamer.html) Abrar Sheikhstory [3 Essential DBA Career Priorities For 2018](https://www.forbes.com/sites/oracle/2018/01/15/3-essential-dba-career-priorities-for-2018/#4698bcfe13bc) — Could ‘self-driving’ databases change the game for DBAs in 2018? Jeff Erickson (Oracle)opinion [What Is Time Series Data and Why Should You Care?](https://www.influxdata.com/blog/what-is-time-series-data-and-why-should-you-care/) InfluxDatasponsored [Oracle NoSQL Database Now Downloadable in an Easier VM Format](https://blogs.oracle.com/nosql/announcing-oracle-nosql-database-virtual-machine-download) — If you want to get started quickly with Oracle’s NoSQL database in VirtualBox or VMWare Workstation, say. Michael Schulmantools [MongoDB Tools: A Directory of MongoDB Tools](http://mongodb-tools.com/) — And [issue 2 of our new MongoDB newsletter](https://mongodb.email/issues/2) just went up too. Ian Whalentools    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/190) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK