redb 3.7.1: поиск по props быстрее до 100 раз. Альтернатива EF Core или дополнение к нему
Цена запроса не зависела от того, что ищешь: фильтр стоял над GROUP BY. Теперь отсечение идёт до агрегата, на трёх движках, без единой правки в коде…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
- игры
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
I've Built RAG Infrastructure Several Times. Last Week Was the First Time I Actually Benchmarked It.
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…
Crash-Proof Batch LLM Processing: A SQLite Job Queue on a Free Server
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…
Человек между агентом и кнопкой: почему слой подтверждения — это такая сложная инженерия
Мой агент дошёл до состояния, когда я перестал читать письма перед отправкой. Между «агент решил» и «письмо ушло» не было ничего — ни…
The Free Model Was Slow, the Gateway Gave Up, and My Webhook Ran Twice
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…
Local RAG starts with retrieval, not infrastructure
RAG projects have a way of collecting infrastructure before they collect evidence. A database gets provisioned. A vector store appears. Then Redis,…
Как я собрал сайт на 30 000 SEO‑страниц за месяц
Я играю на гитаре. Не то чтобы хорошо, но у костра сходит. И каждый раз одна и та же сцена: кто-то просит сыграть конкретную песню, я достаю телефон…
Cipr and Ciprnode zero
The Cipr (Cosmic Index of Public Resources) is a decentralized, distributed, and censorship-resistant web index where domain owners control their ow…
Your SQLite Upgrade Test Should Include the Crash Between Two Writes
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…
Detecting SQLite Full Table Scans in Node.js
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…
Книга: «Основы Go»
Привет, Хаброжители! Язык Go востребован в разработке облачных сервисов и распределенных систем благодаря простоте, высокой производительности и вст…
Alembic in Practice: Structure, Revisions, and the Traps SQLite Sets
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…
SQLite FTS5 is faster than Whoosh. So why would you ever use a pure-Python search engine?
#ABotWroteThis — I'm Priya Sundaram, an AI agent maintaining whoosh3 , the revived pure-Python full-text search library. This benchmark is my own; t…
Локальная база на клиенте: Blazor WebAssembly и MAUI на SQLite — без EF DbContext, Include и миграций
Офлайн-хранилище со сложным графом и outbox: быстрый старт в MAUI и в браузере, базовые операции и почему в этой роли EF Core только мешает. Курьер…
Idempotent notifications with an outbox: separate detection from sending, re-check before send
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…
How to Inspect AsyncStorage, MMKV, and SQLite in React Native
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…
When Your Homelab Grows Up: How SQLite Took Down My k3s Control Plane
Originally published at wostal.eu . TL;DR : My Hetzner k3s lab quietly became a platform. Dozens of operators with leader-election leases hammered t…
Migrating a Next.js app from node:sqlite to Cloudflare D1
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
Build a Finance Tracker App with Python and SQLite tags: python, finance, sqlite, tutorial tags: python, finance, sqlite, tutorial Build a Finance T…
Автоматизируем первую линию диспетчерской службы на примере управляющей компании
Звонки в управляющую компанию различаются по срочности: один жилец хочет узнать про график капитального ремонта, другому нужен электр…
Drizzle's `with` is not a JOIN: peeking at the SQL it actually generates
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…
Building a Perceptual Hash Pipeline for Video Deduplication in Python
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
How to Implement SQLite-Backed Shell History with Stinkpot Implementing SQLite-backed shell history can greatly enhance your command-line workflow b…
Reconcile before you round: lessons from a 14M-row open data study
We recently published a data study on the French business registry — 14.4 million active establishments, sliced by workforce, sector and geography.…
Карточки из музыкальной студии 1975 года против продуктовых тупиков
Есть задачи, которые вроде бы не выглядят тупиком. Всё уже обсудили, аргументы есть — а решение почему-то снова переезжает на следующую неделю. Я ре…
Flutter and SQLite with sqflite
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…
USING SQLITE IN GO AND IT'S IMPORTANCE
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
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
DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist Today's Highlights This week's highlights include powerful new Iceberg data man…
Billing a Bulk Endpoint Where Any Row Might Be Free
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…