#272 — September 20, 2019

Read on the Web

Database Weekly

New Query Language for Graph Databases to Become International Standard — GQL is set to be the first new ISO-standardized database language since SQL and Neo4j are, perhaps unsurprisingly, strongly behind it. More background info here.


Yugabyte DB 2.0 GA: A 'Jepsen Tested', High-Performance Distributed SQL DBMS — Yugabyte DB is a Google Spanner-inspired, cloud-native distributed SQL database that’s 100% open source and aims to be Postgres compatible in most cases.

Kannan Muthukkaruppan

SQLPro Studio - macOS and iOS Database Client — A powerful suite of native apps for working with all sorts of SQL databases. Easily browse and edit records, either visually or using a truly great query editor. If you work with MSSQL, MySQL, Postgres or SQLite make sure to check out SQLPro. Get 1 year free.

Hankinsoft Development, Inc sponsor

memcached Adds Support for Restoring Its Cache Between Restarts — Version 1.5.18 of anything doesn’t sound too exciting, but this is a big step for memcached and will make both upgrades and recovery a lot easier if you are able to provide the right type of filesystem for it (it uses DAX). More discussion here.

memcached community

Database Leaks Data On Most of Ecuador's Citizens — A huge leak of 20.8 million user records came via an insecure Elasticsearch deployment. I suspect some admins forget Elasticsearch is not just a ‘search engine’ but a complete document-based database..

Catalin Cimpanu

💻 Jobs

Find a DB job through Vettery — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started.


📒 Articles & Tutorials

What’s Faster? COUNT(*) or COUNT(1)? — Spoiler: It doesn’t matter, unless you’re using PostgreSQL.

Lukas Eder

Why Use TimescaleDB Over Relational Databases? — The interesting thing is that while TimescaleDB is a time series database, it is built as an extension on top of a relational database, Postgres!


Free O’Reilly Book: Graph Algorithms — Get hands-on examples of how to use graph algorithms to forecast behavior, with sample code and tips for over 20 algorithms.

Neo4j sponsor

Harnessing Machine Learning to Make Managing Storage Less of A Chore — Jobs that could originally be managed by a single storage architect now require increasingly large teams of specialists but AI is able to help keep things efficient.

Jim Salter (Ars Technica)

▶  Discussing the MongoDB Data Platform — MongoDB’s Director of Cloud Products talks about the idea of “data platforms” where a single, transactional database isn’t enough, but instead you might also have a data warehouse, search index, etc.

Software Engineering Daily podcast

🛠 Tools & Code

Introducing NoSQL Workbench for Amazon DynamoDB — AWS has released a Windows and macOS app for working with DynamoDB. Beware, however, as there are numerous reports of it breaking ~/.aws/credentials files (so be sure to back yours up!)

Amazon Web Services

PostgreSQL 12 Beta 4 Released — Contains previews of all features that will be available in the final release of Postgres 12 and is “likely the final beta release” prior to a release candidate. As always, the beta release notes may be useful, as may Postgres’s How to Beta Test docs.

PostgreSQL Global Development Group

A Browser-Based MongoDB 4.2 Playground — Inspired by similar ‘playgrounds’ for Go or JavaScript, this page lets you play with a MongoDB database from your browser. It’s open source if you want to run your own instance (internally, say).

Adrien Petel