#227 — October 25, 2018

Read on the Web

Database Weekly

Uber’s Big Data Platform: 100+ Petabytes with Minute Latency — It’s amazing to think that Uber has over 100 petabytes of data to analyze, but all those journeys and drivers soon add up. Here’s a look at how Uber uses Hadoop and Spark to manage and analyze this immense collection of data.

Reza Shiftehfar (Uber)

A Web-Based Random Dummy Data Generation Tool — Specify some fields, number of rows, and output format, and this tool will put together some dummy data for you.

WHITEBOARD.tech

Love SQL but Want to Try MongoDB? Get the Best of Both, with Studio 3T — Get started fast with a variety of SQL Join queries in MongoDB.

Studio 3T sponsor

PostgreSQL 11: A First Take on the New Release — Thoughts on some of the “killer features” of the latest release that we featured last week. This week’s Postgres Weekly goes into more detail on the release too.

Jobin Augustine, Ibrar Ahmed, Avinash Vallarapu and Fernando Laudares Camargos

Oracle Database 18c XE Now Available — Oracle Database 18c XE is a free, community supported edition of Oracle’s popular enterprise-dwelling database. Limits have been increased to supporting 2 CPUs, 12GB of data, and 2GB of RAM.

William Hardie (Oracle)

PipelineDB 1.0.0: High-Performance Time-Series Aggregation For PostgreSQL — PipelineDB 1.0 is a PostgreSQL extension for high-performance time-series aggregation via continuous SQL queries.

Derek Nelson

Amazon RDS Now Supports MySQL 8.0 — Amazon’s managed database service now supports the latest major edition of MySQL.

Amazon Web Services

The Dark Side of MongoDB’s New License — MongoDB recently revised its open source license, creating the new Server Side Public License (SSPL). How does it compare to APGL? How may it affect users?

Dor Laor (ScyllaDB)

The Basics of Data Modeling with Cassandra

Charmy Garg

A Fast, Serverless, Big Data Pipeline Powered by a Single Azure Function — A single, serverless Azure function is all it took to fully implement an end-to-end, real-time, mission critical data pipeline, as seen here.

Kate Baroni

IBM Offers AI-Assisted SQL Tuning — Aimed at enterprise users on z/OS systems, IBM’s Db2 AI for z/OS (Db2ZAI) gathers SQL performance information over time and uses machine learning to create more efficient database models.

Lockwood Lyon (Database Journal)

Moving Tablespaces by Bruce Momjian — A look at just how simple moving tablespaces is since Postgres 9.2.

EnterpriseDB sponsor

Benchmarking Google BigQuery at Scale

Robert Barton (King)

dtle: A Distributed Data Transfer Tool for MySQL — Built in Golang.

ActionTech