DB Weekly Issue 203: May 11, 2018

#203 — May 11, 2018

Database Weekly

SQLite to Gain 'UPSERT' Functionality — A draft of how SQLite will introduce support for allowing INSERTs to turn into updates if the INSERT would violate a uniqueness constraint (essentially ‘update or insert’).

SQLite

Amazon Aurora Backtrack: Turn Back Time in Aurora — AWS’s high performance MySQL and PostgreSQL compatible database gains an ‘undo’ feature that lets you ‘rewind’ your database by a certain number of hours (up to 72).

Jeff Barr

Using MySQL for Distributed Database Architectures — See how you can use MySQL to engineer distributed multi-node systems in this 45 min webinar with Percona, CEO, Peter Zaitsev.

Percona sponsor

Avoiding 'OR' for Better Query Performance — A look at different kinds of queries using SQL’s OR and how to rewrite them without OR for better performance.

Laurenz Albe

RadonDB: A MySQL-Compatible Fully Distributed Cloud Database — A new open source, cloud-native database that supports distributed transactions and automatic table sharding.

RadonDB

Cloud Memorystore: A Fully Managed In-Memory Data Store Service for Redis — Google has made a public beta of a highly available, fully-managed Redis 3.2.11-compatible service available. It supports instances of up to 300GB.

Google Cloud Platform

Self-Driving Databases are Coming: What Next for DBAs? — What do ‘autonomous databases’ that self repair, patch, back up, and optimize themselves mean for DBAs in the future?

Maria Colgan (Oracle)

It's The Future (for Databases) — What does the future hold for databases? It may or may not have something to do with Postgres.

Craig Kerstiens

MySQL 8.0: InnoDB Now Supports Instant ADD COLUMN

MySQL Server Team

Free Whitepaper: MySQL on Docker — Learn how to containerize your MySQL database.

Severalnines sponsor

All You Need to Know About MongoDB on Google Cloud

Raju Dawadi

Continuously Deploying Elasticsearch on Kubernetes

Yann Simon

Improving Response Latency in Elasticsearch with Adaptive Replica Selection