mirror of
https://github.com/bybrooklyn/alchemist.git
synced 2026-04-18 01:43:34 -04:00
503ac84fe0
- Add setup auth fixes and scheduler time validation for reliable onboarding - Harden file watcher behavior under bursty filesystem events - Improve DB stability with WAL, timeouts, FK enforcement, runtime legacy watch_dir support, and new indexes - Add session cleanup task and include config dirs in initial scans - Switch reqwest to rustls for cross-compilation without OpenSSL - Add cross-platform build script (bun + zig + cargo-xwin) and design philosophy doc - Bump documentation changelog for v0.2.6-beta
31 lines
946 B
SQL
31 lines
946 B
SQL
-- Stability and performance indexes (v0.2.5+ compatible)
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_jobs_status_priority_created_at
|
|
ON jobs(status, priority DESC, created_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_jobs_status_updated_at
|
|
ON jobs(status, updated_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_jobs_updated_at
|
|
ON jobs(updated_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_logs_created_at
|
|
ON logs(created_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_decisions_job_id_created_at
|
|
ON decisions(job_id, created_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_encode_stats_created_at
|
|
ON encode_stats(created_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_schedule_windows_enabled
|
|
ON schedule_windows(enabled);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_notification_targets_enabled
|
|
ON notification_targets(enabled);
|
|
|
|
INSERT OR REPLACE INTO schema_info (key, value) VALUES
|
|
('schema_version', '2'),
|
|
('min_compatible_version', '0.2.5'),
|
|
('last_updated', datetime('now'));
|