--- title: "MySQL was DB-Engines' DBMS of 2019" publication: "DB Weekly" issue: 286 published_at: "2020-01-10" canonical_url: "https://dbweekly.com/issues/286" --- Plus more database news, views, and links. #286 — January 10, 2020 [Read on the Web](https://dbweekly.com/issues/286) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/rkw8ickcr0oqeagfyjrd.jpg)](https://www.alexdebrie.com/posts/dynamodb-no-bad-queries/) [SQL, NoSQL, and Scale: How DynamoDB Scales Where Relational Databases Don't](https://www.alexdebrie.com/posts/dynamodb-no-bad-queries/) — It’s only a hunch, but I think we’re only going to see DynamoDB and some of its concepts continue to become more popular this decade. This interesting, lengthy article digs deep into _scalability_ and how DynamoDB’s ‘restrictions’ (or tradeoffs) help avoid scaling problems. Alex DeBrie ▶[Rust at Speed — Building A Fast Concurrent Database](https://www.youtube.com/watch?v=s19G6n0UjsM) — This talk packed in a _lot_ of interesting stuff both for people interested in Rust but also database systems in general and their implementation. Unsurprisingly it’s pretty technical but you’ll learn something here. Jon Gjengset [![\](https://copm.s3.amazonaws.com/2b307ec8.png)](https://www.arangodb.com/2020/01/arangodb-3-6-release-whats-new) [ArangoDB Introduces OneShard Deployments](https://www.arangodb.com/2020/01/arangodb-3-6-release-whats-new) — New release of the native multi-model database for graph, document and search introduces OneShard: Single instance performance and ACID semantics for HA deployments. The team also added vast performance upgrades and auto-complete capabilities. ArangoDB sponsor [MySQL is DB-Engines' DBMS of the Year 2019](https://db-engines.com/en/blog_post/83) — Well I certainly didn’t see _that_ coming, but DB-Engines saw MySQL gaining the most ‘popularity’ in its ranking system across 2019. _Oracle_ is runner up. Hmm. Matthias Gelbmann and Paul Andlinger [RDS's Price Premium over EC2 Can Be More Than You'd Expect](https://medium.com/@rbranson/rds-pricing-has-more-than-doubled-ef8c3b7e5218) — RDS is Amazon’s _Relational Database Service_ which can provide a fully managed Postgres, MySQL, Oracle, SQL Server, etc. service on AWS. The increasing price premium of RDS over EC2, however, surprised this developer. Rick Branson **Quick bytes:** - A disastrous IT migration [corrupted 1.3 billion customer records](https://increment.com/testing/what-broke-the-bank/). The culprit was insufficient testing. - Up for a podcast? AWS's Rick Houlihan spoke on the Software Engineering Daily podcast about [optimizing NoSQL databases](https://softwareengineeringdaily.com/2020/01/09/nosql-optimization-with-rick-houlihan/) (and DynamoDB, naturally). - AWS RDS, Aurora or DocumentDB user? It's [time to rotate your certificates.](https://aws.amazon.com/blogs/aws/urgent-important-rotate-your-amazon-rds-aurora-and-documentdb-certificates/) 💻 Jobs [DevOps Engineer at X-Team (Remote)](https://x-team.com/remote-devops-engineer-jobs/?utm_source=cooperpress&utm_medium=email-ad&utm_campaign=db) — Work with the world's leading brands, from anywhere. Travel the world while being part of the most energizing community of developers. X-Team [Find a Job Through Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Make a profile, name your salary, and connect with hiring managers from top employers. Vettery is completely free for job seekers. Vettery 📒 Articles [IPv4 to Host Lookups Quickly with ClickHouse and PostgreSQL](https://tech.marksblogg.com/fast-ip-to-hostname-clickhouse-postgresql.html) — I imagine the number of people who _need_ to do this is relatively small, but it’s an interesting problem and solution. Mark Litwintschik [A Survey of SQL:2011 Temporal Features](https://illuminatedcomputing.com/posts/2019/08/sql2011-survey/) — A look at features available in MariaDB, IBM DB2, Oracle, and SQL Server for working with time periods and system-time tracking of changes made to databases. [This slidedeck](https://github.com/pjungwir/postgres-temporal-talk/blob/master/slides.pdf) has more info if you’re new to this area. Paul A. Jungwirth [MongoDB Unveils an Official Rust Driver](https://www.mongodb.com/blog/post/announcing-the-official-mongodb-rust-driver) — If you’re buying into the hype, Rust could be one of the fastest growing programming languages of the new decade.. so here’s how to use it with MongoDB. Sam Rossi (MongoDB, Inc.) [Cloud Looms Large for Big Data in 2020](https://www.datanami.com/2020/01/07/cloud-looms-large-for-big-data-in-2020/) Datanami [Sharing SQLite Databases Across Containers Is Surprisingly Brilliant](https://medium.com/@rbranson/sharing-sqlite-databases-across-containers-is-surprisingly-brilliant-bacb8d753054) Rick Branson 🔨 Tools and Code [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/twcffc8g9hzqmy1ancyc.jpg)](https://dynobase.dev/) [Dynobase: A Professional GUI Client for DynamoDB](https://dynobase.dev/) — Build DynamoDB queries fast, generate instant code, use bookmarks & more. For Mac, Windows and Linux. It’s free but there’s a paid version with more features. Rafal Wilinski [Introducing Automated Postgres EXPLAIN Plan Insights on pganalyze](https://pganalyze.com/blog/automated-postgres-explain-plan-visualization-and-insights?utm_source=DBWeeklySecondary) — pganalyze now can automatically collect Postgres EXPLAIN plans and provide a visual representation of your costliest plan nodes. pganalyze sponsor [Message DB: An Event Store and Message Store for Postgres](https://blog.eventide-project.org/articles/announcing-message-db/) — Aimed at pub/sub, event sourcing and evented microservices use cases, Message DB can help you take advantage of the benefits of evented architecture but without going all the way to something like Apache Kafka. Eventide Project [RQLite 5.0 Released](http://www.philipotoole.com/rqlite-5-0-0-released/) — RQLite is a SQLite-based _distributed_ relational database that uses Hashicorp’s Raft implementation. Philip O'Toole [dynocsv: Export DynamoDB Tables Into CSV](https://github.com/zshamrock/dynocsv) Aliaksandr Kazlou 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