#351 — April 23, 2021
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
- NoSQL Workbench for Amazon DynamoDB now supports AWS CloudFormation so you can manage and modify DynamoDB data models with CloudFormation templates.
- SQL Server 2017 on Google Cloud SQL now supports Change Data Capture.
Jobs
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.
X-Team
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.
Hired
▶ 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