What are you looking for?

Prefer strict tables in SQLite

AI·SQLite strict tables enforce column types to prevent datatype errors like inserting text into integer columns, allowing only standard types or ANY for flexibility, but cannot be added to existing tables and require SQLite 3.37+.

We scaled PgBouncer to 4x throughput

AI·ClickHouse scaled PgBouncer throughput 4x by running a fleet of processes sized to cores, using so_reuseport to balance connections on one port and inter-process peering for query cancellation.

Show HN: Learn by rebuilding Redis, Git, a database from scratch

AI·Site offers 80+ structured courses for building real systems including Redis, Git, databases, compilers, and kernels from scratch in Python, Go, Rust, and others.

SQuaD-SQL: Efficient Text-to-SQL with Small Language Models via LLM-Guided Knowledge Distillation

AI·SQuaD-SQL uses LLM-guided synthetic data and LoRA fine-tuning to train 1.5B-parameter SLMs to reach 86.9% execution accuracy on WikiSQL, matching large models while requiring only one consumer GPU and delivering faster, lower-memory inference.

Follow-up: what I learned scaling a SQLite/FTS5 patent database from 3.5M to 5.36M records

AI·Follow-up post details data-engineering optimizations that scaled a SQLite/FTS5 patent database from 3.5M to 5.36M records while classifying them with Nemotron 9B on an RTX 5090.