#235 — January 3, 2019

Read on the Web

Database Weekly

Welcome to 2019. We're hoping it's going to be an eventful year in the database world, but just to kick things off we're reflecting back on 2018 with the most popular links of the year, as clicked by readers like you 🙂

Thanks for continuing to support us and remember that if you ever want to submit anything for a future issue, just hit reply!
— Peter Cooper, editor

Three looks behind the scenes..

Inside Fortnite's Massive Data Analytics Pipeline — How the wildly popular multiplayer game keeps all the data to keep it running together and, to my surprise, our most clicked link of 2018 🙂

Datanami

MySQL High Availability at GitHub — GitHub uses MySQL as its main datastore for all non-git related things so it’s a critical piece of infrastructure that needs to stay up. This post dug deep on how they keep MySQL highly available and proves that you all love a great case study.

Shlomi Noach (GitHub)

📈Data-Driven Guide to Engineering Leadership — Ship faster because you know more, not because you're rushing. Get actionable insights from 7 million commits and 85,000+ software engineers, to increase your team's velocity. [Free Guide]

GitPrime sponsor

Scaling Time Series Data Storage at Netflix — How the video streaming service has evolved a time series data storage architecture through multiple jumps in scale.

Duvedi, Li, Garg, and Fisher-Ogden

Four thoughts on where databases are going..

A One Size Fits All Database Doesn't Fit Anyone — Amazon’s CTO is often asked why AWS offers so many different database products. Here, he explained why, and explained his conviction that using multiple databases within an app is a good move. (I think we'll see this as a bit of a trend in 2019.)

Werner Vogels

Will GraphQL Become a Standard for the New Data Economy? — GraphQL isn’t a database itself but a new data querying format for APIs to use instead of alternatives like REST or SQL over the wire and its popularity grew like a weed in 2018 with no sign of slowing down in 2019..

Datanami

It’s About Time For Time Series Databases“Nobody wants to have large grain snapshots of data for any dataset that is actually comprised of a continuous stream of data.”

Timothy Prickett Morgan

Redis Speeds Towards a Multi-Model Future — Redis is best known as a very fast key-value store, but there’s more to it than that especially if Redis Labs gets its way. Here’s an update on where Redis was at as of September, although in October Redis 5 was released.

Datanami

Meet the Infrastructure Access Api: Strongdm — Manage access to every database & server with your existing SSO. Less hassle. Instant answers for auditors. Watch demo

StrongDM sponsor

And three ways to make your databases better..

3 Database Modelling Anti-Patterns — Looking into some classic anti-patterns: entity attribute values, multiple values in a single column, and how using UUIDs can be an anti-pattern too.

Dimitri Fontaine

The Not-So-Dark Art Of Designing Database Indexes — Are you a general software engineer who thinks database indexes are a bit mysterious? This is what one developer has learnt about them and thinks is important to know.

Ben Nadel

Bad Practices in Database Design: Are You Making These Mistakes?

Fernando Martinez

💻 Jobs

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

hackajob