#222 — September 21, 2018

Read on the Web

Database Weekly

Google Cloud Inference API: To Analyze Large Scale Time-Series Data — A new service (currently in alpha only) from Google that’s integrated with Google Cloud Storage to analyze and uncover insights from typed time-series datasets and streams at scale.

Google Cloud Blog

MariaDB Acquires Clustrix, a 'NewSQL' Distributed Database Pioneer — MariaDB, initially famed for producing a successful fork of MySQL, continues to extend its range of additional technologies by acquiring Clustrix, producers of a MySQL-compatible highly scalable ‘NewSQL’ database.

TechCrunch

Setting Up a MongoDB Service Under Windows via PowerShell — We'll show you how to use PowerShell to set up a MongoDB service on Windows, plus highlight how Studio 3T can help with user authentication and management.

Studio 3T sponsor

A SQL Style Guide — A consistent code style guide for SQL to ensure legible and maintainable queries.

Simon Holywell

CrimsonDB: A Self-Designing Key-Value Store — An interesting new database idea from Harvard’s Data Systems Laboratory where the database decides autonomously how to tweak itself internally to adjust to the workloads and hardware it’s given. Its approach is explained in two academic papers but you can’t work with it yourself at this point.

DASlab at Harvard University

The Major Features Coming to PostgreSQL 11 — The next major version of Postgres isn’t too far away and this slidedeck quickly covers the major feature additions.

Bruce Momjian

Accessing MySQL as a Data Source using mysql_fdw — If you have both Postgres and MySQL in your organization, this foreign data wrapper could help you bring them together.

Jobin Augustine

How to Write a Multiplication Aggregate Function in SQL

Lukas Eder

Managing MySQL at Serverless Scale — If you’re worried about exhausting the connections a MySQL server will accept with numerous serverless invocations, these techniques could help.

Jeremy Daly

Bring Order to Chaos: A Graph-Based Journey from Textual Data to Wisdom — A high level explanation of taking unstructured textual data and representing it in a useful way in a graph database.

Dr. Alessandro Negro and Dr. Vlasta Kůs

Why 'Covering Indexes' Will Be Helpful in PostgreSQL 11 — Covering indexes let you include certain extra columns in an index to speed up lookups and is a feature SQL Server and Oracle users will already be familiar with.

Jonathan S. Katz

▶  MongoDB's CTO on Why MongoDB is the Best Database for Modern Apps — Eliot Horowitz explain how MongoDB is evolving and where MongoDB Inc’s Atlas and Stitch services fit into the big picture.

MongoDB

The Changing Role of the Database Administrator — With the advent of the cloud, automation & DevOps, the DBA’s role & responsibilities are rapidly evolving.

EnterpriseDB sponsor

Death By Database: A Database Design Tale — A brief tale of how a poorly designed database model can result in unfortunate compromises.

Curtis 'Ovid' Poe