home-sveltekit/src/lib/server/db/schema.ts, branch main

Allow granular routine frequencies like 5/2w

2026-09-30T20:13:07Z

Compress comments to terse single lines within line width

2026-09-25T07:10:31Z

Add routine archives: archive date, searchable archived list, frozen page

2026-09-07T20:31:23Z

- Stamp archived_at on the archived snapshot; copy it on edit - loadArchived(projectId) + collapsible fuzzy-searched "Archivées" section on the project page - Archived routine pages open read-only with the health chart ending at the archive date; edit/complete actions reject archived routines

Add routine detail page with editable description and health history

2026-09-07T17:17:45Z

Add projects with routines, urgency tracking and health scores

2026-09-07T09:32:41Z

Projects group recurring routines (chores included) with an append-only snapshot table (id, version) so edits never rewrite history; completions reference the exact snapshot. Pure metrics compute due dates, urgency buckets (ok/due/late/veryLate) and 0-100 health scores per routine, project, and globally. Home page lists projects; project dashboard sorts routines most-urgent first with one-tap completion and interval parser inputs (1d/2w/3m/1y).

feat: drag-to-reorder categories with persistent order

2026-07-29T13:01:38Z

refactor: services layer, valibot validation, shared CSS utilities, aria labels, and drizzle migrate

2026-07-28T13:07:57Z

- Extract groceries/categories/references services with db injection - Add valibot for form validation and safe numeric id parsing - Fix category delete FK behavior with onDelete: set null + migration - Replace custom migrate.js with drizzle-orm/libsql/migrator - Add shared CSS utility classes in app.css (forms, lists, buttons) - Add aria-pressed and aria-label on interactive elements - Remove redundant app.css imports and unused /stores import - Add integration tests for all services using drizzle migrate helper - Remove smoke test; add db:migrate and db:studio scripts

refactor: rename brand to reference everywhere

2026-07-27T19:07:48Z

feat: product references + grocery detail page

2026-07-27T17:53:11Z

- references table (brand, price, unit, quality_score) with FK to groceries - /grocery/[id] page for managing references per item - Unit dropdown (€/kg, €/L, €/u) defaulting to €/kg - → link on all items navigates to detail page - Delete item moved from catalog to detail page

feat: separate categories table + /categories management page

2026-07-27T16:31:26Z

- Categories table (id, name unique) with FK from groceries.category_id - /categories page for add/delete categories - Main page uses native