#210 — June 29, 2018

Read on the Web

Database Weekly

https://www.allthingsdistributed.com/2018/06/purpose-built-databases-in-aws.html

A One Size Fits All Database Doesn't Fit Anyone — Amazon’s CTO is often asked why AWS offers so many database products. Here, he explains why, and explains his conviction that using multiple databases within an app is a good move.

Werner Vogels

MongoDB 4.0 Now Generally Available — MongoDB 4.0 is out with multi-document ACID transaction support being the headline feature. This landing page gives you access to the release keynote, downloads, a white paper, the press release, and more.

MongoDB

Analyzing 1.1 Billion Taxi Rides with SQLite, Parquet and HDFS — An interesting experiment of using SQLite to query data stored with Parquet (a column oriented format associated with Hadoop) using an SQLite addon called sqlite-parquet-vtable.

Mark Litwintschik

Get Optimised MongoDB Query Performance with Studio 3T — Read the latest article in our new tutorial series on MongoDB performance with a piece on the powerful Profiler, and also discover how the explain method can be an indispensable tool to improve queries and commands.

Studio 3T sponsor

How Heroku Upgraded Its Fleet of Redis Servers — Last week we mentioned Redis had become susceptible to some security vulnerabilities, so Heroku needed to upgrade its vast fleet of Redis servers quickly. Here’s how they managed it.

Heroku

A Look at MongoDB's Multi-Document ACID Transaction Support — This post reflects on MongoDB’s long-time support for single document transactions and why and where MongoDB 4.0’s multi-document transactions make sense via a practical example.

Mat Keep and Alyson Cabral

DB Fiddle: A Web-Based SQL Database Playground — It’s a bit like JS Fiddle but for playing with SQL in the browser. It offers MySQL 5.5-8.0, Postgres 9.4-10, and SQLite backends.

Status200

SequoiaDB 3.0 Released: A New-Generation Multi-Model NewSQL Database — Sadly we only have a press release for this for now, but it sounds interesting, being “the first Chinese database listed in Gartner’s Magic Quadrant OPDBMS report.”

SequoiaDB

Architecture and Tuning of Memory in Postgres Databases — An overview of Postgres memory management, the configuration parameters available, and tips on how to optimize them.

Severalnines

$20 Free On A New Linode Account — Linux cloud hosting starting at 1GB of RAM for $5/mo. Get $20 credit on a new account.

Linode Cloud Hosting sponsor

A Pentester's Basic Guide to PostgreSQL Hacking — If you need to secure a Postgres install, it’s handy to see what the basic approaches being used by the hackers are.

Netscylla Cyber Security

How Blockchain Is Impacting Data and Processes in Insurance — Blockchain approaches and smart contracts can help make the insurance industry more efficient.

Datanami

Why we Moved From NoSQL MongoDB to PostgreSQL — One company’s journey from MongoDB to Postgres explaining the rationale behind finally choosing Postgres.

Avi Cavale

MongoDB 4.0 Is Now Generally Available. Try It Now on MongoDB Atlas

MONGODB sponsor

A List of CLI Tools for Manipulating Structured Text Data — A list of around 80 tools for working with DSV/CSV, XML, HTML, JSON, YAML, INI & other formats.

Danyil Bohdan

Redis Graph: A Graph Database Module for Redis

Redis Labs