--- title: "Predictive databases.. a new category of database?" publication: "DB Weekly" issue: 270 published_at: "2019-09-06" canonical_url: "https://dbweekly.com/issues/270" --- This week's database news #270 — September 6, 2019 [Read on the Web](https://dbweekly.com/issues/270) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/bgkvgy6izno15kaxuxyl.jpg)](https://www.anandtech.com/show/14839/samsung-announces-standardscompliant-keyvalue-ssd-prototype) [Samsung Unveils Prototype of a Standards-Compliant 'Key-Value SSD'](https://www.anandtech.com/show/14839/samsung-announces-standardscompliant-keyvalue-ssd-prototype) — The Storage Networking Industry Association (SNIA) have been working on [a specification](https://www.snia.org/tech_activities/standards/curr_standards/kvsapi) 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 [![\](https://copm.s3.amazonaws.com/bf4a3134.jpg)](https://hubs.ly/H0kxwcX0) [Timescale Cloud: Fully-Managed Time-Series Database](https://hubs.ly/H0kxwcX0) — 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](https://www.timescale.com/cloud-signup?utm_campaign=db-weekly-sponsor&utm_source=db-weekly-newsletter-september%20&utm_medium=referral&utm_content=timescale-cloud-sign-up) for $300 in trial credits. Timescale sponsor [The Predictive Database, A New Database Category?](https://aito.ai/blog/introducing-a-new-database-category-the-predictive-database/) — 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](https://aito.ai/), is then promoted as the answer 😄 Antti Rauhala [Dgraph 1.1: A Fast, Distributed Graph Database Built in Go](https://github.com/dgraph-io/dgraph) — Aims to provide “Google production level scale and throughput” at low latency and supports a GraphQL-_like_ query syntax. [v1.1.0](https://github.com/dgraph-io/dgraph/releases/tag/v1.1.0) is just out. Dgraph [MongoDB Atlas Data Lake, Now Explorable with MongoDB Compass](https://www.mongodb.com/blog/post/atlas-data-lake-and-mongodb-compass-connected) — [MongoDB Data Lake](https://www.mongodb.com/atlas/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](https://blog.yugabyte.com/yugabyte-db-distributed-sql-api-passes-jepsen-tests/) the famously rigorous Jepsen testing program. - Amazon ElasticCache (AWS's Redis service) [now lets customers bring their own keys](https://aws.amazon.com/about-aws/whats-new/2019/08/amazon-elasticache-for-redis-adds-support-for-customer-managed-keys-in-aws-key-management-service-for-encryption-at-rest/) for encrypting data at rest. - MongoDB's Atlas hosted services are [now available on Azure Marketplace](https://www.mongodb.com/press/mongodb-atlas-launches-on-microsoft-azure-marketplace-offering-unified-billing-for-joint-customers) making billing easier for Azure users. [Elasticsearch Service is also](https://www.elastic.co/blog/elasticsearch-service-on-elastic-cloud-now-available-on-microsoft-azure) new on Azure Marketplace too. - Brave, the creator of a Chromium-based privacy-oriented browser, has ['uncovered' a technique Google is allegedly using](https://brave.com/google-gdpr-workaround/) to circumvent GDPR privacy obligations. 💻 Jobs [Find a DB job through Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — 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](https://aws.amazon.com/blogs/database/refactoring-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](http://highscalability.com/blog/2019/9/3/top-redis-use-cases-by-core-data-structure-types.html) — 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](https://neo4j.com/graph-algorithms-book/?utm_source=db-weekly&utm_medium=nsltrsl&utm_campaign=dl) — 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](http://www.helenanderson.co.nz/sql-joins/) — 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)](https://severalnines.com/database-blog/cloud-vendor-deep-dive-postgresql-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](https://redislabs.com/blog/write-redis-module-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..](https://ziglang.org/) Loris Cro [Replicating PostgreSQL into MemSQL's Columnstore](https://www.memsql.com/blog/replicating-postgresql-into-memsqls-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..](https://github.com/Homebrew/homebrew-core/pull/43770) — Due to recent changes to MongoDB’s license, the `mongodb` formula in the [Homebrew](https://brew.sh/) package manager (commonly used on macOS) has been removed, but MongoDB has [its own official brew tap](https://www.mongodb.com/blog/post/mongodbs-official-brew-tap-now-open-and-flowing) you should use instead via `brew tap mongodb/brew` Homebrew Project 🛠 Tools and Code [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/nfgxq8b2htpbgfqcp0ue.jpg)](https://github.com/okbob/pspg) [pspg: A Unix Pager Designed for Postgres (and MySQL) Tables](https://github.com/okbob/pspg) — 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.](http://okbob.blogspot.com/2019/09/pspg-supports-sort-by-selected-column.html) MySQL is also supported. Pavel Stehule [Monstache: A Daemon That Syncs MongoDB to Elasticsearch in Realtime](https://github.com/rwynn/monstache) Ryan Wynn [eBay's TSV Utilities: Command Line Tools for Large, Tabular Data Files](https://github.com/eBay/tsv-utils) — Covers operations like filtering, statistics, sampling, joins and more. Intriguingly they’re written in _D_ but binaries are available. eBay A **[Cooperpress](https://cooperpress.com/)** publication. [Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom