#216 — August 10, 2018 |
Database Weekly |
Amazon Aurora Serverless MySQL Generally Available — AWS is now bringing the scaling and billing flexibility of the serverless approach to MySQL in the shape of a serverless variety of its MySQL-compatible Aurora service. Randall Hunt (Amazon) |
Google Expands Its Cloud Firestore Beta to More Users — Google is expanding the availability of Cloud Firestore, its serverless NoSQL document database, adding new locations, features, and admin tools to the GCP console. Dan McGrath (Google) |
Monitoring Your PostgreSQL Database with Telegraf and InfluxDB — Learn how to use Telegraf (the agent for collecting and reporting metrics & events) and InfluxDB (the fastest growing open source TSDB) to monitor your PostgreSQL database. InfluxData sponsor |
Herb: Uber's Multi-DC Replication Engine for Its Schemaless Datastore — Schemaless is an interesting MySQL-based datastore Uber uses and here they share how they’ve made it resilient using their numerous datacenters and a technology called Herb. Himank Chaudhary |
An Introduction to MongoDB Transactions in Python — MongoDB 4.0’s headline new feature was multi-document transaction support. This article demonstrates how transactions work from Python within an example app that emulates a flight ticket ordering scenario. Joe Drumgoole (MongoDB) |
Taking a Tour of PostgreSQL with Jonathan Katz — The co-organizer of NYC PostgreSQL User Group discusses how Postgres started and how it has grown over the years. The Data Engineering Podcast |
Microsoft Announces GA of Azure SQL Database 'Reserved Capacity' — A new pricing model allows Azure SQL users to adapt to their needs more flexibly. Lindsey Allen (Microsoft) |
Using Kubernetes to Deploy Postgres — How to run a PostgreSQL database on a Kubernetes cluster using Docker containerization. Severalnines |
Webinar: Building Modern Apps with the MERN Stack and Google Cloud Platform — Learn about the two dominant JavaScript stacks: MEAN and MERN and how to implement these web stacks on GCP. MongoDB sponsor |
SQL: Nested Window Functions and Time Series llvllatrix |
Slashing a SQL Query's Runtime From 380 Hours to 12 with Two Unix Commands Diomidis Spinellis |
Larry Ellison Doubts Amazon Will Get Off Oracle by 2020? — “SAP couldn’t do it. Salesforce couldn’t do it. I don’t think they can do it,” said Oracle’s chairman. Almost sounds like a challenge :-) Jordan Novet (CNBC) |
Introducing the Time Series Benchmark Suite (TSBS) — A collection of Go(lang) programs that can both generate time-series datasets and then benchmark the performance of different databases for working with them. Rob Kiefer (Timescale) |
Condenser: A Database Subsetting Tool for PostgreSQL — “Subsetting a database means to take a subset of its rows, across multiple tables, while still maintaining all of the constraints of the original database.” Tonic |