#270 — September 6, 2019
Database Weekly
Samsung Unveils Prototype of a Standards-Compliant 'Key-Value SSD' — The Storage Networking Industry Association (SNIA) have been working on a specification for SSDs to be used as key value stores and Samsung is working on a compliant implementation. This is an interesting development and paves the way for new forms of high performance, persistent key-value stores.
Billy Tallis
Timescale Cloud: Fully-Managed Time-Series Database — Get the freedom to deploy and manage time-series workloads across a variety of regions around the world, on the cloud provider of your choice (AWS, GCP, Azure), with just a few clicks. Sign up here for 300ドル in trial credits.
Timescale sponsor
The Predictive Database, A New Database Category? — We cover the crossover between AI, machine learning, and databases quite often here, and these thoughts really mix it all together for making database queries that automatically ‘predict’ things behind the scenes. Naturally, a new database, Aito, is then promoted as the answer 😄
Antti Rauhala
Dgraph 1.1: A Fast, Distributed Graph Database Built in Go — Aims to provide "Google production level scale and throughput" at low latency and supports a GraphQL-like query syntax. v1.1.0 is just out.
Dgraph
MongoDB Atlas Data Lake, Now Explorable with MongoDB Compass — MongoDB Data Lake, currently in beta, is a fully managed data lake as a service that lets you explore semi-structured data stored on AWS S3 (other stores to be supported in due course) using the MongoDB Query Language.
MongoDB, Inc.
Quick bytes:
- Yugabyte DB has passed the famously rigorous Jepsen testing program.
- Amazon ElasticCache (AWS's Redis service) now lets customers bring their own keys for encrypting data at rest.
- MongoDB's Atlas hosted services are now available on Azure Marketplace making billing easier for Azure users. Elasticsearch Service is also new on Azure Marketplace too.
- Brave, the creator of a Chromium-based privacy-oriented browser, has 'uncovered' a technique Google is allegedly using to circumvent GDPR privacy obligations.
💻 Jobs
Find a DB job through Vettery — Make a free profile, name your salary, and connect with hiring managers from top employers.
Vettery
📒 Everything else
Refactoring a Relational Database to Amazon DynamoDB — A walk through the process of reading, transforming, and writing SQL Server data from an Amazon EC2 instance to Amazon DynamoDB using AWS Glue.
Amazon Web Services
Top Redis Use Cases by Core Data Structure Types — Redis, the popular in-memory data structure server, has several main data types, each suited to different use cases.
Kristi Anderson
Free O’Reilly Book: Graph Algorithms — Get hands-on examples of how to use graph algorithms to forecast behavior, with sample code and tips for over 20 algorithms.
Neo4j sponsor
SQL JOINs, Explained Without the Venn Diagrams — JOINs and UNIONs are the first big learning curve after getting your head around SQL basics.
Helen Anderson
Running PostgreSQL on Google Cloud Platform (GCP) — A look at the features Google’s platform offers for Postgres users.
Viorel Tabara
How to Write a Redis Module in Zig — Redis supports modules, custom extensions that add new commands, data types, and functionalities to a Redis database, and this is a look at creating such a module using a little known, but very interesting, language..
Loris Cro
Replicating PostgreSQL into MemSQL's Columnstore — How to get the high performance of MemSQL’s columnstore for queries while keeping transaction data in PostgreSQL for updates.
Oryan Moshe
MongoDB Removed from Homebrew's Core Formulas, But.. — Due to recent changes to MongoDB’s license, the mongodb formula in the Homebrew package manager (commonly used on macOS) has been removed, but MongoDB has its own official brew tap you should use instead via brew tap mongodb/brew
Homebrew Project
🛠 Tools and Code
pspg: A Unix Pager Designed for Postgres (and MySQL) Tables — If you use psql you probably use less as your pager, but it doesn’t directly support tabular data. This does! The latest master branch version also supports sorting by column. MySQL is also supported.
Pavel Stehule
eBay's TSV Utilities: Command Line Tools for Large, Tabular Data Files — Covers operations like filtering, statistics, sampling, joins and more. Intriguingly they’re written in D but binaries are available.
eBay