#242 — February 22, 2019 |
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 Second — JSON 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 Objects — DynamoDB 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 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 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 |