#213 — July 20, 2018 |
Database Weekly |
Keeping Play Counts In Sync on SoundCloud — “what might seem like a simple counting system is actually a cornucopia of services” .. and it involves Cassandra, HDFS, memcached, and Kafka! Interesting to see the dataflows in a high scale service like SoundCloud. SoundCloud |
Python Gains Traction Among Data Scientists — Though that’s not the whole story with R preferred in the retail sector and SAS in healthcare. Datanami |
▶ A Technical Overview of Azure Cosmos DB — Azure Cosmos DB is one of the more interesting databases of recent years, being a highly scalable multi-model database. It’s Azure only, though there is a local emulator. Microsoft Developer |
Now Available: MongoDB Atlas Free Tier on Google Cloud Platform — At MongoDB World 2018, Google Cloud Platform and MongoDB announced the general availability of MongoDB Atlas's free replica sets on GCP. Get your free 3-node replica set today. MONGODB sponsor |
Gracefully Scaling to 10k PostgreSQL Connections for Cheap — A now-complete three part series (part 2 and part 3) on how a team of engineers have scaled PostgreSQL using PgBouncer and Kubernetes. Alexander H. Black |
Why Blockchains Don’t Suck, and the Perils of Distributed Databases — Hello, controversial post alert :-) “The aim of this post was to present a counterpoint to the mid-2018 trend of slamming blockchain technologies.” Coral Health |
Google Compute Now Has 'ultramem' Machine Types with 4TB RAM — Up to 160 vCPUs (a record for a public cloud) and 4TB of memory on a single instance are now available. Unsurprisingly, SAP workloads are a target for such scale. |
New Amazon EC2 Instance Types Announced: Z1d, R5 and R5d — The new instance types are all compute or memory optimized with Z1d instances optimized for the highest per-core performance and the R5 and R5d instances aimed at databases and analytics use. Jeff Barr (AWS) |
MapD's GPU-Powered Database Now Available in Google Cloud's Marketplace — GPU-powered database MapD is now available through the Google Cloud Launcher. Datanami |
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 |
How SQL DISTINCT and ORDER BY are Related Lukas Eder |
AWS Kinesis with Lambdas: Lessons Learned at Scale at Trivago — Trivago built a serverless pipeline to replicate data stored in on-premise MySQL machines to AWS. Trivago |
Uniting SQL and NoSQL for Monitoring: Why PostgreSQL Is The Ultimate Data Store for Prometheus Niksa Jakovljevic |
HuskyDB: Windows Native C++ NoSQL Database — A lightweight document-oriented database optimized for Windows. Peter Gramenides |
Redisson: A Redis-Based Java In-Memory Data Grid Redisson |
kafka_fdw: Apache Kafka Foreign Database Wrapper for Postgres — Want to query Kafka directly from Postgres? This FDW allows you to treat a Kafka stream like a Postgres table. adjust |