Simon Willison’s Weblog

Subscribe

Quotations tagged benjohnson, sqlite in 2023

Filters: Type: quotation × Year: 2023 × benjohnson × sqlite × Sorted by date


[On SQLite for production concurrent writes] In general, WAL mode “just works” as Simon said. You just need to make sure you don’t have long running write transactions, although those are somewhat problematic in any database system. Don’t do stuff like starting a write txn and then calling a remote API and then committing. That’ll kill your write throughout.

Ben Johnson # 26th January 2023, 7:36 pm

Types

Years

Months

Tags