#322 — September 18, 2020

Read on the Web

Database Weekly

Introducing Pebble: A RocksDB Inspired Key-Value Store Written in Go — The folks at CockroachDB created Pebble as a RocksDB-compatible replacement for their storage engine. This post explains the why and the how of their process.

Peter Mattis

How (and Why) GitLab Upgraded from Postgres 9.6 to 11 — Some of the GitLab team explain the precise maintenance process they took to execute a major version upgrade of Postgres on their systems. And, even better, they recorded the whole 2 hour process so you can see how it was actually conducted! It doesn’t make for exciting viewing, but it’s a very uncommon look behind the database ops curtain at a major company.


🖥 Webinar: The Architecture of a Distributed SQL DatabaseJoin us on September 23 for an under-the-hood look at the internals of CockroachDB. We’ll explore how we guarantee serializable isolation, our implementation of Raft, and discuss why we built a new storage engine to replace RocksDB.

Cockroach Labs sponsor

Oracle Touts an Exadata Backlog — Oracle reported modest revenue growth in its latest quarter and said that moving more of its flagship database software to the cloud remained a priority. It also noted strong demand for its Exadata platform.


JavaScript for Data Science: A Book — A book available both commercially and to read online aimed not specifically at JavaScript developers (as it provides a neat introduction to JS in its own right) but at anyone looking to use JavaScript as a bit of a ‘Swiss Army knife’ for working with datasets. This is one of those great resources you’re likely to pass on to someone who really needs it.

Gans, Hodges and Wilson

PostgreSQL 13 RC 1 Released — Postgres 13 is shaping up to be a huge release for the popular, open source relational database. The beta release notes cover the essentials.

PostgreSQL Global Development Group

Old, Good (Relational) Database Design — It’s back to basics for Elnur, thinking about what a robust and well-thought out database design really is, and it comes down to normalization, data types, constraints, and indexes.

Elnur Jabarov

My Journey Making QuestDB — The story of how QuestDB, an open source database for time series, events, and analytical workloads, came to be.

Vlad Ilyushchenko

How Does a Database Load Balancer Work?

Agus Syafaat (Severalnines)

Index Improvements Coming to Postgres 13 — We’ve linked to numerous articles over the past few months about how indexes will be improved in Postgres 13 but this rounds up six of the biggest benefits in one place complete with code examples.

Ibrar Ahmed and Jobin Augustine

Best-Practices on How to Speed Up Your Postgres Queries. Free eBook — Companies like Robinhood and Atlassian are able to speed up their queries by orders of magnitude. This eBook shares our best practices for optimizing Postgres performance.

pganalyze sponsor

A Database for Every REPL on Repl.itRepl.it is an online tool for writing (and even running) code in an in-browser IDE. Now, they’ve added their own key/value store into the mix, usable from each Python, Node or Go REPL.


TerminusHub: Distributed Revision Control for Structured Data — From the folks behind TerminusDB, an open source in-memory knowledge graph database, comes TerminusHub, a place to collaborate and share databases while keeping them synced. (Think how GitHub allows git users to collaborate..)


Apache Tika: A Content Analysis Toolkit — The Apache Foundation incubates a lot of great software, so much in fact that much of it can fly under the radar, but this is pretty neat if you need to parse and extract metadata and text from almost anything.

Apache Foundation

💻 Jobs

Devops Engineer (Full time / Full Remote) — We're looking for a devops to join our fast-growing, well-funded company that makes thousand of African fashion designers happy.

Afrikrea Platform

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.