--- title: "A new scripting language for Redis" publication: "DB Weekly" issue: 263 published_at: "2019-07-19" canonical_url: "https://dbweekly.com/issues/263" --- This week's database news #263 — July 19, 2019 [Read on the Web](https://dbweekly.com/issues/263) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/avyzcxj6dbmynkkcfocy.jpg)](https://www.mongodb.com/blog/post/benchmarking-do-it-right-or-dont-do-it-at-all) [MongoDB on Benchmarking: 'Do It Right or Don't Do It At All'](https://www.mongodb.com/blog/post/benchmarking-do-it-right-or-dont-do-it-at-all) — MongoDB, Inc. has responded to a [recent benchmark](https://www.enterprisedb.com/news/new-benchmarks-show-postgres-dominating-mongodb-varied-workloads) that showed PostgreSQL winning over MongoDB performance-wise, but [benchmarking is hard](https://www.pingcap.com/blog/why-benchmarking-distributed-databases-is-so-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](https://redislabs.com/blog/introduction-redis-gears/) — 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.](https://github.com/RedisGears/RedisGears) Redis Labs [![\](https://copm.s3.amazonaws.com/deb4409d.png)](https://studio3t.com/mongodb-sql-coexistence-whitepaper/?utm_source=cooper&utm_medium=newsletter&utm_campaign=july19) [The DevOps Perspective on Database Coexistence](https://studio3t.com/mongodb-sql-coexistence-whitepaper/?utm_source=cooper&utm_medium=newsletter&utm_campaign=july19) — 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 Source](https://blog.yugabyte.com/why-we-changed-yugabyte-db-licensing-to-100-open-source/) — [Yugabyte](https://www.yugabyte.com/) 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](https://www.datanami.com/2019/07/15/big-data-is-still-hard-heres-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](https://siliconangle.com/2019/07/16/8m-hotel-records-exposed-latest-elasticsearch-database-configuration-fail/) — 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?](https://news.ycombinator.com/item?id=20472640) — A Hacker News discussion on [CockroachDB](https://github.com/cockroachdb/cockroach), the distributed SQL database, its use cases, and who’s actually using it. There’s an [interesting explanation](https://news.ycombinator.com/item?id=20473985) of TiDB, Yugabyte, Citus, and MemSQL buried in there too. Hacker News [The Story of Streaming Cassandra at WePay](https://wecode.wepay.com/posts/streaming-cassandra-at-wepay-part-1) — 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](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Vettery specializes in tech roles and is completely free for job seekers. Vettery 📒 Tutorials and Tools ▶[Writing an Interpreter in SQL for Fun](https://www.youtube.com/watch?v=MPSMH8w7nfw) — 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](https://rockset.com/blog/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](https://rockset.com/), a SQL-based analytics system for event data. Purvi Desai [Getting Started Deploying Postgres Databases in Containers](https://info.enterprisedb.com/WhitepaperDeployingPostgresDatabasesinContainers-advertising.html?utm_source=Cooperpress&utm_medium=ad) — 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](https://dev.to/helenanders26/sql-301-why-you-need-sql-window-functions-part-1-6e1) — 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](https://www.youtube.com/watch?v=JQ0ycS8HqjE) — 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](https://www.percona.com/blog/2019/07/17/assessing-mysql-performance-amongst-aws-options-part-one/) — Comparing Amazon Aurora, RDS, and two Percona Server-based options. Alexey Stroganov (Percona) [OctoSQL: Join, Analyze, and Transform Data From Multiple Sources using SQL](https://github.com/cube2222/octosql) — Supported sources are CSV, JSON, MySQL, PostgreSQL, and Redis. Jacob Martin 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