#295 — March 13, 2020

Read on the Web

Database Weekly

We Made SQL Visual - Why and How — Chartio show off a new interface they’ve created for building SQL queries called Visual SQL. It doesn’t really help you model your data but making SQL more ‘visual’ in nature is interesting and could bring it to broader audiences.

Dave Fowler (Chartio)

Choosing the Right Databases for Shopee's Applications — It’s worth noting this article is hosted by PingCAP, creators of TiDB, but beyond that it’s a look at the process of choosing which databases best suit your use cases by two engineers at a large Asian e-commerce platform (Shopee). Unsurprisingly, TiDB features heavily here, but also Redis and MySQL.

Chunhui Liu and Chao Hong

Why NoSQL < SQL and What It Means for the Future 🔮 — Follow along on this Star Wars-infused history of databases, from a New Hope to NoSQL Strikes Back and Return of the SQL, compiled by your friends (and original trilogy fans) at Timescale.

Timescale sponsor

Memcached 1.6.0 Released — The external Flash storage system is now compiled in by default and lets you use external storage as if it were memory.

memcached community

Database Basics: Creating a SQL Database System from Scratch in Go — A multi-part series which starts with an extensive look at creating a basic SQL parser, adding an in-memory backend, and a simple REPL.

Phil Eaton

ArangoDB: A Database for Projects with a High Level of Uncertainty? — I thought this was a bit of a sales pitch at first, but I think they’re just very enthusiastic users! ArangoDB is an open source, multi-model database that’s well suited if you need to mix graph, document and search paradigms in a single project. (Note: This item was written up and included before I noticed ArangoDB is a sponsor of today's issue!)

MindK

DBDiagram: A Database Designer for Developers and Analysts — A free Web-based tool to help you draw database relationship diagrams and flows quickly using a simple markup language/DSL.

Holistics Software

How Spotify Improved Data Discovery for Its Data Scientists — We focus principally on the storage and manipulation of data in this newsletter, but being able to get the right data to the right people is probably just as important. Here’s how Spotify does it.

Andrew Maher (Spotify Labs)

Easily Run ArangoDB on All Major Kubernetes Engines — AWS, Azure, Google, IBM, Red Hat. K8s Operator 1.0 adds full automation mode, simple deployment and new security features.

ArangoDB sponsor

Lessons Learnt from Discord's Migration from Redshift to BigQuery — The creators of Discord (a popular chat app in the gaming community) moved from Amazon Redshift to Google BigQuery for their data warehousing.

Google Cloud Blog

Run Cypher to Analyze Neo4j Graph Database Inconsistencies — Learn advanced Cypher queries for one approach to analyzing data inconsistencies directly in a Neo4j database.

Eric Monk (Neo4j)