#263 — July 19, 2019

Read on the Web

Database Weekly

MongoDB on Benchmarking: 'Do It Right or Don't Do It At All' — MongoDB, Inc. has responded to a recent benchmark that showed PostgreSQL winning over MongoDB performance-wise, but benchmarking is hard and MongoDB were unimpressed so have countered with some benchmarks of their own. As always, take everything into account before relying upon benchmarks.

Greg McKeon (MongoDB, Inc.)

Redis Gears: A New Scripting Language for Redis — An interesting addition to the Redis data structure key/value store. Gears is a new module that adds a Python-based, cluster-aware scripting language for performing more advanced queries upon data. GitHub repo.

Redis Labs

The DevOps Perspective on Database Coexistence — Whether you're in DevOps, development, or database administration, download the full SQL Migration whitepaper for free, from Studio 3T.

Studio 3T sponsor

YugaByte DB Relicenses as 100% Open SourceYugabyte has been around for a few years and is a high performance, distributed database that supports both SQL and Cassandra APIs. It’s now fully open source including its previously closed-source, enterprise features.

Karthik Ranganathan (YugaByte)

Big Data Is Still Hard. Here's Why — An opinion piece reflecting on a decade of the Hadoop-driven era of “big data” and noting that the goalposts keep moving.. with a proliferation of new technologies and large moves to ‘the cloud’.

Datanami

8M Lines of Hotel-related Code Exposed in Elasticsearch Database Configuration Failure — If you don’t have a system around setting and checking both the authentication and network access policies of all your database systems, now is the time to start.

SiliconANGLE

Ask HN: Anyone Using CockroachDB in Production? — A Hacker News discussion on CockroachDB, the distributed SQL database, its use cases, and who’s actually using it. There’s an interesting explanation of TiDB, Yugabyte, Citus, and MemSQL buried in there too.

Hacker News

The Story of Streaming Cassandra at WePay — WePay was a heavy MySQL user but upon facing scaling issues, they had to decide whether to shard MySQL or switch to a different solution. They went with Cassandra.

Joy Gao (WePay)

💻 Jobs

Land a New Dev Job on Vettery — Vettery specializes in tech roles and is completely free for job seekers.

Vettery

📒 Tutorials and Tools

▶  Writing an Interpreter in SQL for Fun — It depends upon your idea of fun but it’s great to see that this sort of thing is possible. I love the quote that “SQL code is a bizarre combination of yelling and relational algebra.”

Michael Malis

SQL Query Planning for Operational Analytics — A look at how SQL query planning is implemented to support operational analytics requirements, like low latency and high concurrency, in Rockset, a SQL-based analytics system for event data.

Purvi Desai

Getting Started Deploying Postgres Databases in Containers — Explore what is driving the growth of containers, as well as the opportunities of a container use case: databases.

EnterpriseDB sponsor

SQL 301: Why You Need SQL Window Functions — Window Functions are powerful and allow you to see the rows in a table with a new column showing a running total, rank or moving average, etc.

Helen Anderson

▶  The Vision for Graph Database from Postgres — A talk given a few weeks ago at Postgres Vision 2019 about AgensGraph, a multi-model graph database built on top of Postgres. The audio isn’t great but you get a good overview of what AgensGraph is and how it helps.

AgensGraph

Assessing MySQL Performance Amongst the AWS Options — Comparing Amazon Aurora, RDS, and two Percona Server-based options.

Alexey Stroganov (Percona)

OctoSQL: Join, Analyze, and Transform Data From Multiple Sources using SQL — Supported sources are CSV, JSON, MySQL, PostgreSQL, and Redis.

Jacob Martin