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. Azure — Which 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)

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 Timestream — Timestream 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

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.

X-Team

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.

Facebook

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