#215 — August 3, 2018

Read on the Web

Database Weekly

It's basically the very middle of summer here in the UK, and it is boiling :-) We always see a major reduction in big news and articles over the summer but we're just about keeping things going. And it's not just here, but also over on our two other database newsletters, PostgreSQL Weekly and MongoDB Weekly which I wanted to take the opportunity to highlight today :-)
— Peter Cooper, editor

SQL vs. Flux: Choosing the Right Query Language for Time-Series Data — An examination of the strengths and weaknesses of SQL, and why query planners exist, by way of comparing TimescaleDB (a PostgreSQL extension) and InfluxDB.

Matvey Arye

When Should I Use Amazon Aurora and When Should I use RDS MySQL? — As a MySQL user, you can use both Aurora and RDS in a similar way, but they have different pros and cons. Aurora is proprietary and fast, but RDS gives you more flexibility if you need a specific MySQL version, etc.

Ananias Tsalouchidis (Percona)

New Whitepaper: Disaster Recovery for MySQL & MariaDB — Database outages are almost inevitable and understanding the timeline of an outage can help you better prepare, diagnose and recover from one. In this whitepaper, learn how to keep your systems online and handle outages when they occur.

Severalnines sponsor

Inside Fortnite's Massive Data Analytics Pipeline — Fortnite is a wildly popular (125 million players!) multiplayer game and pulling together all the data to keep it running is no small feat.

Datanami

R Generation: The Story of the R LanguageR is a statistical computing language and environment that’s very popular in the data science and business intelligence worlds. If this article encourages you to give R a go, you could do worse than this introductory tutorial.

Nick Thieme

Amazon Will Extricate Itself From Oracle Tech By 2020“Efforts to migrate away from Oracle’s leading database platform and onto native AWS services have been ongoing for years as a war of words has intensified between senior executives of the two technology giants.”

Joseph Tsidulko (CRN)

Amazon ElastiCache for Redis Now PCI DSS Compliant — So now you can use ElastiCache for Redis for the processing of sensitive payment card data.

Amazon Web Services

Build a Bikesharing App with Redis and Python — Leans on Redis’s geospatial commands that were introduced back with 3.2.

Tague Griffith

PostgreSQL Triggers and Stored Function Basics

Berend Tober

The Future of Storage: Hardware — Fuelled by massive growth in data creation and analysis, the state of data storage hardware is evolving at a considerable rate at the moment - here’s a roundup of some of the technologies involved.

Datanami

▶  Modernizing Mission-Critical Apps with SQL Server — Digs into a lot of the latest SQL Server performance features.

Nellie Gustafsson and Pedro Lopes (Microsoft)

▶  Scaling Postgres: A Weekly Video Series — Experienced DBA Creston Jamison produces practical, weekly videos on working with Postgres.

YouTube

Studio 3T Adds SQL Joins Wizardry To Its MongoDB IDE — Transfer your SQL skills to the new enterprise database, read: “How to Create MongoDB Joins Using SQL.”

Studio 3T sponsor

Oracle-PostgreSQL Sync 1.0: A Tool to Synchronize Oracle and Postgres Databases — A commercial Windows app (Linux supported via WINE) for bi-directional incremental synchronization of Oracle and Postgres databases.

Intelligent Converters

HugeGraph: A Fast, Scalable Graph Database — Can be queried using Gremlin, integrates with Hadoop/Spark. Built in Java.

HugeGraph