pull_requests: 1102353255

This data as json

id node_id number state locked title user body created_at updated_at closed_at merged_at merge_commit_sha assignee milestone draft head base author_association repo url merged_by auto_merge
1102353255 PR_kwDOBm6k_c5BtJNn 1870 open 0 don't use immutable=1, only mode=ro 536941 Opening db files in immutable mode sometimes leads to the file being mutated, which causes duplication in the docker image layers: see #1836, #1480 That this happens in "immutable" mode is surprising, because the sqlite docs say that setting this should open the database as read only. https://www.sqlite.org/c3ref/open.html > immutable: The immutable parameter is a boolean query parameter that indicates that the database file is stored on read-only media. When immutable is set, SQLite assumes that the database file cannot be changed, even by a process with higher privilege, and so the database is opened read-only and all locking and change detection is disabled. Caution: Setting the immutable property on a database file that does in fact change can result in incorrect query results and/or [SQLITE_CORRUPT](https://www.sqlite.org/rescode.html#corrupt) errors. See also: [SQLITE_IOCAP_IMMUTABLE](https://www.sqlite.org/c3ref/c_iocap_atomic.html). Perhaps this is a bug in sqlite? <!-- readthedocs-preview datasette start --> ---- :books: Documentation preview :books:: https://datasette--1870.org.readthedocs.build/en/1870/ <!-- readthedocs-preview datasette end --> 2022-10-27T23:33:04Z 2023-10-03T19:12:37Z     fc2d316f9e22593d48036e9d81fe972bb5973016     0 4faa4fd3b3e7f5eae758b713d0a121b960e2e261 bf00b0b59b6692bdec597ac9db4e0b497c5a47b4 CONTRIBUTOR 107914493 https://github.com/simonw/datasette/pull/1870    

Links from other tables