Configuration¶

Reference documentation for Pollux server configuration.

Environment variables¶

Two settings are read from the environment, primarily so tests never touch the production database or port 3000.

# Run on a different port with an isolated database
PORT=8080 POLLUX_DB=/var/lib/pollux/db.sqlite bun src/index.ts

The server binding is defined in src/index.ts:

Bun.serve({
  port: Number(process.env.PORT ?? 3000),
  // ...
});

Database cleanup¶

Everything Pollux stores is transient. A cron job in src/index.ts fires every minute (0 * * * * *) and purges old and orphaned rows:

new Cron("0 * * * * *", () => {
  clean.run();               // votes older than 4h
  cleanQuizzAnswers.run();   // quizz questions older than 4h
  cleanQuizzSubmissions.run(); // submissions with no question
  cleanQuizzPlayers.run();     // players with no question
});

The retention window (4 hours) lives in the SQL in src/db.ts:

export const clean = db.query(
  "DELETE FROM poll WHERE date < datetime('now','-4 hours');",
);

Edit the interval to change retention, or remove the new Cron(...) block to disable auto-cleanup.

CORS¶

CORS headers are defined in src/routes/helpers.ts:

export const corsHeaders = {
  "Access-Control-Allow-Origin": "*",
  "Access-Control-Allow-Methods": "GET, POST, OPTIONS",
  "Access-Control-Allow-Headers": "Content-Type",
};

Database¶

• Engine: SQLite via bun:sqlite
• File location: data/db.sqlite (relative to the working directory)
• Journal mode: WAL (Write-Ahead Logging)

Tables¶

poll¶

quizz_answers¶

quizz_submissions¶

quizz_players¶