The negative value in the cache size pragma seems a mistake, but it isn’t. Negat... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		lrossi on Feb 11, 2021 \| parent \| context \| favorite \| on: Why I Built Litestream The negative value in the cache size pragma seems a mistake, but it isn’t. Negative values are used to specify a cache size that is a multiple of the page size (more or less) and the sign is discarded. Not a great choice of API IMHO, but it’s a database, I’ve seen much worse. https://www.sqlite.org/pragma.html#pragma_cache_size

polyrand on Feb 12, 2021 [–]

I agree it's a very weird API, but you get used to it. In python, when initializing the DB I always use:

  conn.execute(f"PRAGMA cache_size = {-1 * 64_000}")

That way I never forget about the minus.

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact