#341 — February 12, 2021

Read on the Web

Database Weekly

▶  The AWS re:Invent 2020 Database Breakout Sessions — Amazon has uploaded all of the sessions from its recent re:Invent conference to YouTube, and the database track is buzzing with all sorts of AWS-flavored database talks. Almost no-one will watch them all, but there’s lots of good stuff in here. Some highlights:

Amazon Web Services

Implementing a Generic REDUCE Aggregate Function with SQL — A fun bit of SQL spelunking here for arbitrarily reducing a collection of data.

Lukas Eder

[NEW] Benchmarking the Cloud: AWS vs. GCP vs. AzureWhich cloud has the lowest latency? The best storage performance? The most throughput? This report digs into the tradeoffs each cloud makes - so you can choose the best option for your needs.

Cockroach Labs sponsor

Why I Built Litestream, a Streaming Replication System for SQLite 3 — The creator of BoltDB, a Go powered key/value store, curiously went to SQLite for his next database project and this post explains why he thinks SQLite plus replication (as offered by Litestream) is the future for many use cases.

Ben Johnson

How JavaScript Can Now Be Executed in Oracle Database — As of version 21c, released last month, Oracle Database can now execute JavaScript, powered by GraalVM. This post digs into the technicalities of how it works.

Alina Yurenko (Oracle)

Quick Bits

Considering Dependent and Independent Pieces of Data — How to use quadrant analysis to find dependent and independent pieces of data.

Alexey Makhotkin

Patterns for AWS IoT Time Series Data Ingestion with Amazon TimestreamTimestream is Amazon’s managed time series database. This post covers approaches to using it for high velocity data ingestion from IoT data sources.

Vieru, Angelino, and Sacha

Prisma’s Data Guide — A free, open educational resource covering databases, with articles on MySQL, PostgreSQL, SQLite, data modelling, & ORMs.

Prisma sponsor

How to Trigger Cloud Run Actions on BigQuery Events — Using serverless functions for HTTP services is great, but some of the most interesting and seamless use cases come when functions are run automatically in reaction to other events. Here, we see how you can create an elaborate sort of database trigger in BigQuery using event triggers and a containerized Cloud Run function.

Lak Lakshmanan

Babelfish: The Elephant in The Room? — Last year, AWS announced Babelfish, a project to provide a SQL Server compatible endpoint for PostgreSQL and that will be open sourced this year. Will an open source version easily integrate with Postgres though? Not exactly, and that’s the problem examined here.

Álvaro Hernández

A Primer on Cloud Bigtable Cost Optimization
Aqsa Fulara and Drew Stevens (GCP)

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


🔨 Code and Tools

rqlite 5.10.0 Released — rqlite is a lightweight, distributed relational database system written in Go that uses SQLite as its storage engine. 5.10.0 is hugely focused on reductions in disk usage.

Philip O'Toole

Obevo: Database Deployment Tool for Enterprise Scale and Complexity — This is for managing and maintaining large collections of database files containing your schemas, procedures, etc. Supports DB2, H2, SQL Server, MongoDB, Oracle, Postgres, Redshift, and more.

Goldman Sachs

RocksDB: A Persistent Key-Value Store for Flash and RAM Storage — It’s been several years since we’ve linked to RocksDB and since then it has become the foundation for numerous database systems. It continues to get frequent updates, such as this week’s v6.15.5 release – it’s certainly worth investigating if you’re planning to build a database of your own.


PostgreSQL 13.2, 12.6, 11.11, 10.16, 9.6.21, and 9.5.25 Released — A suite of updates to Postgres to fix two security vulnerabilities. This is also expected to be the final 9.5 branch release ever.

PostgreSQL Global Development Group

TinyDB: A Lightweight Document Oriented Database in Pure Python — Essentially a JSON store aimed at small Python apps that need some structured data storage but without an external database server or any SQL involved.

Markus Siemens