#339 — January 29, 2021

Read on the Web

Database Weekly

Announcing the Pinecone Vector DatabasePinecone is a managed, commercial database for working with vectors, making it ideal for things like semantic search, personalization, recommendation engines, etc. Its founder used to head Amazon AI Labs and built parts of SageMaker and Rekognition. They’ve also just taken $10M of funding to help take things further.

Ron Miller (TechCrunch

Postgres on ARM-Based AWS EC2 Instances: Is It Any Good? — As exciting as Apple’s developments with its own ARM-based chips are, AWS also has made big progress with its own Graviton2 CPUs – here’s how they fare when running Postgres. In short, it’s good news and is likely to ring true with other database systems too.

Jobin Augustine and Sergey Kuzmichev

▶️ Webinar: Benchmarking AWS, GCP, Azure - 2021 Cloud Report — GCP was named the best performing cloud for transactional (OLTP) workloads in the 2021 Cloud Report. Join our engineers in a live Q&A to hear how we benchmark AWS, Azure, and GCP -- and why we open source all of our results and methodology.

Cockroach Labs sponsor

CrateDB 4.4 Released: A Scalable SQL Database for Machine Data — If you want to query a firehose of data in real time using SQL but with some NoSQL magic under the hood, this is worth considering. The Crate team has also announced they’re doubling down on permissive licensing in the shadow of the Elasticsearch drama and will open source under the Apache 2.0 license from CrateDB 4.5 onward.

Mathias Fußenegger (CrateDB)

Introducing Neo4j Aura Enterprise: Enterprise Graph Databases in the Cloud — Neo4j, the creators of an eponymous open source graph database, have unveiled their move to a managed, cloud service in the form of the enterprise-focused Aura.

Ben Butler-Cole (Neo4j)

IndraDB 2.0: A Graph Database Written in Rust — You can use it as a server (as with most databases) or embed it directly into a Rust app. Inspired by TAO, Indra aims to be a high performance graph database supporting directed and typed graphs. The underlying data storage can be provided by memory, RocksDDB, Sled, or even Postgres.

IndraDB

Quick Bits

Understanding DynamoDB Condition Expressions — One of the leading experts in DynamoDB (AWS’s hugely scalable NoSQL database service) gives us a better mental model for thinking about condition expressions.

Alex DeBrie

How Kount Migrated A Critical Workload From Cassandra to DynamoDB — An AWS case study covering both the high level thinking and some of the technical approaches to how and why a real time fraud prevention platform moved their long-term storage from Cassandra to DynamoDB.

Edin Zulich and Chris Galli

Building Resilient GraphQL Apps and Scaling Them to 1M Subscriptions
Nikhil Chandrappa (Yugabyte)

💻 Jobs

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

X-Team

🔨 Code and Tools

Sqlectron: A Single GUI Client for Several Relational DBs — This has been around for years but, reassuringly, continues to get updates. Available for macOS, Windows and Linux, this is a straightforward client that works with Postgres, Redshift, MySQL, MariaDB, SQL Server, SQLite and Cassandra (to a basic extent). There’s also a terminal UI based equivalent.

Sqlectron

Vitess 9: Database Clustering System for Horizontal Scaling of MySQL — Essentially sharding middleware for MySQL. It originally spawned from scaling problems that YouTube had (background story here). Built primarily in Go.

Alkin Tezuysal

Discover the MongoDB Data Masking Tool in Studio 3T Enterprise — Enable data compliance and bolster security with powerful field-level data obfuscation. Try it today - free.

Studio 3T sponsor

JuiceFS: A Distributed POSIX File System Built on top of Redis and Object Storage — JuiceFS stores file metadata in Redis using object storage for the file contents and supports all major cloud provider object storage services (such as S3, Google Cloud Store, Azure Blog Storage..)

Juicedata, Inc

Fx: A Command-Line JSON Processing Tool — If you’ve got some files full of JSON that you want to process, Fx will slice and dice it however you want, including using JavaScript one-liners to add a bit of logic to the process.

Anton Medvedev

tbls: A CI-Friendly Tool for Documenting Databases — Document a database automatically in GitHub Friendly Markdown format. By default you get documentation covering columns, indexes, relations, and other schema details. Written in Go.

Ken’ichiro Oyama