| 5 Dec 2025 |
 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 |
|  adam changed their profile picture. | 16:26:10 |
| raitobezarius | yeah this was the joke here | 16:38:28 |
 just1602 | But did some of the fork of sqlite like libsql or turso could fix the issue we face with sqlite? | 16:40:42 |
| adam changed their profile picture. | 16:43:41 |
|  👉@crystallinefire:chat.solarpunk.moe changed their display name from EVA-01 to 👉@crystallinefire:chat.solarpunk.moe. | 17:17:17 |
| aloisw | I would rather trust SQLite than a VC-backed fork plastering "AI" over their website to stay around. | 17:52:46 |
| aloisw | And I think it's helpful to figure out what our actual issues with SQLite are. "The WAL grows too large" is a <10 line fix, but of course I don't know yet if this is the only problem. | 17:54:24 |
| aloisw | Update: RESTART checkpoints with 40000 pages tank the speed even more, since checkpoints happen very often due to nix-eval-jobs growing the WAL so fast. | 18:36:17 |
| raitobezarius | hah | 18:47:21 |
| aloisw | Yeah the WAL just grows so much faster than the database, even with large WAL sizes checkpointing takes quite long. | 19:01:35 |
| aloisw | Page size of 512, WAL size of 1 GiB (lower should also work, only increasing the fsync cost) and RESTART checkpointing looks quite nice with the synthetic test case. There are still stalls, but they are like 7 seconds after 2 minutes. | 19:30:36 |
| 6 Dec 2025 |
 Jassuko | Hmmm. The database itself should not be very big, right? What is the consistency requirement for it? I.e. do we really need to care if the system crashes mid-build somewhere as long as the final state or such gets committed properly? | 10:50:42 |
| Jassuko | So, do we a actually need WAL, or would it better to just use the restore based journaling? Or if the intermediate steps are not that important to keep as we can just run the builds again after a crash, we could just copy the whole database on tempfs and run the restore checkpointed mode on there where latency on additional file operations would be minimal. And after some things or the whole operation is done, only then copy the relevant state to the db store on disk? | 10:53:56 |
 K900 | SQLite can only do multiple concurrent readers in WAL mode | 11:28:30 |
 522 it/its ⛯ΘΔ | wait, really? i thought WAL provided one writer and multiple readers, as opposed to one writer or multiple readers | 11:41:46 |
