databases

Introduction. Window functions in SQL are powerful tools used to perform calculations across a specific "window" of rows related to the current row. Unlike aggregate functions (like SUM() , AVG() , COUNT() ), which collapse multiple rows into a single result, window functions retain individual rows while adding calculated values. They are commonly used for tasks like aggregates, rankings and runn…

We released Neki in platform preview yesterday. To celebrate the release, we wanted to test out running 1 million queries per second on Neki. We hit this goal pretty quickly on 5 shards and decided to see how much further we could push it. This next run ended with 512 shards running 118 million queries per second with 1.22 PiB of data. The benchmark was very simple. A single-shard point select, o…

01 Sharding Scale Postgres past the limits of a single machine to hundreds of millions of QPS and petabytes of data. Neki is sharded Postgres by PlanetScale. Every shard is real Postgres. Neki adds the router, sidecars, and control plane to scale it past a single machine, to hundreds of millions of QPS and petabytes of data, without downtime. [ NEKI ] 100M+ queriesper second PB+ of dataper databa…

Object storage is not a database. It stores bytes under keys. Yet it can serve as a database-like control-plane store when the workload fits a narrow set of contracts. The useful test is not a yes-or-no replacement claim. It is the set of guarantees the application needs, the ones the storage service supplies, and the ones the application must rebuild. The discussion around Ampbase and Tigris mak…

PostgreSQL 19 is set to ship with native SQL/PGQ support for property graph queries, thanks to a multi-vendor collaboration. Here’s what it means for you and when to expect it. The post PostgreSQL 19 property graph query syntax arrives, but indexing must catch up appeared first on SourceTrail .

Oracle databases expose a huge amount of performance information through dynamic performance views. The difficult part is not obtaining a metric at this exact moment. It is retaining enough connected evidence to investigate what happened after the workload has already changed. That is the problem I built Harry Performance Scraper for Oracle Database to solve. Harry is an open-source performance d…

Apache Kafka was designed to make good use of sequential I/O. Producers batch records, brokers append those batches to ordered log segments, and consumers read sequential ranges. Kafka also relies on the operating system's page cache and uses zero-copy techniques such as sendfile where possible. The Kafka design documentation explains why this works: batching turns many small operations into larg…

Tigris makes object storage using a database engine we built on top of FoundationDB: a distributed key-value store. JP, the founder of Ampbase, uses a control plane on Tigris with no database underneath it, and today he's going over which database behaviors he had to build himself and what that cost. Thanks JP! Last time on the Ampbase blog I talked about all the database engines that we don't us…

A desktop database client makes two demands nobody writes down: every laptop has to reach the production network, and every laptop has to hold a copy of every credential. Move the client onto a server next to the data and both demands disappear. The credential lives in one place instead of sixty. The network path becomes a deployment topology instead of a VPN grant per person. That is the trade. …

Published on September 8, 2026 8:12 PM GMT Hello! Last year, I posted https://forum.effectivealtruism.org/posts/z7AKFmJeZjZvbjwkt/announcing-scry-a-research-tool-over-arxiv-ea-forum-etc-w . I want to inform you that Scry has substantially improved. In all of your agent chats that support MCP, should you signup and add mcp.scry.io, you can execute extremely expressive query programs--SQL and much …