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}")

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.