A One Size Fits All Database Doesn't Fit Anyone

This week's database news

#210 — June 29, 2018 Read on the Web Database Weekly 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

A Cooperpress publication. Change your email address or Stop getting this newsletter © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom