Replacing deep OFFSET pagination in D1: rows read and inserts between pages

·20 views

LIMIT 20 OFFSET ... makes the next page of a list easy to express. But deeper pages require skipping more rows without returning them. Using an index does not, by itself, eliminate that work. This experiment inserted 100,000 synthetic notifications into local D1 and fetched the same 20 records with OFFSET and a cursor.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Let the model decide — then read the audit

Most "governed agent" demos are governed because the demo author pulled every string. The agent calls the tool the script says, in the order the script says, and the audit comes out clean because nothing could have gone another way. That proves the plumbing. It does not prove governance, because governance is what happens when the thing you are governing has a will of its own. So we took the strings off.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Claude Code Mods Just Turned Agents Into a Platform

Claude Code Mods Just Turned Agents Into a Platform On October 1, 2026, Anthropic shipped Claude Code v2.1.287 with a feature called Mods — JavaScript and TypeScript functions that hook into the agent's execution pipeline, intercept tool calls, render custom UI, and reshape how the agent behaves from the inside out. Boris Cherny, the head of Claude Code, announced it on X to 833,000 views and 5,200 likes. Within hours, someone had Tetris running inside their terminal. Read the full version with charts and embedded sources on AgentConn → View original post on X → The same week, @AGTPinsights pu

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Flash Loan Attack Vector Analysis: Gauntlet

Flash Loan Attack Vector Analysis: Gauntlet Target Protocol: Gauntlet (TVL: $1628.6M) Flash‑Loan Attack Vector Analysis – Gauntlet Protocol: Gauntlet (TVL ≈ $1.63 B across Ethereum & L2s) Date: 4 Oct 2026 Prepared by: Senior DeFi Security Researcher – Smart‑Contract Audit Team Gauntlet is a strategic‑simulation and risk‑management platform that supplies on‑chain data, capital‑allocation recommendations, and automated execution for large‑scale DeFi investors. Its core value proposition is the ability to run “what‑if” simulations using real‑time market data and then execute multi‑step, multi‑pro

0 comments Read more at DEV Community

ProgrammingDEV Community ·

I built my husband a vim trainer with a Gemma coach that runs in the browser

This is a submission for the Hacktoberfest Weekend Challenge: Build for a Friend A lot of my friends build their own tools. They hit a problem and just make the thing they want. I wanted to build something for someone else this time, and the answer was sitting right next to me. My husband has wanted to learn vim for a long time. He's tried a bunch of times, and it always ends the same way: he gives up.

0 comments Read more at DEV Community