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.

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