| 4 Dec 2025 |
 raitobezarius | whereas for writes, it seems it'd be good if we could have multiple WAL so that once one is committed, the other can be still filled? | 22:45:42 |
| raitobezarius | maybe we can improve things by initiating checkpoints ourselves at key points… | 22:46:15 |
| raitobezarius | it would be interesting to know if we cause checkpoint starvation | 22:47:19 |
| 5 Dec 2025 |
 aloisw | In reply to @raitobezarius:matrix.org
have you tried a lower value? I have not, but I think the problem is not so much that the size is excessive, but that the checkpointer is never alone so the WAL grows without bound. | 06:26:19 |
| aloisw | In reply to @raitobezarius:matrix.org
but i feel like the fact that lix is blocked by the potential event that the WAL contains a record relevant to it is a mistake given our usage of flock to mark the future happening of a store path Thanks for the hint, I will investigate whether this has any influence on the situation. | 06:27:54 |
| aloisw | In reply to @raitobezarius:matrix.org
maybe we can improve things by initiating checkpoints ourselves at key points… SQLite does that because of autocheckpoint, but the problem is that these are non-blocking (PASSIVE) checkpoints. I will investigate tomorrow whether RESTART makes the situation better; it should prevent unbounded WAL growth at the expense of some concurrency, but maybe it's still a net win if the write transactions aren't slowed down so much. | 06:30:51 |
| aloisw | In reply to @raitobezarius:matrix.org
whereas for writes, it seems it'd be good if we could have multiple WAL so that once one is committed, the other can be still filled? wal2 when | 06:31:04 |
 Jassuko | What exactly are you using the DB for in this case? | 09:15:48 |
| raitobezarius | In reply to @jassu:kumma.juttu.asia
What exactly are you using the DB for in this case? It's the metadata layer of the Nix store, the actual source of truth | 13:29:25 |
 helle (just a stray cat girl) | we should just store it in xattrs (I am extremely joking) | 13:30:08 |
| raitobezarius | In reply to @aloisw:julia0815.de
wal2 when Are you Christian? We need christians to contribute to SQLite | 13:30:40 |
| raitobezarius | In reply to @helle:tacobelllabs.net
we should just store it in xattrs (I am extremely joking) We did try it alas in a non joking fashion, won't work reliably | 13:31:02 |
| helle (just a stray cat girl) | yeah, we know, this is why we jokingly brought it back up | 13:31:31 |
 thubrecht | Or just write a custom fs to use for the nix store | 13:32:50 |
| helle (just a stray cat girl) | .... it had crossed my mind before at least..... | 13:34:17 |
| helle (just a stray cat girl) | oh, who is responsible for lixcon pretix setup, the account name that pretix includes for bank orders apparently does not match the actual account name (and it is always funny that there are banks in Europe that check this) the claimed account name by pretix is "DELEGATION GENERALE NUMERIQUE" but the actual account name is "DELEGATION GENERALE NUMERIQUE - DGNUM" and some banks will trip on this | 13:44:37 |
| raitobezarius | i am | 13:49:13 |
| raitobezarius | i will fix that | 13:49:22 |
| raitobezarius | once the accelerated FUSE stuff is out | 13:49:35 |
| raitobezarius | fixed | 13:52:13 |
 rosssmyth | accelerated FUSE? Like FUSE pass-through? | 15:36:02 |
| raitobezarius | ye | 15:36:06 |
| raitobezarius | the recent FUSE passthrough that Darrick Wong sent | 15:36:14 |
| aloisw | In reply to @raitobezarius:matrix.org
Are you Christian? We need christians to contribute to SQLite Sorry, I fear I don't understand. Wal2 already exists in a separate branch but the author's user name is "dan", not something that would refer to Christian. Also SQLite does not accept external contributions at all I think? | 15:47:37 |
 hexa | https://sqlite.org/codeofethics.html | 15:50:16 |
| hexa | * I think this refers to various rules here https://sqlite.org/codeofethics.html | 15:50:34 |
| hexa |
Prefer nothing more than the love of Christ.
| 15:50:41 |
| raitobezarius | i didn't know wal2 existed, funny | 15:51:16 |
| aloisw | In reply to @hexa:lossy.network
I think this refers to various rules here https://sqlite.org/codeofethics.html what | 16:00:24 |
| aloisw | So I guess it's referring to the religion and not the name? While I am in fact Christian in that sense, I do get weird vibes from that document (particularly their introduction), and in any case they do not accept external contributions to begin with. | 16:02:16 |
