👋 Welcome to the final issue of DB Weekly for 2020! We're taking a couple of weeks off to enjoy the holiday season and hope you have a good time too. To wrap up, this week we look at the biggest items of the year as well as some of the tools you clicked on most.
Peter Cooper, your editor

#335 — December 18, 2020

Read on the Web

Database Weekly

🌟 The Top 6 DB Weekly links of 2020

As based on unique subscribers who clicked.

1.  'Things I Wished More Developers Knew About Databases' — A then-Google-but-now-AWS engineer (whose name may be familiar to the Go developers among you) shared 17 insights about databases she’s picked up over the years. I continue to recommend this piece and it was the best database related article this year, IMHO.

Jaana B. Dogan

2.  ▶️ The Most Popular Databases: From 2006 to 2020 — A bar chart that shifts and changes over time based on the popularity of different database systems (as determined by the TOPDB index). Not definitive by any means but interesting to see the shifts nonetheless.


Why a US Cable Company Left Amazon Aurora for CockroachDB — When an AWS networking outage knocked a cable company's customer service app offline, it was the last straw. They migrated the entire application to CockroachDB.

Cockroach Labs sponsor

3.  What Every Developer Should Know About Database Consistency — As a Distributed Systems Team Lead at Microsoft you’d expect Roberto to know a bit about consistency, and he did a good job of explaining the basics at a high level here.

Roberto Vitillo

4.  Nine Offbeat Databases Worth A Look — Popular, well tested databases have a huge benefit in sense of community, documentation, and proven performance, but keeping an eye on newer or less common databases can prove educational (and is basically catnip to me as editor of this newsletter ;-))

Serdar Yegulalp

5.  A SQL Style Guide — A handy SQL style guide to ensure legible and maintainable queries.

Simon Holywell

6.  The Database of Databases — An online encyclopedia of 733, and counting, database systems — collected together by Carnegie Mellon University. It includes a leaderboard of stats showing the most common countries of origin (US is #1 unsurprisingly), programming language used (C++, Java, C, and Go take the top four spots), and more.

Database of Databases

💼 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.


🔨 Top Code and Tools of 2020

SQLPad: A Web-Based SQL Editor to Run In Your Private Cloud — Built in JavaScript but available to run via a Docker image, this elegant SQL query runner and visualizer supports MySQL, Postgres, SQL Server, Presto, SAP HANA, Cassandra, SQLite and more.

Rick Bergfalk

Wondering How You Should Optimize a Particular Postgres Query? — pganalyze uses auto_explain to automatically collect EXPLAIN plans. Identify slow sequential scans, sorts on disk & more.

pganalyze sponsor

Amazon Honeycode: Building Apps Without Code on AWS — Think.. Access meets Excel meets the cloud. The aim is to allow a wider range of users to build data-driven online apps without learning to code. I haven't heard much about this since its launch and it still feels a bit 'separate' to the rest of AWS.

Jeff Barr

Visidata: A Terminal Spreadsheet Multitool for Discovering and Arranging Data — Here’s an introductory tutorial to what you can use this for.

Saul Pwanson

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

MeiliSearch: Fast, Open Source Full Text Search Engine — Think of this as a zero-config alternative(ish) to Elasticsearch or a self hosted Algolia. It’s built in Rust and supports things like tolerating typos in queries, filters, synonym checks, and is well suited for fast ‘as you type’ searches. Typesense is also worth exploring in this space.