--- title: "The Redis 7.0 roadmap" publication: "DB Weekly" issue: 351 published_at: "2021-04-23" canonical_url: "https://dbweekly.com/issues/351" --- Plus numerous ways to efficiently work with real-time SQL queries. | #​351 — April 23, 2021 [Read on the Web](https://dbweekly.com/issues/351) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/dvyp6rukccpdvakhc2oq.jpg)](https://dbgate.org/) [DbGate: Another Database Desktop Client App](https://dbgate.org/) — Built as an Electron app using Svelte as the underlying framework, this is a pretty elegant cross platform open source client for MySQL, Postgres, SQL Server and MongoDB. [Beekeeper Studio](https://www.beekeeperstudio.io/) and [TablePlus](https://tableplus.com/) are other worthy alternatives in this space. Jan Prochazka [Redis Labs Announces Roadmap for Redis 7.0](https://www.zdnet.com/article/redis-labs-unveils-redis-database-7-0/) — Redis has certainly turned more commercial since Salvatore Sanfilippo stepped back. Nonetheless, work on the high performance data structure store continues, and we’re teased with improved JSON support, RediSearch 2.0, active-active global replication, and more. Redis 7.0 is expected in the “second half” of the year. Tony Baer (ZDNet) [![\](https://copm.s3.amazonaws.com/ff294e91.png)](https://www.cockroachlabs.com/webinars/the-cockroach-hour-cap-theorem-series-consistency/?utm_campaign=cooperpress-2021-Q2&utm_source=dbweekly&utm_medium=sponsor&utm_content=dbweekly-primary-webinar-cap-consistency) [▶️ Webinar: CAP Theorem and Distributed Database Management](https://www.cockroachlabs.com/webinars/the-cockroach-hour-cap-theorem-series-consistency/?utm_campaign=cooperpress-2021-Q2&utm_source=dbweekly&utm_medium=sponsor&utm_content=dbweekly-primary-webinar-cap-consistency) — In this 3-part series, we’ll explore the three guarantees (Consistency, Availability & Partition Tolerance), delivering a definition for each, and outlining how each affects database implementations. [Join us on 4/28](https://www.cockroachlabs.com/webinars/the-cockroach-hour-cap-theorem-series-consistency/?utm_campaign=cooperpress-2021-Q2&utm_source=dbweekly&utm_medium=sponsor&utm_content=dbweekly-primary-webinar-cap-consistency) for the first session:**_Consistency_**. Cockroach Labs sponsor [Ask HN: Is There A Way to Efficiently Subscribe to An SQL Query for Changes?](https://news.ycombinator.com/item?id=26901352) — A Hacker News discussion where a lot of ideas got thrown into the pot. Lots of things popped out like [Materialize’s TAIL command](https://materialize.com/a-simple-and-efficient-real-time-application-powered-by-materializes-tail-command/), SQL Server’s _Query Notifications_, [Supabase Realtime](https://github.com/supabase/realtime), Asana’s [LunaDb](https://blog.asana.com/2015/10/asana-tech-talk-reactive-queries/), and [Noria](https://github.com/mit-pdos/noria). Hacker News [Amazon RDS for PostgreSQL Now Integrates with AWS Lambda](https://aws.amazon.com/about-aws/whats-new/2021/04/amazon-rds-postgresql-integrates-aws-lambda/) — Being able to invoke serverless _Lambda_ functions from within Postgres stored procedures or user-defined functions seems like it has some _huge_ potential. Amazon Web Services, Inc. Quick Bits - NoSQL Workbench for Amazon DynamoDB [now supports AWS CloudFormation](https://aws.amazon.com/about-aws/whats-new/2021/04/nosql-workbench-for-amazon-dynamodb-now-supports-aws-cloudformat/) so you can manage and modify DynamoDB data models with CloudFormation templates. - SQL Server 2017 on Google Cloud SQL now [supports Change Data Capture](https://cloud.google.com/blog/topics/developers-practitioners/track-changes-sql-server-google-cloud-using-change-data-capture). 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) — Join the most energizing community for developers and work on long-term projects for Riot Games, FOX, Sony, Coinbase, and more. X-Team [Find Data Engineering Jobs with Hired](https://hired.com/join/?utm_source=newsletter&utm_medium=sponsor&utm_campaign=%28b2c%29%28l-all%29%28r-all%29%28cooper-dbweekly%29&utm_content=5-minutes) — Take 5 minutes to build your free profile & start getting interviews for your next job. Companies on Hired are actively hiring right now. Hired ▶[MongoDB Schema Design Best Practices](https://www.youtube.com/watch?v=QAqK-R9HUhc) — A ten-minute video covering the basics of data modeling using real-world examples. You will learn common methodologies and vocabulary you can use when designing your database schema on your application. Joe Karlsson [240 Tables and No Documentation?](https://minimalmodeling.substack.com/p/240-tables-and-no-documentation) — A bit of advice on extracting the logical schema from database tables Alexey Makhotkin [Postgres Vision 2021 - Free Online Conference (June 22-23)](https://www.postgresvision.com/?utm_source=database-weekly&utm_medium=newsletter&utm_campaign=PGV2021) — This conference will explore the proliferation of Postgres, open source adoption & real-world stories from customers. EDB sponsor [Latency Comparison Among Serverless Databases: DynamoDB vs FaunaDB vs Upstash](https://blog.upstash.com/latency-comparison) — A benchmark coming from Upstash, a serverless Redis service, and it’s perhaps no surprise they win it, but.. the [discussions](https://news.ycombinator.com/item?id=26799074) (especially around [network latency issues](https://news.ycombinator.com/item?id=26799886)) and eventual rebuttals that come from such things are always interesting. Noah Fischer [pgvector: Vector Similarity Search Extension for Postgres](https://github.com/ankane/pgvector) — Supports L2 distance, inner product, and cosine distance. Andrew Kane [sheet2dict: A Simple XLSX and CSV to Dictionary Converter for Python](https://github.com/Pytlicek/sheet2dict) Tomas Pytel [Create Your First Serverless GraphQL API with AWS Lambda and MySQL](https://shadi-ayoub.medium.com/create-your-first-serverless-graphql-api-with-aws-lambda-and-mysql-database-69d5c4d76457) Shadi Ayoub 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