#210 — June 29, 2018
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
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