Query DynamoDB tables with SQL
Want to aggregate, filter, or join DynamoDB tables with SQL? Here's how to do it, and why you should (and shouldn't) query DynamoDB tables with SQL.
October 30, 2024
ClickHouse Partnership, improved Postgres Replication, and Disk Management
Improving the developer experience between Postgres and ClickHouse.
How to Correctly Sum Up Numbers
How to Correctly Sum Up Numbers
One of the first examples for loops in probably every programming language course is taking a list of numbers and calculating the sum of them. And in every programming language, it’s trivial to write up a solution:
int sumUpNumbers(std::span<const int> numbers) {
int sum = 0;
for (int i : numbers)
sum += i;
return sum;
}
If you compile this with a modern optimizing compiler, you will even get very efficient vectorized code, that sums millions of integers per second. Nice!
October 29, 2024
Announcing Vitess 21
Vitess 21 is now generally available.
Announcing Vitess 21
Announcing Vitess 21 # We're delighted to announce the release of Vitess 21 along with version 2.14.0 of the Vitess Kubernetes Operator.
Version 21 focuses on enhancing query compatibility, improving cluster management, and expanding VReplication capabilities, with experimental support for atomic distributed transactions and recursive CTEs. Key features include reference table materialization, multi-metric throttler support, and enhanced Online DDL functionality. Backup and restore processes benefit from a new mysqlshell engine, while vexplain now offers detailed execution traces and schema analysis.
October 28, 2024
The Tinybird DynamoDB Connector is now GA
The Tinybird DynamoDB Connector is now GA and ready for production use in all Workspaces.
Last month, the DynamoDB Connector hatched into public beta, and quickly broke the record for fastest adoption of a Connector launch yet. We knew DynamoDB was popular, but the reception was beyond what we expected!
“Tinybird's DynamoDB Connector has proved to be easy to set up, reliable and low-latency, while providing cross partition queries, with unlimited indexing, at sub second speeds for our massive
October 27, 2024
SIGMOD Programming Contest Archive: Hybrid Vector Search (2024)
SIGMOD Programming Contest Archive: Approximate K-nearest-neighbor Graph Construction (2023)
SIGMOD Programming Contest Archive: Blocking System for Entity Resolution (2022)
October 21, 2024
Announcing the PlanetScale vectors public beta
You can now use the vector data type for vector search and storage in your PlanetScale MySQL database.
Group Commit and Transaction Dependency Tracking
MySQL 8.0 and newer change and improve how we measure and monitor replication lag. Even though multi-threaded replication (MTR) has been on by default for the last three years (since v8.0.27 released October 2021), the industry has been steeped in single-threaded replication for nearly 30 years. As a result, replication lag with MTR is a complicated topic because it depends on version, configuration, and more. This three-part series provides a detailed understanding, starting from what was originally an unrelated feature: binary log group commit.
October 15, 2024
Simple patterns for aggregating on DynamoDB
DynamoDB doesn't natively support aggregations, so here are four different approaches to aggregate data in DynamoDB tables.
October 10, 2024
Database Triggers
Triggers automatically run code whenever data in a table changes. A library in the convex-helpers npm package allows you to attach trigger functions to your Convex database.
Live Share: Connect to in-browser PGlite with any Postgres client
Connect any Postgres client to your postgres.new databases.
Anatomy of a Throttler, part 2
Design considerations for implementing a database throttler with a comparison of singular vs distributed throttler deployments.