#325 — October 9, 2020

Read on the Web

Database Weekly

A Short Story About SQL’s Biggest Rival — A short story about SQL’s rival: Michael Stonebraker’s storied query language, QUEL. Allegedly Oracle’s Larry Ellison said: “Maybe QUEL is better than SQL. Maybe French is better than English? It didn’t matter: English and SQL were going to win.”

Cedric Chin

Raft Is So Fetch: The Raft Consensus Algorithm Explained Through Mean Girls — If you don’t like playful explanations, move on because this will get confusing fast, but if Mean Girls means something to you, this is a noble attempt to make the Raft consensus algorithm more relatable(!)

Mikael Austin (CockroachDB)

Creating a Bug-Tracker with .NET Core + RavenDB NoSQL Database (YABT Series) — A series of articles on building an enterprise solution with the .NET Core and RavenDB, showing how various NoSQL DB features play out all the way through the API to the UI.

RavenDB sponsor

UK Government Misplaces COVID-19 Results Due to Excel Limitation — The BBC put it mildly by saying: “The decision to use a spreadsheet format that dates back to the 1980s has proved to be unwise.” This is a great example, however, of end users using what feels like the right tool for them but without it actually suiting the use case (a common issue with data systems in general, IMHO).

BBC News

⚡️ Quick bytes:

How Stream Monkey Serverlessly Migrated 1.58 Billion Elasticsearch Documents — Stream Monkey has 2.1TB of data stored in Elasticsearch and uses it as part of its real-time stats dashboard. They needed to make a big Elasticsearch upgrade (which included updating the underlying schema) and came up with a serverless solution to the problem.

Nicholas Ionata

The Database is on Fire — An interesting story and thoughts on the state of real-time databases, specifically Google’s takes on the matter via Firebase and Firestore or, as the author puts it: “Totally Fair and Unbiased comparison of two closely related Real-Time Database Products By Google™”

Steven Wittens

Best-Practices on How to Speed Up Your Postgres Queries. Free eBook — We share our learnings from helping companies like Atlassian, Robinhood, and others speed up their queries.

pganalyze sponsor

Migrating from mLab to MongoDB Atlas — And why would you need to do this? Well, MongoDB acquired mLab in 2018 and are requesting everyone migrate.

Chen Hui Jing

Tips for Upgrading from MySQL 5.7 to MySQL 8

Krzysztof Ksiazek (Severalnines)

⚙️ Code and Tools

CG/SQL: Easy, Accurate SQLite Code Generation — A project from Facebook that compiles stored procedures written in a variant of T-SQL into C code that uses SQLite. GitHub repo.

Rico Mariani (Facebook Engineering)

Arctype: A Desktop SQL Client for Postgres and MySQL — When I saw someone tweet that this is the ‘most beautiful client I’ve used’, I had to take a look at this. spreadsheet-style data editing.


q: Run SQL on CSV or TSV Files — A perennially useful utility.

Harel Ben-Attia

💻 Jobs

DevOps Engineer at X-Team (Remote) — Join the most energizing community for developers and work on projects for Riot Games, FOX, Sony, Coinbase, and more.



If you found the top feature about QUEL interesting, you might also be intrigued to see how QUEL and SQL compare at a basic query level and the Wikipedia entry provides a neat table: