Saviez-vous que la pagination par offset est très complexe mais facile à éviter ?

La clause offset demande à la base de données d'ignorer les N premiers résultats d'une requête. Cependant, la base de données doit toujours récupérer ces lignes du disque avant de pouvoir renvoyer les lignes suivantes.

Ce n'est pas un problème provenant de l'implémentation, c'est à la base du concept même d'offset :

… les lignes sont tout d'abord triées suivant la <clause order by>, puis sont filtrées en supprimant le nombre de lignes indiqué dans la <clause offset> à partir du début…

SQL:2023, Part 2, §4.17.3 Derived tables

Autrement dit, les gros décalages imposent un long travail à la base de données, qu'elle soit SQL ou NoSQL.

Expensively Quadratic: the LLM Agent Cost Curve
2026-02-03 Philip Zeyliger

Pop quiz: at what point in the context length of a coding agent are cached reads costing you half of the next API call? By 50,000 tokens, your conversation’s costs are probably being dominated by cache reads.

Let’s take a step back. We’ve previously written about how coding agents work: they post the conversation thus far to the LLM, and continue doing that in a loop as long as the LLM is requesting tool calls. When there are no more tools to run, the loop waits for user input, and the whole cycle starts over.

c'est de passer par Docker. Greenbone fournit une stack complète avec dock

vulnerability scanner

Sortie de SxTLSCheck (ScalarX TLS Checker)

testeur de endpoint ssl

Cache Directory Tagging Specification

Unify AI
Power
LibreChat is the ultimate open-source app for all your AI conversations, fully customizable and compatible with any AI provider — all in one sleek interface

chatgpt UI opensource

no hey|
please don't say just hello in chat
Imagine calling someone on the phone, going hello! then putting them on hold... 🤦‍♀️

Shannon is an AI pentester that delivers actual exploits, not just alerts.

Shannon's goal is to break your web app before someone else does. It autonomously hunts for attack vectors in your code, then uses its built-in browser to execute real exploits, such as injection attacks, and auth bypass, to prove the vulnerability is actually exploitable.

via https://korben.info/shannon-pentester-ia-autonome.html

🧠 ReMemory

This is a tool that encrypts files and splits the decryption key among trusted friends using Shamir's Secret Sharing. For example, you can give pieces to 5 friends and require any 3 of them to cooperate to recover the key. No single friend can access your data alone. The threshold is up to you—from 3-of-5 for a group of friends to 2-of-2 for couples with shared private content that neither partner can access alone.

Each friend receives a self-contained bundle with recover.html—a browser-based tool that works offline, with no servers or internet required. If this website disappears, recovery still works.

Use One Big Server

A lot of ink is spent on the "monoliths vs. microservices" debate, but the real issue behind this debate is about whether distributed system architecture is worth the developer time and cost overheads. By thinking about the real operational considerations of our systems, we can get some insight into whether we actually need distributed systems for most things.

search engine for gaming sales

sqldef

sqldef is a CLI tool for diffing two SQL schemas. You can use it to manage the migration of RDBMSs using regular SQL DDLs.

Supported databases: MySQL, MariaDB, TiDB, PostgreSQL, SQL Server, and SQLite3.
Online Demo

Open WebUI

Open WebUI is an extensible, feature-rich, and user-friendly self-hosted AI platform designed to operate entirely offline. It is built around universal standards, supporting Ollama and OpenAI-compatible Protocols

mactop is a terminal-based monitoring tool "top" designed to display real-time metrics for Apple Silicon chips written by Carsen Klock. It provides a simple and efficient way to monitor CPU and GPU usage, E-Cores and P-Cores, power consumption, GPU frequency, temperatures, and other system metrics directly from your terminal

Running multiple Claude Code sessions in parallel, each in its own fully isolated environment

Worktrunk
Git worktree management for parallel AI agent workflows

Vibe is a quick, zero-configuration way to spin up a Linux virtual machine on Mac to sandbox LLM agents:

via https://korben.info/vibe-coding-terminal-llm.html

Free secure self-hosted HTTPS tunnel in under 10 minutes.

via https://korben.info/webhooks-proxy-tunnel-local-ngrok.html

Write terminal GIFs as code for integration testing and demoing your CLI tools.

via
https://korben.info/vhs-creer-gif-terminal.html

terminal cli recorder and playback

Terminalizer
Record your terminal and generate animated gif images or share a web player

a terminal based recorder and playback