--- title: "A One Size Fits All Database Doesn't Fit Anyone" publication: "DB Weekly" issue: 210 published_at: "2018-06-29" canonical_url: "https://dbweekly.com/issues/210" --- This week's database news #210 — June 29, 2018 [Read on the Web](https://dbweekly.com/issues/210) Database Weekly ![https://www.allthingsdistributed.com/2018/06/purpose-built-databases-in-aws.html](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/zxtxwyhmvtdfglcrcmlk.jpg) [A One Size Fits All Database Doesn't Fit Anyone](https://www.allthingsdistributed.com/2018/06/purpose-built-databases-in-aws.html) — 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](https://www.mongodb.com/mongodb-4.0) — 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](https://www.facebook.com/MongoDB/videos/10160448577425557/), downloads, a white paper, the press release, and more. MongoDB [Analyzing 1.1 Billion Taxi Rides with SQLite, Parquet and HDFS](http://tech.marksblogg.com/billion-nyc-taxi-rides-sqlite-parquet-hdfs.html) — 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](https://github.com/cldellow/sqlite-parquet-vtable/). Mark Litwintschik [![\](https://copm.s3.amazonaws.com/7aa91ff9.png)](https://studio3t.com/whats-new/mongodb-query-performance/?utm_source=dbweekly&utm_medium=newsletter&utm_campaign=june2018) [Get Optimised MongoDB Query Performance with Studio 3T](https://studio3t.com/whats-new/mongodb-query-performance/?utm_source=dbweekly&utm_medium=newsletter&utm_campaign=june2018) — 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](https://blog.heroku.com/rolling-redis-fleet) — Last week we mentioned Redis had become susceptible to [some security vulnerabilities](http://antirez.com/news/119), 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](https://www.mongodb.com/blog/post/mongodb-multi-document-acid-transactions-general-availability) — 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](https://www.db-fiddle.com/) — It’s a bit like [JS Fiddle](https://jsfiddle.net/) 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](https://www.prnewswire.com/news-releases/sequoiadb-3-0-released-new-generation-multi-model-newsql-database-300672038.html) — 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](https://severalnines.com/blog/architecture-and-tuning-memory-postgresql-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](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_campaign=db-weekly-sponsored) — 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](https://medium.com/@netscylla/pentesters-guide-to-postgresql-hacking-59895f4f007) — 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](https://www.datanami.com/2018/06/28/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](http://blog.shippable.com/why-we-moved-from-nosql-mongodb-to-postgressql?0) — 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](https://www.mongodb.com/cloud/atlas/lp/4-0?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY19Q1&utm_content=20180629&utm_medium=display&utm_source=dbweekly) MONGODB sponsor [A List of CLI Tools for Manipulating Structured Text Data](https://github.com/dbohdan/structured-text-tools) — 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](http://redisgraph.io/design/) Redis Labs 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