---
title: "#193: How both open source and GPUs are shaping database technology"
publication: "DB Weekly"
issue: 193
published_at: "2018-03-02"
canonical_url: "https://dbweekly.com/issues/193"
---

This week's database news       

#193 — March 2, 2018 

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

Database Weekly  

[Queryparser: A Tool for Parsing and Analyzing SQL](https://eng.uber.com/queryparser/) — When Uber needed to identify every foreign-key relationship in a complex data warehouse, it built an SQL query parser and analyzer which it has open sourced. 

Uber Engineering   

[Weighing Open Source's Worth for the Future of Big Data](https://www.datanami.com/2018/02/26/weighing-open-sources-worth-future-big-data/) — Open source has had a huge role to play in the development of big data technology, and nowadays groundbreaking data products are most likely to debut as open source. 

Datanami   [![\](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. 

InfluxData sponsor   

[Bringing GPUs To Bear on 'Bog Standard' Relational Databases](https://www.nextplatform.com/2018/02/26/bringing-gpus-bear-bog-standard-relational-databases/) — GPU accelerated databases have mostly been distinct from traditional database systems so far, but now there are efforts to bring CPU acceleration to MariaDB and PostgreSQL analytical workloads . 

Timothy Prickett Morgan     

**_And a few news items.._**  

[Memcrashed: memcached Abused for Huge New DDoS Attacks](https://blog.cloudflare.com/memcrashed-major-amplification-attacks-from-port-11211/) — If you have a memcached server sitting around, check its security ASAP. 

Cloudflare   

[PostgreSQL 10 Now Supported on Amazon RDS](https://aws.amazon.com/about-aws/whats-new/2018/02/postgresql-10-now-supported-in-amazon-rds/) 

Amazon Web Services    

[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=brief&utm_medium=display&utm_source=dbweekly&utm_date=20180302) 

MONGODB sponsor    

[A Large Scale, Production NoSQL Database Migration](https://medium.com/appsflyer/large-scale-nosql-database-migration-under-fire-bf298c3c2e47) — How (and why) AppsFlyer migrated from Couchbase to Aerospike without everything blowing up. 

Ido Barkan   

[How We Wronged Neo4j and PostgreSQL: ArangoDB Updates Its Benchmarks](https://www.arangodb.com/2018/02/how-we-wronged-neo4j-postgresql-update-arangodb-benchmark-2018/) — ArangoDB recently [published benchmarks](https://www.arangodb.com/2018/02/nosql-performance-benchmark-2018-mongodb-postgresql-orientdb-neo4j-arangodb/) comparing Neo4j, Ppstgres, MongoDB, OrientDB & ArangoDB, but has had to make some updates. 

ArangoDB   

[Three Approaches to PostgreSQL Replication and Backup](https://www.citusdata.com/blog/2018/02/21/three-approaches-to-postgresql-replication/) 

Ozgun Erdogan   

[Transferring SQL Server Database Data to MySQL using .NET Core](http://www.talkingdotnet.com/transfer-sql-server-database-data-to-mysql-database-using-net-core-part-1/) 

Talking Dotnet   

[TiDB: Performance-Tuning a Distributed NewSQL Database](https://www.infoworld.com/article/3258810/sql/tidb-performance-tuning-a-distributed-newsql-database.html) 

Jinpeng Zhang   

[Using Amazon Athena and QuickSight for ALB-ELB Access Log Analysis](https://blog.zoph.me/cloud/Athena-ALB-ELB-Analysis/) 

Victor Grenu    

[MongoDB Tutorial Series: How to Develop an Effective Indexing Strategy](https://studio3t.com/whats-new/mongodb-index-strategy/?utm_source=newsletter&utm_medium=dbweekly&utm_campaign=march2018) 

Studio 3T sponsor   

[The Rise of the Distributed SQL Database](https://crate.io/a/rise-distributed-sql-database/) 

PJ Hagerty   

[I Wanna Go Fast: Why Searching Through 500M Pwned Passwords Is So Quick](https://www.troyhunt.com/i-wanna-go-fast-why-searching-through-500m-pwned-passwords-is-so-quick/) — It basically involved ditching the database. 

Troy Hunt   

[What I Learnt Building 3 Apps on an Embedded Key Value Store](https://hackernoon.com/what-i-learnt-from-building-3-high-traffic-web-applications-on-an-embedded-key-value-store-68d47249774f) — Namely [BoltDB](https://github.com/boltdb/bolt), a Go-based key/value database. 

Anthony Alaribe   

[How MongoDB's Query Planner Works](https://www.slideshare.net/miguelangelnieto/query-planner-88498371) — How does plan selection in MongoDB compare to in relational databases? 

Miguel Angel Nieto         

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

[Change your email address](https://dbweekly.com/edit_subscription/*%7CUID%7C*) or[Stop getting this newsletter](https://dbweekly.com/leave/*%7CUID%7C*) 

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