#257 — June 7, 2019

Read on the Web

Database Weekly

Shutterstock.com

Why CockroachDB Has Been Relicensed (Companies Rolling Out Open Source-Powered Database Services, Basically..) — Citing the ‘realities of building open source software’, the creators of CockroachDB have relicensed it from Apache to the ‘Business Source License’ which prevents anyone (e.g. Amazon/AWS) from offering CockroachDB as a service without buying a license (a problem that has befallen both Elasticsearch and MongoDB this year).

Peter Mattis, Ben Darnell and Spencer Kimball(Cockroach Labs)

CovenantSQL: An SQLite-Powered Byzantine-Fault Tolerant Distributed Relational Database — Written in Go, Covenant, also known as CQL, promotes itself as an alternative to Amazon’s Quantum Ledger Database.

CovenantSQL

The Best Way to Manage Access to DBs — strongDM works with everything in your stack. Seriously. Any database (yes, even Druid). Any server. Every environment. See how it works.

strongDM sponsor

AWS Unveils a 'Data API' for Amazon Aurora Serverless — Rather than make a traditional database connection from a serverless function, Data API (which is only on the MySQL variant of Aurora Serverless for now) lets you make queries quickly over HTTP and returns results in JSON.

Jeff Barr (AWS)

Benchmarking Managed PostgreSQL Cloud Solutions — A series benchmarking managed Postgres service benchmarks concludes with Azure, but has previously also covered Google Cloud, Amazon RDS, and Amazon Aurora.

Severalnines

Google to Acquire Analytics Startup Looker for $2.6 BillionLooker is a popular enterprise system for mostly creating data visualizations and performing data analysis, and Google Cloud wants a piece of that action.

TechCrunch

IN BRIEF:

💻 Jobs

Senior Site Reliability Engineer - Invoca (Santa Barbara, CA or Remote) — Join our team of Operations Engineers deploying code to our production SaaS platform & public cloud infrastructure multiple times per day.

Invoca

Land a New Dev Job on Vettery — Vettery specializes in tech roles and is completely free for job seekers.

Vettery

📒 Tutorials and Stories

A Look at PostgreSQL's BRIN Indexes — BRIN (Block Range Index) indexes are a powerful way to accelerate sequential scans of tables where the indexed values can be grouped into ‘ranges’ of values (e.g. ZIP codes, ages, order totals).

Egor Rogov

▶  The Life of a Distributed Graph Database Query — Following the life of a query in Memgraph (an enterprise graph database for real-time data) from reading the query as a character string, through to planning and distributed execution of query operations.

Teon Banek

How to Set up Your First AWS Redshift Database: A Schema to SQL Tutorial — AWS Redshift is an easy way to get a data warehouse up and running.

Peter Weinberg

Power WordPress, Drupal, and Joomla Apps with Azure Database for MariaDB — Use MariaDB in the cloud—without database and infrastructure management. See how easy it is to get started.

Microsoft Azure sponsor

Table Access Methods and Blackholes in PostgreSQL 12 — A sneak preview at an exciting new feature in the forthcoming version of Postgres: table access methods (more commonly known as ‘pluggable storage’, a la MySQL’s storage engines).

Michael Paquier

How Data Sharding Works in a Distributed SQL Database — Or in YugaByte DB, specifically!

Sid Choudhury (YugaByte)

How IBM Is Turning Db2 into an 'AI Database' — The term “AI database” is getting thrown around a whole lot lately..

Datanami

Which Time-Series Database is Better: TimescaleDB vs InfluxDB — As with any benchmark, take time to draw your own conclusions.

Severalnines

🛠 Code and Tools

fselect: Find Files with SQL-Like Queries — Do you love SQL so much that you’d like to use its style of code to find files on your system? Your wish has been granted! It goes further than you might think.

J H S Petersson

Selda: A Type-Safe, High-Level SQL Library for Haskell

Anton Ekblad

MLSQL: An Experiment for Inferring SQL Queries From Natural Language Questions — Or, perhaps more succinctly, ‘convert English to SQL’ 😄

Paul Fitzpatrick

SQL Parser: A Validating SQL Lexer and Parser (Focused on the MySQL Dialect) — Written in PHP, this is used primarily by the phpMyAdmin project.

phpMyAdmin

Sqitch 1.0: Database Change Management — A database and framework independent (Postgres 8.4+ is supported) system for managing database and schema changes via SQL scripts. Here’s how it works with Postgres.

Sqitch