#193 — March 2, 2018
Database Weekly
Queryparser: A Tool for Parsing and Analyzing SQL — 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 — 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
Introduction to 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 — 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
Memcrashed: memcached Abused for Huge New DDoS Attacks — If you have a memcached server sitting around, check its security ASAP.
Cloudflare
PostgreSQL 10 Now Supported on Amazon RDS
Amazon Web Services
A Large Scale, Production NoSQL Database Migration — 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 — ArangoDB recently published benchmarks comparing Neo4j, Ppstgres, MongoDB, OrientDB & ArangoDB, but has had to make some updates.
ArangoDB
Three Approaches to PostgreSQL Replication and Backup
Ozgun Erdogan
TiDB: Performance-Tuning a Distributed NewSQL Database
Jinpeng Zhang
The Rise of the Distributed SQL Database
PJ Hagerty
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 — Namely BoltDB, a Go-based key/value database.
Anthony Alaribe
How MongoDB's Query Planner Works — How does plan selection in MongoDB compare to in relational databases?
Miguel Angel Nieto