--- title: "An animation of the most popular databases since 2006" publication: "DB Weekly" issue: 328 published_at: "2020-10-30" canonical_url: "https://dbweekly.com/issues/328" --- Plus more database news, views, and links. #328 — October 30, 2020 [Read on the Web](https://dbweekly.com/issues/328) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/gvdimepuwfjuhg4vodil.jpg)](https://blog.timescale.com/blog/timescaledb-2-0-a-multi-node-petabyte-scale-completely-free-relational-database-for-time-series/) [TimescaleDB 2.0: A Petabyte-Scale Relational Database for Time-Series](https://blog.timescale.com/blog/timescaledb-2-0-a-multi-node-petabyte-scale-completely-free-relational-database-for-time-series/) — They really go all out to sell TimescaleDB here, but they have reason to be proud of their Postgres-based database which seems to go from strength to strength. v2.0 brings multi-node support, improved licensing (everything’s free), and more (as [explained in these tweets](https://twitter.com/michaelfreedman/status/1321858831689895936?s=20)). Ajay Kulkarni and Mike Freedman (Timescale) ▶[The Most Popular Databases: From 2006 to 2020](https://www.youtube.com/watch?v=fWC5tP9hDms) — A bar chart that shifts and changes over time based on the popularity of different database systems (as determined by the [TOPDB index](https://pypl.github.io/DB.html)). Not definitive by any means but interesting to see the shifts nonetheless. YouTube [![\](https://copm.s3.amazonaws.com/fb01948c.png)](https://www.cybertec-postgresql.com/en/products/cybertec-migrator/) [CYBERTEC Migrator - The Easiest Way from Oracle to Postgres](https://www.cybertec-postgresql.com/en/products/cybertec-migrator/) — CYBERTEC Migrator is an easy and user-friendly tool with a visual interface that helps you to efficiently migrate multiple Oracle databases to PostgreSQL. Newest features are close-to-zero downtime migration (CDC) or automatic code rewrite. CYBERTEC sponsor [Microsoft Overhauls Excel with Live Custom Data Types](https://www.theverge.com/2020/10/29/21539844/microsoft-excel-custom-data-types-power-bi-wolfram-alpha-power-query-data) — A few months ago we mentioned [scientists were renaming human genes](https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates) due to auto-formatting issues in Excel(!) but now Excel is getting more powerful with support for custom live data types. Tom Warren (The Verge) ▶[How a Man Learning Postgres Exposed 40K Voters Purged By Mistake](https://www.youtube.com/watch?v=d5jK4BzbgXw) — A long-time database administrator was running queries on voter data to learn how to use Postgres and stumbled over a significant voter purge error. May you too be able to use your powers of database good to improve democracy :-) VICE (on YouTube) [AWS Nitro Enclaves: Isolated EC2 Environments to Process Confidential Data](https://aws.amazon.com/blogs/aws/aws-nitro-enclaves-isolated-ec2-environments-to-process-confidential-data/) — Aimed at AWS users processing ‘highly sensitive data’, _Nitro Enclaves_ lets EC2 users create isolated environments on instances powered by [Nitro.](https://aws.amazon.com/ec2/nitro/) Jeff Barr (AWS) [AWS Step Functions Now Supports Amazon Athena Service Integration](https://aws.amazon.com/about-aws/whats-new/2020/10/aws-step-functions-now-supports-amazon-athena-service-integration/) — More easily build workflows that query data on your S3 data lake. Amazon Web Services, Inc. [You Don’t Need a Blockchain, You Need a Time-Series Database?](https://thenewstack.io/you-dont-need-a-blockchain-you-need-a-time-series-database/) — Apparently time series databases share many properties with enterprise blockchains, so maybe you should try one instead (says a co-creator of [QuestDB](https://questdb.io/), a time series database). Nicolas Hourcard [How Dolt Implemented Pushdown Filters to Make Queries Faster](https://www.dolthub.com/blog/2020-10-28-pushdown-filters/) — ‘Pushdown’ is where you move the predicates in a `WHERE` clause to be under the join, reducing the number of rows you have to examine. [Dolt](https://github.com/dolthub/dolt) itself is a SQL database that adopts many of Git’s concepts to provide version control primitives over data. Zach Musgrave [What Is This Mythical Zero Downtime Database Migration to the Cloud?](https://www.devgraph.com/scalearc/) — Join us for a CIO led panel discussion on the issues and risks and the technology available to streamline the experience. ScaleArc sponsor [Memgraph 1.2 Release - Implementing The Bolt Protocol v4](https://memgraph.com/blog/memgraph-1-2-release-implementing-the-bolt-protocol-v4) — _“We thought that it would be interesting to discuss the Bolt Protocol for those of you who are interested in graph databases, and explore what goes into being wire-compatible with another database system.”_ Memgraph Team [100,000+ Books in Plain Text Format](https://twitter.com/theshawwn/status/1320282149329784833) — This is targeted at people with machine learning use cases but could be ideal as a dataset for all sorts of things. It’s a 37GB download though. There’s also a 100GB file containing source code for similar purposes. It’s all [explained in more detail here.](https://github.com/soskek/bookcorpus/issues/27#issuecomment-716104208) Shawn Presser on Twitter [SMASH: An Efficient Compression Algorithm for Microcontrollers](https://blog.segger.com/smash-an-efficient-compression-algorithm-for-microcontrollers/) SEGGER Micro [Running a Scale-Out Database on ARM as a MySQL Alternative](https://pingcap.com/case-studies/running-a-scale-out-database-on-arm-as-mysql-alternative) — A TiDB case study featuring a customer who chose it to run on ARM-based systems. PingCAP [Embedded SQL for GnuCOBOL using ocesql](https://bigdanzblog.wordpress.com/2020/10/28/embedded-sql-for-gnucobol-using-ocesql/) — Certainly not a topic we cover every day ;-) Dan TheMan 💻 Job [DevOps Engineer at X-Team (Remote)](https://x-team.com/remote-devops-engineer-jobs/?utm_source=cooperpress&utm_medium=email-ad&utm_campaign=db) — Join the most energizing community for developers and work on projects for Riot Games, FOX, Sony, Coinbase, and more. X-Team 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