---
title: "CockroachDB 2.0, ETL vs ELT, and GDPR Compliance"
publication: "DB Weekly"
issue: 198
published_at: "2018-04-06"
canonical_url: "https://dbweekly.com/issues/198"
---

This week's database news       

#198 — April 6, 2018 

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

Database Weekly  

[CockroachDB 2.0 Released](https://www.cockroachlabs.com/blog/cockroachdb-2-0-release/) — CockroachDB is an open source, distributed SQL database. 2.0 brings support for ‘semi-structured’ data via JSON, as well as increased throughput and lower latency on TPC-C. GDPR compliance tools have [also been added.](https://www.datanami.com/2018/04/05/sql-database-adds-gdpr-compliance-tools/) 

Nate Stewart   

[A Browser-Based MongoDB Playground](https://mongoplayground.net/) — Inspired by similar ‘playgrounds’ for [Golang](https://play.golang.org/) or [JavaScript](http://jsbin.com/?html,output), this page lets you play with a MongoDB database from your browser. It’s [open source](https://github.com/feliixx/mongoplayground) if you want to run your own instance (internally, say). 

Adrien Petel   [![\](https://copm.s3.amazonaws.com/36d8efb4.jpg)](https://www.influxdata.com/blog/introduction-to-influxdatas-influxdb-and-tick-stack/) 

[Introduction to InfluxDB and TICK Stack](https://www.influxdata.com/blog/introduction-to-influxdatas-influxdb-and-tick-stack/) — Learn how to get up and running with the fastest growing open source TSDB (time-series database). 

InfluxData sponsor   

[Give Meaning to 100 Billion Analytics Events a Day](https://medium.com/teads-engineering/give-meaning-to-100-billion-analytics-events-a-day-d6ba09aa8f44) — A case study of using Kafka, Dataflow and BigQuery to ingest and transform a large stream of events. 

Alban Perillat-Merceroz   

[Using Neo4j-GraphQL to Serve a GraphQL Endpoint Directly from Neo4j](https://blog.grandstack.io/using-the-neo4j-graphql-plugin-in-neo4j-desktop-c8a60aa014d9) — Turn the popular [Neo4j](https://neo4j.com/) graph database into a GraphQL server. 

William Lyon   

[Dynimize: Speeding up MySQL with CPU Performance Virtualization?](https://dynimize.com/) — Currently in beta, [this page](https://dynimize.com/product) goes into depth on how it works and what it does. An intriguing concept. 

Dynimize, Inc.   

[Postgres Vision: Join Us in Boston, June 5 & 6](http://postgresvision.com/) — Deploying Postgres in the cloud, the changing role of the DBA, moving Oracle workloads to the cloud, and more. 

POSTGRES VISION 2018 sponsor   

[ETL vs ELT: Considering the Advancement of Data Warehouses](https://statsbot.co/blog/etl-vs-elt/) — _“With the advent of modern cloud-based data warehouses, such as BigQuery or Redshift, the traditional concept of ETL is changing towards ELT – when you’re running transformations right in the data warehouse.”_ 

Artyom Keydunov   

[Hit The Ground Running with Vue.js and Firestore](https://www.smashingmagazine.com/2018/04/vuejs-firebase-firestore/) — Firestore is a new data storage approach from Google Firebase. 

Lukas Van Driel   

[Behind on Preparing for GDPR? 3 Things to Prioritize](https://www.datanami.com/2018/04/06/behind-on-preparing-for-gdpr-three-things-to-prioritize/) — The May 25, 2018 GDPR deadline is quickly approaching and has major data usage implications if you’re in the EU or do business there. 

Mika Javanainen   

[Anna: A KVS for Any Scale](https://blog.acolyer.org/2018/03/27/anna-a-kvs-for-any-scale/) — We featured Anna [a month ago](https://dbweekly.com/issues/194) but this reflects further on its implementation. 

Adrian Colyer   

[Improving HBase Backup Efficiency at Pinterest](https://medium.com/@Pinterest_Engineering/improving-hbase-backup-efficiency-at-pinterest-86159da4b954) 

Lianghong Xu   

[MongoDB 4.0 Will Support Multi-Document, ACID Transactions](https://www.mongodb.com/transactions?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY19Q1&utm_content=20180406&utm_medium=display&utm_source=dbweekly) 

mongodb sponsor   

[MapD Cloud: A New GPU-Accelerated Analytics Platform](https://www.mapd.com/blog/announcing-mapd-cloud/) 

Todd Mostak   

[New Annotated Config Files for Postgres 10](http://www.databasesoup.com/2018/04/new-annotated-config-files-for.html) — Understand PostgreSQL’s config files better with resources including [a CSV file](https://github.com/jberkus/annotated.conf/blob/master/annotated.csv) covering _all 269 postgresql.conf settings_. 

Josh Berkus   

[Introducing the Google Analytics Sample Dataset for BigQuery](https://analytics.googleblog.com/2018/03/introducing-google-analytics-sample.html) — A dataset for gaining experience with analyzing analytics data with BigQuery. 

Google         

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