Method startWALCheckpointer

internal/store/store.go:192–210

startWALCheckpointer runs PRAGMA wal_checkpoint(TRUNCATE) on a timer so the WAL file can't grow without bound. SQLite's automatic wal_autocheckpoint is PASSIVE: it can only checkpoint frames no reader still needs and never truncates the file. Pad's web UI keeps a steady stream of pollers (dashboard/

()

// checkpoint (readers active) just retries next tick. SQLite-only —
// Close() stops it; the Postgres constructor never calls this.
func (s *Store) startWALCheckpointer() {
	s.stopMaint = make(chan struct{})
	s.maintDone = make(chan struct{})
	go func() {
		defer close(s.maintDone)
		ticker := time.NewTicker(walCheckpointInterval)
		defer ticker.Stop()
		for {
			select {
			case <-s.stopMaint:
				return
			case <-ticker.C:
				if _, err := s.db.Exec("PRAGMA wal_checkpoint(TRUNCATE)"); err != nil {
					slog.Warn("wal checkpoint failed", "error", err)
				}
			}
		}
	}()
}

// openPostgresDB opens and configures a PostgreSQL connection pool.
func openPostgresDB(connStr string) (*sql.DB, error) {