In this final issue of 2017, we're looking back at what new database systems were released, the best case studies/stories, and the biggest releases of 2017. We'll be back on January 12, 2018 - thanks for your support and we hope you have a happy holiday season! :-)
Roundups
DB-Engines Popularity Ranking of Database Systems — Since December 2016, PostgreSQL, Elasticsearch, MariaDB, and Azure Cosmos DB have shown the biggest gains. Oracle, MySQL, SQL Server have had the biggest falls relatively, but still top the chart.
DB-Engines news
Developers' Most Loved, Dreaded, Wanted and Used Databases — Insights from 64,000 developers who took Stack Overflow’s latest survey show Redis, Postgres, and Mongo as the ‘most loved’ databases, Oracle the most dreaded, but MySQL and SQL Server the most used overall.
Stack Overflow news
MySQL Replication Tutorial For Disaster Recovery — This blog post is a step by step tutorial on how to set up MySQL Replication between AWS regions. This is an essential part of our disaster recovery plan at Engine Yard. A previous blog post gives a higher level overview on disaster recovery.
PostgreSQL 10 Released — The popular open source database includes native logical replication, declarative table partitioning, and improved query parallelism. More on what’s new here.
Postgres.org news
MongoDB 3.6 Released: Security, Robustness and JSON Schema — A new version of the popular NoSQL database: better hardened against network outages with ‘Retryable Writes’, as well as against ransomware by only binding to localhost by default. It now also supports JSON Schema for data validation.
Redis 4.0 Released — The popular data structure server took a step forward with several key improvements including a new replication engine and official support for modules.
Salvatore Sanfilippo tools
SQL Server 2017 Released: What's New? — A look at the year’s big SQL Server release with new features from Python support to adaptive query optimization and a built-in graph database.
Microsoft
Elasticsearch 6.0.0 Released — The popular full-text search-oriented database gains zero downtime upgrades, faster restarts, faster query times, and more. The new version is based on Lucene 7.
Clinton Gormley news
Apache Kafka Goes 1.0 — Billing the popular event streaming platform ‘enterprise capable’, its creators reflect on its history and feature set.
How Discord Stores Billions of Messages with Cassandra — Discord is a popular chat system for gamers. They started out with MongoDB but here they explain why and how they moved to Cassandra, and how they dealt with garbage collection issues.
PostgreSQL At 10TB and Beyond — Chris Travers discusses what happens when managing over 10 terabytes of data in PostgreSQL. Does it scale and what kinds of problems need to be resolved?
Writing a Time Series Database from Scratch — Prometheus is an open source monitoring tool that includes a custom time series database. This is a deep dive into fleshing out a new architecture to address the existing database engine’s shortcomings.
JanusGraph: An Open-Source, Distributed Graph Database — A highly scalable transactional graph database optimized for storing and querying large graphs with billions of vertices and edges distributed across a multi-machine cluster.
GeoMesa: An Open-Source Spatio-Temporal Database Layer — GeoMesa provides spatio-temporal indexing on top of Accumulo, Bigtable, and Cassandra, as well as near real-time stream processing and spatial semantics on top of Kafka.
Amazon Aurora Serverless: Databases on Demand — Aurora is AWS’s MySQL- and Postgres-compatible scalable database service and they’re now working on a pay-as-you-go variant for highly variable workloads.
