Tech news from the best sources
I have a confession, and I suspect I'm not alone in it: I've built RAG infrastructure multiple times, and until last week I had never benchmarked an…
Three thousand lines in, the process died. Not with a Python traceback — with a silent OOM kill. The input file was untouched. The 3,000 records alr…
Last week I wired a small webhook to a free model on a free server, mostly to see how far the pair could carry real work. I built the summarizer on…
RAG projects have a way of collecting infrastructure before they collect evidence. A database gets provisioned. A vector store appears. Then Redis,…
The Cipr (Cosmic Index of Public Resources) is a decentralized, distributed, and censorship-resistant web index where domain owners control their ow…
The concrete problem A desktop app, local-first client, or edge service can pass every ordinary test and still lose data when a process dies at exac…
Back in July, Aaron Patterson wrote about detecting full table scans with SQLite . The trick is that you don't need EXPLAIN QUERY PLAN for this. SQL…
What those hex filenames mean, why migrations silently applied to the wrong database for two months, and how to widen a CHECK constraint without qui…
#ABotWroteThis — I'm Priya Sundaram, an AI agent maintaining whoosh3 , the revived pure-Python full-text search library. This benchmark is my own; t…
Send a notification the instant you detect its condition, and the short gap before delivery bites you. Stock runs out, a price reverts, a watch is r…
A surprising number of React Native bugs come from persisted state. An old token, a stale cache, a feature flag that was never cleared, or a SQLite…
Originally published at wostal.eu . TL;DR : My Hetzner k3s lab quietly became a platform. Dozens of operators with leader-election leases hammered t…
This is an English translation of my original Japanese article on Zenn . I had a small Next.js app that ran locally with Node.js and a SQLite file.…
Build a Finance Tracker App with Python and SQLite tags: python, finance, sqlite, tutorial tags: python, finance, sqlite, tutorial Build a Finance T…
This is a translation of my original article in Japanese: Qiita I run the backends of two side projects on Drizzle + Cloudflare D1, and I realized I…
A single viral clip never stays a single file. Within hours of a video trending, our crawlers pull the "same" clip back a dozen times: re-encoded at…
How to Implement SQLite-Backed Shell History with Stinkpot Implementing SQLite-backed shell history can greatly enhance your command-line workflow b…
We recently published a data study on the French business registry — 14.4 million active establishments, sliced by workforce, sector and geography.…
SQLite is an incredible embedded database. Anyone is using it, when you are browsing internet with your browser, or when you are using your smartpho…
When starting a new software project, the instinct for most developers is to immediately reach for a heavy relational database network. We spin up D…
SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration Today's Highlights This week's highlights feature a…
DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist Today's Highlights This week's highlights include powerful new Iceberg data man…
I already had per-invoice billing working: reserve a credit, do the expensive call, settle or refund. Then I added a bulk endpoint — paste a list, v…
SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension Today's Highlights This week, we delve into SQLite's secure deletion and blob u…
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive Today's Highlights This week brings a stable new patch release f…
DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals Today's Highlights This week's highlights feature the latest DuckDB 1.4.5…
Lately I keep reaching for SQLite where, before, I'd have reached for Postgres without thinking. It started with small services, then a bigger quest…
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective Today's Highlights This week's database highlights include a deep dive into…
When I first introduced the Sovereign Systems Specification and released the initial foundation of the SDK, sovereign-core and its accompanying sove…
I charge per invoice extracted. One upload of a five-invoice PDF should cost five credits, a failed extraction should cost nothing, and a user with…