#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 |
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 |