#275 — October 11, 2019

Read on the Web

Database Weekly

SQLite 3.30.0 Released — SQLite is such an unsung workhorse of the entire software ecosystem and continues to get better all the time. This latest release adds support for the FILTER clause on aggregate functions and more.

SQLite

Alibaba's OceanBase Tops TPC-C Database Benchmarks — By quite some way, too, toppling Oracle which has held the record for many years. OceanBase is a “distributed, shared-nothing relational database” built at Alibaba, the Chinese cloud and ecommerce giant.

TPC

Get $100 to Demo Blue Matador’s Alert Automation — Blue Matador is alert automation for cloud infrastructures. Our proactive alerts take the time and toil out of monitoring. Zero configuration and zero maintenance. We’re so confident you’ll love it that we’re offering $100 to demo it with our team.

Blue Matador sponsor

PinalyticsDB: A Time Series Database on Top of Hbase — A look at Pinterest’s proprietary time series database that they use to building and visualizing time series data reports. Here’s some notes on how it’s built and how they’ve improved it over time.

Pinterest Engineering

What's a Hard or Fun SQL Query You've Had To Write? — A fun thread on Twitter. You need to dig around a bit but there are some interesting/gruesome examples in here.

Julia Evans on Twitter

TerminusDB: A New Open Source Graph Database — Billing itself as a database ‘built for data people’, Terminus is a model-driven graph database built in Prolog(!) GitHub repo.

Terminus

Data Navigator Uses NLP for Queries — A new AI-based data ‘navigation system’ is billed as the first analytics platform to use natural language processing to generate SQL queries from spoken requests (think Alexa meets data analysis).

George Leopold

💻 Jobs

DevOps Engineer at X-Team (Remote) — Work with the world's leading brands, from anywhere. Travel the world while being part of the most energizing community of developers.

X-Team

Find A Job Through Vettery — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started.

Vettery

📒 Everything else..

Formally Modeling Database Migrations — An interesting look at modeling a database migration in order to ensure it will be safe and accurate.

Hillel Wayne

▶  Data Modelling: Can You Do it Without a Schema? — RavenDB CEO Oren Eini demonstrates transforming your data into a ’21st century format’ using a document-based model.

Oren Eini

Tracing Postgres's Query Processing Internals with a Debugger — Wow, this is some serious query debugging. I have no urge to dig this deep into Postgres, but it’s handy to know how if you do.

Cary Huang

Visualize Your Entire End-To-End CI/CD Workflow. Free & Open Source — Build, test, and deploy with complete visibility into your CI/CD workflow. Free and open source.

ThoughtWorks GoCD sponsor

Building Serverless Data Pipelines on Amazon Redshift By Writing SQL with Datacoral

Raghu Murthy

How Facebook's Scribe Transports Petabytes of Logs Per Hour — The current version isn’t open source (yet) but Scribe is Facebook’s distributed, buffered queueing system and it moves "several petabytes" of Facebook’s logs every hour.

Facebook Engineering

A SQL 'Murder Mystery' — A self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to ‘solve an intriguing crime.’

NUKnightLab

A SQL Implementation of An Ancient Handwriting Recognition Algorithm — Yep, you read that write.. ;-)

Noah Doersing