DB Weekly Issue 155: May 19, 2017

Google's 'Cloud Spanner' Is Now Production Ready — A globally-distributed relational database service with ACID transactions and SQL semantics. WIRED’s writeup (from Feburary) gives the bigger picture of why it’s a big deal.

Google BigQuery Now Offers 10GB of Free Storage — BigQuery has long provided an easy way to analyze massively large datasets and now there’s a free storage tier to make getting started even easier.

PostgreSQL 10 Beta 1 Released — A big release is on the way later this year featuring logical replication and native table partitioning. Here’s slides covering the changes, plus a look at incompatible changes.

Whitepaper: 5 Steps to Agile Database Management — Database Management is years behind software development. Here’s how to bring your DBs up to speed.

Google Spanner: Becoming a SQL System — An academic paper presented at SIGMOD 17 that digs into the specifics of the Spanner globally-distributed data management system Google uses (as mentioned above).

Badger: A High-Perf Key/Value Storage Engine — An embeddable, persistent, simple and fast key-value store, written natively in Go. GitHub repo.

Neo4j 3.2 Released with Multi Datacentre Support — It’s now easier to run the graph database across continents. There are also production governance (e.g. Kerberos auth), query monitoring, and performance improvements.

Committers Talk Hadoop 3 at Apache Big Data — Focusing mostly on the forthcoming addition of erasure coding to HDFS which is well explained here.

Enhancements and What's New in Hadoop 3.0 — A brief overview of incoming changes in Hadoop 3 and their benefits.

How to migrate from RDBMS to MongoDB — Learn why today's most innovative companies are migrating to MongoDB.

The Many Faces of DISTINCT in Postgres

Playing with SQL Server 2017's 'SQL Graph'

10 Techniques to Boost Your Data Modeling

The Motivation for Native Graph Databases

Crunching Machine Learning And Databases Together on GPUs — A look at accelerating relational DB processing with GPUs.

CIOs Growing Weary of Database Lock-In, Increasingly Buying Into Open Source — Oracle is slipping in its hold on the database market, but it’s going to take a long time to topple.

JSONata: A Declarative Syntax for Querying JSON Data

ToroDB: A Layer That Turns Postgres Into a NoSQL Database

SQLPad: Webapp to Run SQL Queries and Visualize Results — Run SQL in your browser, chart the results. Supports MySQL, SQL Server and Vertica.

Manage all your Database-as-a-service needs in one place — Manifold is your hub for amazing developer services, like JawsDB and RedisGreen

SQL Notebook: A Windows App to Explore Tabular Data — Related Hacker News discussion.

Trinity: A High Performance, C++ Search Library — A building block for your own search engines.