#270 — September 6, 2019

Read on the Web

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 CompassMongoDB 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:

💻 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

Monstache: A Daemon That Syncs MongoDB to Elasticsearch in Realtime

Ryan Wynn

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