Library - NextGenBeing
Library

Curated intelligence for builders, operators, and creators.

Filter by category, explore premium drops, or search the archive to get exactly the blueprint you need.

SQLite WAL Mode Benchmark in Python: DELETE vs WAL Numbers
Web Development 10 min read

SQLite WAL Mode Benchmark in Python: DELETE vs WAL Numbers

In my Python benchmark, SQLite WAL with synchronous=FULL ran 10,000 single-row inserts about 4.1x faster than DELETE mode and had 0 BUSY errors against 62 writer and 117 reader.

Bekzod Erkinov

Bekzod Erkinov

Oct 20, 2026

46 0 0
sqlite Python +3
Postgres JSONB vs Separate Tables: Real Benchmarks
Web Development 15 min read

Postgres JSONB vs Separate Tables: Real Benchmarks

Change one integer inside an 8 KB JSONB document and PostgreSQL 17 writes about 16,300 bytes of WAL. Change the same integer when it lives in its own column and it writes 294 bytes. That 55x gap…

Bekzod Erkinov

Bekzod Erkinov

Oct 1, 2026

133 0 0
PostgreSQL jsonb +3