#​357 — June 4, 2021

Read on the Web

✍️  It's still several issues away but as of July we're placing DB Weekly on hiatus for a while due to refocusing our efforts at Cooperpress. We'll explain more over this month, but didn't want it to be too big a surprise! As part of this, we'll be revisiting some of the biggest stories we've covered, most useful tools we linked to, and sharing some of the backlog of items we've not yet been able to share.
__
Peter Cooper, editor

Database Weekly

Firebird 4.0 Released — Firebird 4.0 (release notes) has been in the pipeline so long that even two years ago they were giving talks about the road to v5.0. But that’s one of the great things about it - it’s steady, solid, open source, and mature, having originated as a fork of InterBase 6 back in 2000 (but broadly rewritten since).

Firebird Team

Lakehouses Prevent Data Swamps, Bill Inmon Says — Bill Inmon coined the term ‘data warehouse’ back in 1992 so if anyone’s going to opine on lakehouses, data swamps, and whatever other metaphors are doing the rounds these days, let him be the one to do so! He also explains why he’s not a fan of ELT compared to ETL.

Alex Woodie

Virtual NoSQL Event for Java Database Developers — Java is one of the most popular programming languages in the world. Join our free virtual event to learn how to bring the full power of Java and NoSQL together. Secure your spot.

Couchbase sponsor

Links to 1211 (and Counting) Interesting Datasets — A wide variety of delights from datasets of every death in Tarantino’s movies and cruise ship inspections to the coins in 22,500 French wallets.

Data Is Plural

PolarDB: Another Postgres-Based Database — Out of Chinese ecommerce giant Alibaba comes a new Postgres-based database that aims to provide global data consistency, ACID across nodes, and to be more distributed generally. Think something like Aurora but open source. It’s rather early days, but there’s a roadmap if you want to see where they’re headed with it.

Alibaba Group

  • Cloudera, best known for their Hadoop distribution and platform, is going private in a $5.3bn buyout.

  • SQLite can now drink in the US – it's just turned 21 years old.

Free CKAD Study Guide Excerpt — The CKAD exam is not multiple choice. You need to demonstrate your k8s skills in sample exercises. This study guide prepares you for those exercises.

Cockroach Labs sponsor

PostGIS at 20PostGIS, the popular set of geospatial extensions for Postgres, has turned twenty years old. This post covers a little of the early history.

Paul Ramsey

12 Common Misconceptions About DynamoDB — DynamoDB’s approach is different enough to most other databases that it’s not surprising there are a variety of common misconceptions.

Rafal Wilinski

Aurora vs. RDS: An Engineer's Guide to Choosing a Database — Learn about the difference between two approaches for running relational databases in AWS.

Alex Chan

pgSCV: A Metrics Exporter for Postgres — A new tool that attempts to go beyond what postgres_exporter offers by making it easy to collect ‘almost all metrics’ from Postgres with as minimal configuration as possible. GitHub repo.

Alexey Lesovsky

SQLite Data Starter Packs: Public Data Packaged Up in SQLite Databases — A collection of public datasets conveniently packaged as SQLite databases to practice on.

Public Affairs Data Journalism at Stanford

Jobs

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

Find Data Engineering Jobs with Hired — Take 5 minutes to build your free profile & start getting interviews for your next job. Companies on Hired are actively hiring right now.
Hired