#242 — February 22, 2019

Read on the Web

Database Weekly

dbadiagram.io: A Free Database Designer for Developers and Analysts — An easy online tool to help you draw your database relationship diagrams and flow quickly using a simple DSL language.

Holistics Software

simdjson: A C++ Library for Parsing Gigabytes of JSON Per SecondJSON is more heavily used as a data interchange format now than ever and servers spend a lot of time parsing JSON documents. This project is an experiment in making such parsing extremely fast.

Daniel Lemire

What the Heck Is Time-Series Data (And Why Do I Need a Time-Series Database)? — What exactly is time-series data and what’s the most effective way to store it? Should I be using a time-series database? Find out by signing up for our upcoming webinar (3/5) and reading this blog post.

Timescale sponsor

An Update About Redis Developments in 2019 — The creator of Redis, the popular in-memory data structure server, addresses recent concerns about where Redis is heading. In related news, Redis Labs has raised $60M in a series E round.

Salvatore Sanfilippo

Highly Available MySQL Clustering at WePay Using Orchestrator, Consul and HAProxy — WePay’s engineering team talks about their new highly available MySQL cluster built with HAProxy, Consul and Orchestrator. It improves upon their previous architecture by reducing any downtime from 30 mins to 40-60 seconds.

InfoQ

Google Doubles Down on Cloud Data Migration — Data integration startups have become prime acquisition targets as cloud analytics vendors look to beef up their migration capabilities. Google has acquired two in the past eight months alone.

Datanami

Using DynamoDB Streams to Visualize Changes in Frequently Updated ObjectsDynamoDB Streams are ordered flows of information about changes to items in DynamoDB tables and provide a way to track activity.

Maja Grubic and Sofia Tzima

New Redis Labs Redis Modules License Changes — Last August, there was some drama over a license change (involving the Commons Clause) that Redis Labs were rolling out on Redis modules they’d built in-house. They have now addressed criticism by implementing a new Redis Source Available License (RSAL).

Redis Labs

Still Manually Revoking DB Creds?"Securing access to databases was unmanageable. Now with strongDM it's very simple." - VP Engineering, Hearst MediaOS. Learn more.

strongDM sponsor

Farewell to fsync(): 10× Faster Database Tests with Docker — Rather than replacing your usual databases with mocks or SQLite in testing, why not use your usual databases via Docker and just turn fsync off to increase performance?

Itamar Turner-Trauring

Looking at MySQL 8 with PostgreSQL Goggles On — If you’re a heavy Postgres user, you might not have taken a look at MySQL for many years. But if you’re curious what MySQL is like now, Kaarel has done the looking for you and even finds some features he’d welcome in Postgres.

Kaarel Moppel

A Tool to Make PostgreSQL's EXPLAIN ANALYZE More Readable — A tool that lets you paste in the result of EXPLAIN ANALYZE queries and then see a more easily understandable version.

Hubert depesz Lubaczewski

Firebird 4.0 Beta 1 Released — Another step forward for the mature, relational, open source SQL database originally spawned as a fork of Borland’s InterBase.

Firebird Project