Skip to content

Commit cd8a1ef

Browse files
refactor(server): DatabaseStorage layer uses a make constructor
Co-Authored-By: Claude Opus 5.5 <[email protected]>
1 parent f532219 commit cd8a1ef

1 file changed

Lines changed: 42 additions & 43 deletions

File tree

‎apps/server/src/persistence/DatabaseStorage.ts‎

Lines changed: 42 additions & 43 deletions
Original file line numberDiff line numberDiff line change
@@ -24,50 +24,49 @@ export class DatabaseStorage extends Context.Service<
2424
* retained event with a higher sequence, so a client replaying from an older
2525
* cursor still reaches the same state; no replay boundary is published.
2626
*/
27-
export const layer = Layer.effect(
28-
DatabaseStorage,
29-
Effect.gen(function* () {
30-
const sql = yield* SqlClient.SqlClient;
31-
const maintenance = yield* ProjectionMaintenance.ProjectionMaintenanceV2;
27+
const make = Effect.gen(function* () {
28+
const sql = yield* SqlClient.SqlClient;
29+
const maintenance = yield* ProjectionMaintenance.ProjectionMaintenanceV2;
30+
31+
const reclaim = Effect.gen(function* () {
32+
const mode = yield* sql<{ readonly auto_vacuum: number }>`PRAGMA auto_vacuum`;
33+
if (mode[0]?.auto_vacuum !== 2) return;
34+
// The driver steps a statement without result columns once, and each
35+
// step of incremental_vacuum frees one page. Yield between pages so
36+
// client requests can run.
37+
for (let page = 0; page < RECLAIM_PAGES_PER_PASS; page++) {
38+
const free = yield* sql<{ readonly freelist_count: number }>`PRAGMA freelist_count`;
39+
if ((free[0]?.freelist_count ?? 0) === 0) break;
40+
yield* sql`PRAGMA incremental_vacuum(1)`;
41+
yield* Effect.yieldNow;
42+
}
43+
}).pipe(
44+
Effect.catch((cause) => Effect.logWarning("Database space reclamation failed", { cause })),
45+
);
3246

33-
const reclaim = Effect.gen(function* () {
34-
const mode = yield* sql<{ readonly auto_vacuum: number }>`PRAGMA auto_vacuum`;
35-
if (mode[0]?.auto_vacuum !== 2) return;
36-
// The driver steps a statement without result columns once, and each
37-
// step of incremental_vacuum frees one page. Yield between pages so
38-
// client requests can run.
39-
for (let page = 0; page < RECLAIM_PAGES_PER_PASS; page++) {
40-
const free = yield* sql<{ readonly freelist_count: number }>`PRAGMA freelist_count`;
41-
if ((free[0]?.freelist_count ?? 0) === 0) break;
42-
yield* sql`PRAGMA incremental_vacuum(1)`;
43-
yield* Effect.yieldNow;
44-
}
45-
}).pipe(
46-
Effect.catch((cause) => Effect.logWarning("Database space reclamation failed", { cause })),
47-
);
47+
const compact = maintenance.compactEventStore.pipe(
48+
Effect.tap((result) =>
49+
result.deletedEventCount > 0 || result.deletedReceiptCount > 0
50+
? Effect.logInfo("Compacted orchestration history", result)
51+
: Effect.void,
52+
),
53+
Effect.catch((cause) =>
54+
Effect.logWarning("Orchestration history compaction failed", { cause }),
55+
),
56+
);
4857

49-
const compact = maintenance.compactEventStore.pipe(
50-
Effect.tap((result) =>
51-
result.deletedEventCount > 0 || result.deletedReceiptCount > 0
52-
? Effect.logInfo("Compacted orchestration history", result)
53-
: Effect.void,
54-
),
55-
Effect.catch((cause) =>
56-
Effect.logWarning("Orchestration history compaction failed", { cause }),
57-
),
58-
);
58+
yield* forkParked(
59+
Effect.sleep("1 minute").pipe(
60+
Effect.andThen(compact.pipe(Effect.repeat(Schedule.spaced("6 hours")))),
61+
),
62+
);
63+
yield* forkParked(
64+
Effect.sleep("1 minute").pipe(
65+
Effect.andThen(reclaim.pipe(Effect.repeat(Schedule.spaced("1 minute")))),
66+
),
67+
);
5968

60-
yield* forkParked(
61-
Effect.sleep("1 minute").pipe(
62-
Effect.andThen(compact.pipe(Effect.repeat(Schedule.spaced("6 hours")))),
63-
),
64-
);
65-
yield* forkParked(
66-
Effect.sleep("1 minute").pipe(
67-
Effect.andThen(reclaim.pipe(Effect.repeat(Schedule.spaced("1 minute")))),
68-
),
69-
);
69+
return DatabaseStorage.of({ reclaim });
70+
});
7071

71-
return DatabaseStorage.of({ reclaim });
72-
}),
73-
);
72+
export const layer = Layer.effect(DatabaseStorage, make);

0 commit comments

Comments
 (0)