Building Resilient Offline-First Mobile Apps: CRDTs, SQLite, and Cloud Sync in 2026
Introduction & Industry Context In 2026, the concept of an 'online-first' mobile application is largely obsolete. Users no longer tolerate disru…
Architecture
⚑ Сообщить о проблемеПоследние новости Architecture от Tech News
Все темы
agents
ai
api
architecture
automation
aws
backend
beginners
career
database
devchallenge
devops
javascript
llm
machinelearning
mcp
news
opensource
performance
productivity
programming
python
react
security
showdev
softwareengineering
systemdesign
tutorial
typescript
webdev
One stack per ticket: why our coding agent works on a DB copy
Every ticket on our board gets its own stack: a branch in every repo, its own services, its own copy of the dev database and its own preview URL. We…
Constraints in plain English: Primary, Unique & Foreign keys via Field.
You shouldn't need a PhD in SQLAlchemy internals just to define a composite unique constraint or an autoincrementing ID. wsqlite turns Pydantic fiel…
Как я собрал бота‑команду из 11 ИИ‑юристов и что под капотом пошло не так первым же смоук‑тестом
Полтора месяца назад мне пришла претензия на 44 тысячи рублей за фото восьмилетней давности на сайте нашего отеля — типичный «фотобанковский» иск с…
Why We Built an Offline-First Architecture for Temporary Emails on Android
Why We Built an Offline-First Architecture for Temporary Emails on Android Handling temporary inboxes on mobile is deceptively complex. Most web-bas…
What's actually inside Apple Mail's Envelope Index
Apple Mail keeps a full SQLite database of your mailbox metadata. It sits at ~/Library/Mail/V10/MailData/Envelope Index (the V number tracks the Mai…
Локальный компаньон для Genshin, HSR и ZZZ: как я упаковал три игры в офлайн‑приложение без бэкенда
Забыли забрать ежедневные гемы или потеряли счёт круткам до гаранта? Рассказываю, как я решил собственную проблему и разработал Gacha…
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…
Книга: «Основы Go»
Привет, Хаброжители! Язык Go востребован в разработке облачных сервисов и распределенных систем благодаря простоте, высокой производительности и вст…
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…
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…
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…
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…
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive
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…
Я не хотел писать ORM для Kotlin/Native. Мне просто нужен был PostgreSQL
Всё началось с архитектурного тупика. Я занимался бэкенд-частью low-code платформы, на базе которой автоматизировались внутренние процессы крупных к…
DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals
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…
Why AI Agents Make Me Reach for SQLite
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
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective Today's Highlights This week's database highlights include a deep dive into…
Expanding the Sovereign AI Stack: Moving the Specification from Gateway to Local Silicon
When I first introduced the Sovereign Systems Specification and released the initial foundation of the SDK, sovereign-core and its accompanying sove…
SQLite Backup Strategy for Production SaaS: WAL, Litestream, Recovery Tests
Running SQLite in production for a multi-tenant SaaS means giving up the operational comfort of a managed database. No automatic backups, no point-i…
PostgreSQL HA Risks, Replication Internals, & Rapid Branching
PostgreSQL HA Risks, Replication Internals, & Rapid Branching Today's Highlights Today's highlights include critical insights into Patroni's rep…
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data Today's Highlights Today's highlights include DuckDB's innovative data inlin…
Why SQLite FTS5's default tokenizer drops your Japanese substrings (and the one-line fix)
If you're building any kind of personal-memory layer on top of SQLite — Claude Code conversation history, notes app, indexed knowledge base — there'…
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem Today's Highlights This week's highlights include DuckDB's new D…
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning Today's Highlights This week's database news highlights significant adv…
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s Today's Highlights This week, DuckDB introduces integrated vector and hyb…
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture Today's Highlights This week, we explore SQLite's query planner…
Building an Event Sourced Video Moderation Audit Log with PHP and SQLite
The 3am call from a Japanese rightsholder Last quarter a Japanese label sent a takedown notice for fourteen music videos we'd been aggregating acros…
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns Today's Highlights PostgreSQL 19 introduces major features with SQL/PGQ for g…