#321 — September 11, 2020

Read on the Web

Database Weekly

The CMU Database of Databases — An online encyclopedia of 714 (and counting) database systems, thanks to Carnegie Mellon University. We might have to spend some time going through this! It includes a leaderboard showing the most common countries of origin (US is #1 unsurprisingly), programming language used (Java at #1), and more.

Database of Databases

10 Exciting Big Data Statistics — Some fun stats that Datanami has pulled from a variety of places including that the ‘global datasphere’ will be 175 zettabytes (175 billion terabytes) in size by 2025 and that more data is created every hour in 2020 than in the entire of the year 2000. No wonder database technology remains a hot sector!

Datanami

Get 3x Higher Azure MySQL Throughput & Reduce Latency by 66% — See how the multi-cloud DBaaS provider ScaleGrid fares in this Azure MySQL Performance Benchmark vs. Azure Database for MySQL. Which provider offers the best throughput and latency performance for different workloads?

ScaleGrid sponsor

SQL Fiddle: A Tool for Online Testing of Database Queries — This isn’t new but as we haven’t linked it before and we use it quite a bit to test quick SQL queries and syntax, here you go. Set up your schema (which can be empty) on the left then issue queries on the right. Supports specific (slightly old) versions of MySQL, Oracle, Postgres, and SQL Server. DB Fiddle is a similar tool covering newer versions of MySQL and Postgres.

ZZZ Projects

Hasura Raises $25 Million Series B; Adds MySQL Support to Its GraphQL ServiceHasura provides a service and tooling for adding GraphQL API support to existing databases and has extended support to MySQL in addition to Postgres.

TechCrunch

Cassandra Gets an Indexing Upgrade — A new data storage framework for indexing on Apache Cassandra released this week by DataStax is aimed at easing adoption by eliminating tradeoffs between scale, stability and performance.

Datanami

AWS Announces Data API for Amazon Redshift — Amazon Redshift can now be accessed using the built-in Data API which simplifies access by removing the need to manage database connections and credentials.

Amazon Web Services

Generating a Normal Distribution in SQL — Postgres’s tablefunc extension provides a variety of functions that return tables, including sets of normally distributed random values.

Hans-Jürgen Schönig

Using PostgreSQL to Offload Real-Time Reporting and Analytics from MongoDB — Weighs up the advantages and disadvantages of moving read-heavy analytics off a primary MongoDB database to PostgreSQL.

Shawn Adams

Kodda: A Better Way to Integrate Your Data — Moving and modeling data should be easy, Kodda harnesses the power of SQL to automate the creation and management of data pipelines allowing your teams to focus on delivering insights.

Kodda sponsor

Mining for Logic Bugs in the Citus Extension to Postgres with SQLancer — One of those things you’re unlikely to need to do, but it’s nice to know how such problems are approached. SQLancer is a tool we’ve linked to before that helps you detect logic-related bugs in database systems.

Nazli Ugur Koyluoglu

Why BIGO Chose an HTAP Database over MySQL for Horizontal Scaling and Complex Queries — The creators of TiDB (an open-source, MySQL-compatible, horizontally scalable database) seem to be on a roll with these case studies, but unlike many business-oriented case studies they touch on a few interesting technical details.

Jiaqing Xu and PingCAP