#232 — December 7, 2018

Read on the Web

Database Weekly

AgensGraph 2.0: A Multi-Model Graph Database Built on PostgreSQL — AgensGraph is a graph database (supporting both SQL and Cypher queries) built atop Postgres. GitHub repo.

Bitnine

Using Elasticsearch as the Primary Data Store in an ETL Pipeline — A pretty extensive article covering the lessons learnt in adopting a rather novel approach to using Elasticsearch in an ETL pipeline at the biggest online retailer in Belgium and the Netherlands.

Volkan Yazici

JSON Schema Document Validation? In MongoDB - No Problem — Our resident database expert will guide you through the steps to create a valid JSON schema for your MongoDB collection, in this detailed walk-through with sample datasets. Try it yourself.

Studio 3T sponsor

What's New in PostgreSQL 11 — Postgres 11 landed about 6 weeks ago but in case you haven’t played with it yet, this post gives an overview of the new features and functions.

Viorel Tabara

Back to the Future with Relational NoSQL — Outlines the consistency issues NoSQL databases have with distributed transactions, showing how FaunaDB has solved the problems using the Calvin protocol and a virtual clock.

InfoQ

Announcing the General Availability of Azure Database for MariaDB — An enterprise-ready, fully managed hosted version of MariaDB is now on Azure.

Sudhakar Sannakkayala (Microsoft)

ArangoDB 3.4 Introduces Native Search Engine and Full GeoJSON Support — ArangoDB is an interesting open source native multi-model database.

Datanami

▶  Postgres & Kubernetes: DBaaS Without Vendor Lock-In — A 30-min talk on using Kubernetes to create your own Postgres-powered DB as a service.

Oleksii Kliukin

Installing and Configuring JIT in Postgres 11 — Just-In-Time (JIT) compilation for SQL statements came to Postgres 11 as an option to Postgres 11 but as not all workloads can benefit from it, it’s not enabled by default. (It’s well suited to long running analytical style workloads though.)

Jobin Augustine

How to Reduce Syntactic Overhead Using the SQL WINDOW Clause — A way to neatly refactor window related queries on MySQL, PostgreSQL and Sybase.

JavaOOQ

How Nondeterministic Functions in MySQL (i.e. rand) Can Surprise

Alexander Rubin

Working with Irregular Time Series

InfluxData sponsor

This Single SQL Query Solved My Sudoku In Seconds

Paras Shah

How Pinterest Runs Kafka At Scale

Yu Yang (Pinterest)

💻 Jobs

UK Data Engineering Roles? Try hackajob — See how much you could earn by putting your skills to the test, average salary £65k.

hackajob