23 Sep 2022 |
hexa | * "regularly" is sufficiently vague | 16:47:43 |
Sandro 🐧 | When I was still on unstable-small I was building a browser at least twice a week | 22:21:14 |
Winter (she/her) | How often did you update it though Sandro 🐧, plus -small is very specifically made for not having large rebuilds like browsers | 23:27:44 |
24 Sep 2022 |
hexa | dependencies might change, but small will simply not build browsers | 02:04:32 |
hexa | https://hydra.nixos.org/jobset/nixos/staging-small#tabs-jobs | 02:05:03 |
hexa | mostly headless stuff | 02:05:11 |
hexa | TIL https://areweoidcyet.com/#what | 22:23:07 |
hexa | matrix is moving to OIDC for auth | 22:23:26 |
Sandro 🐧 | In reply to @winterqt:nixos.dev How often did you update it though Sandro 🐧, plus -small is very specifically made for not having large rebuilds like browsers every to every other day | 23:50:50 |
25 Sep 2022 |
@linus:schreibt.jetzt | In reply to @hexa:lossy.network matrix is moving to OIDC for auth Nice! | 09:58:41 |
26 Sep 2022 |
hexa | https://github.com/matrix-org/matrix-appservice-irc/commit/ed0d64767db7fc7720d316326673e7c99f7947cf | 11:26:31 |
hexa | the gift that keeps on giving | 11:27:40 |
hexa | https://github.com/matrix-org/matrix-appservice-irc/releases/tag/0.35.1 | 11:28:06 |
hexa | now also released just 30s ago | 11:28:13 |
hexa | --- a/src/datastore/postgres/PgDataStore.ts
+++ b/src/datastore/postgres/PgDataStore.ts
@@ -661,8 +661,9 @@ export class PgDataStore implements DataStore {
public async getRoomsVisibility(roomIds: string[]) {
const map: {[roomId: string]: "public"|"private"} = {};
- const list = `('${roomIds.join("','")}')`;
- const res = await this.pgPool.query(`SELECT room_id, visibility FROM room_visibility WHERE room_id IN ${list}`);
+ const res = await this.pgPool.query("SELECT room_id, visibility FROM room_visibility WHERE room_id IN $1", [
+ roomIds,
+ ]);
for (const row of res.rows) {
map[row.room_id] = row.visibility ? "public" : "private";
}
| 11:28:53 |
@piegames:matrix.org | Good thing that I still haven't updated my bridge from last time, so now I only need to update once 🙈 | 11:28:57 |
hexa | only with postgres, prevents injection apparently | 11:29:01 |
hexa | aren't you on heisenbridge anyhow? | 11:29:14 |
@piegames:matrix.org | I have both, for legacy reasons | 11:29:38 |
hexa | Winter (she/her): and of course they removed the crypto-sdk in this release again 😄 | 11:51:32 |
hexa | they don't mention it, but it's gone | 11:52:18 |