#232 — December 7, 2018
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
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 65ドルk.
hackajob