| 6 Dec 2025 |
 aloisw | Ah lovely, when you try to do PRAGMA journal_mode = TRUNCATE on a WAL database concurrently it may just deadlock. | 15:23:16 |
| aloisw | Of course, as they open a connection with WAL first, but you obviously can't have a WAL connection while trying to convert the database to truncate mode. In particular once you're in the deadlock state, no amount of retry within the connection (as Lix does) will try to help you. | 15:27:51 |
 raitobezarius | In reply to @hexa:lossy.network
oh, you mean a non-default store then Technically /Nix can be tmpfs | 15:56:42 |
 ShalokShalom | In reply to @aloisw:julia0815.de
Yes, that's exactly why it is so slow and we're having this conversation. Isn't there somebody rewriting SQLite in Rust? | 16:30:32 |
| ShalokShalom | Could that make a difference | 16:30:42 |
 K900 | Rust is not magic | 16:31:40 |
| K900 | And I'm not aware of a Rust API compatible SQLite replacement | 16:31:56 |
