#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. |
|
💻 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 Homebrew Project |
🛠 Tools and Code |
pspg: A Unix Pager Designed for Postgres (and MySQL) Tables — If you use 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 |