#​351 — April 23, 2021

Read on the Web

Database Weekly

DbGate: Another Database Desktop Client App — 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 and TablePlus are other worthy alternatives in this space.

Jan Prochazka

Redis Labs Announces Roadmap for Redis 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)

▶️ Webinar: CAP Theorem and Distributed Database Management — 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 for the first session: Consistency.

Cockroach Labs sponsor

Ask HN: Is There A Way to Efficiently Subscribe to An SQL Query for Changes? — A Hacker News discussion where a lot of ideas got thrown into the pot. Lots of things popped out like Materialize’s TAIL command, SQL Server’s Query Notifications, Supabase Realtime, Asana’s LunaDb, and Noria.

Hacker News

Amazon RDS for PostgreSQL Now Integrates with 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


DevOps Engineer at X-Team (Remote) — Join the most energizing community for developers and work on long-term projects for Riot Games, FOX, Sony, Coinbase, and more.

Find Data Engineering Jobs with Hired — Take 5 minutes to build your free profile & start getting interviews for your next job. Companies on Hired are actively hiring right now.

▶  MongoDB Schema Design Best Practices — 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? — A bit of advice on extracting the logical schema from database tables

Alexey Makhotkin

Postgres Vision 2021 - Free Online Conference (June 22-23) — 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 — A benchmark coming from Upstash, a serverless Redis service, and it’s perhaps no surprise they win it, but.. the discussions (especially around network latency issues) and eventual rebuttals that come from such things are always interesting.

Noah Fischer

pgvector: Vector Similarity Search Extension for Postgres — Supports L2 distance, inner product, and cosine distance.

Andrew Kane

sheet2dict: A Simple XLSX and CSV to Dictionary Converter for Python
Tomas Pytel

Create Your First Serverless GraphQL API with AWS Lambda and MySQL
Shadi Ayoub