---
title: "#203: SQLite to Gain 'UPSERT' Functionality"
publication: "DB Weekly"
issue: 203
published_at: "2018-05-11"
canonical_url: "https://dbweekly.com/issues/203"
---

This week's database news       

#203 — May 11, 2018 

[Read on the Web](https://dbweekly.com/issues/203)   

Database Weekly  

[SQLite to Gain 'UPSERT' Functionality](https://www.sqlite.org/draft/lang_UPSERT.html) — 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](https://aws.amazon.com/blogs/aws/amazon-aurora-backtrack-turn-back-time/) — 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   [![\](https://copm.s3.amazonaws.com/cff987cd.png)](https://learn.percona.com/cp-using-mysql-distributed-database-architectures) 

[Using MySQL for Distributed Database Architectures](https://learn.percona.com/cp-using-mysql-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](https://www.cybertec-postgresql.com/en/avoid-or-for-better-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](https://github.com/radondb/radon) — 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](https://cloudplatform.googleblog.com/2018/05/Introducing-Cloud-Memorystore-A-fully-managed-in-memory-data-store-service-for-Redis.html) — 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?](https://www.datanami.com/2018/05/02/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)](https://www.citusdata.com/blog/2018/05/08/its-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](https://mysqlserverteam.com/mysql-8-0-innodb-now-supports-instant-add-column/) 

MySQL Server Team   

[Free Whitepaper: MySQL on Docker](https://severalnines.com/resources/whitepapers/mysql-docker-how-containerize-your-database?utm_campaign=Crisis_Campaign_MAY_2018&utm_content=dbweekly&utm_medium=Paid_Search&utm_source=banner) — Learn how to containerize your MySQL database. 

Severalnines sponsor   

[All You Need to Know About MongoDB on Google Cloud](https://medium.com/google-cloud/all-you-need-to-know-about-mongodb-on-google-cloud-28adc359af37) 

Raju Dawadi   

[Continuously Deploying Elasticsearch on Kubernetes](https://techblog.commercetools.com/continuously-deploying-elasticsearch-on-kubernetes-57fdfba40670) 

Yann Simon   

[Improving Response Latency in Elasticsearch with Adaptive Replica Selection](https://www.elastic.co/blog/improving-response-latency-in-elasticsearch-with-adaptive-replica-selection) 

Lee Hinman   

[Lucidchart’s Database Migration to Amazon Aurora](https://www.lucidchart.com/techblog/2018/05/08/lucidcharts-database-migration-to-amazon-aurora/) — [Aurora](https://aws.amazon.com/rds/aurora/) is AWS’s MySQL and PostgreSQL compatible relational database service. 

Lucidchart   

[Khan Academy's New Data Pipeline Management Platform Explained](http://engineering.khanacademy.org/posts/khanalytics.htm) 

Ragini Gupta   

▶[A Technical Overview of Azure Cosmos DB](https://www.youtube.com/watch?v=V_C7DlKVofc) — How to get started building ‘planet-scale’ apps with Azure Cosmos DB, Microsoft’s multi-model database. 

Andrew Liu and Ram Krishnamurthy   

[Six Reasons Why Enterprises Need a Modern Data Integration Architecture](https://www.datanami.com/2018/05/04/six-reasons-why-enterprises-need-a-modern-data-integration-architecture/) 

Datanami   

[Email Course: Introduction to Change Streams in MongoDB](https://www.mongodb.com/change-streams-email-course?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY19Q1&utm_content=20180511&utm_medium=display&utm_source=dbweekly) 

mongodb sponsor   

[csvs-to-sqlite: Convert CSV Files Into a SQLite Database](https://github.com/simonw/csvs-to-sqlite) — A tool written in Python. 

Simon Willison tools   

[go-mysql-elasticsearch: Sync MySQL Data into Elasticsearch](https://github.com/siddontang/go-mysql-elasticsearch) 

Liu Tang tools         

A **[Cooperpress](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom