Appleseed Homes — Design · Renovate · Build

Handoff

Architecture & readiness

This page summarizes the repository’s README.md and HANDOFF.md. This preview contains a redesigned public website (Home, Services, Work, About, Contact) with the client portal integrated behind Client Login. The current Squarespace site and domain were not modified; nothing is published.

Sandbox demo · /demo
  • Fictional people & projects (Harbor House, City Retreat, Fernwood Lane).
  • Stored only in this browser (localStorage + IndexedDB for files).
  • Identity switcher is not authentication; it cannot reach live data.
  • Same rules as live (version check, option ownership, membership) enforced in code.
  • “Reset demo” restores the original seed.
Live portal · /portal
  • Invite-only email/password accounts; no public sign-up or role selection.
  • Roles in server-maintained user_roles; access by project_members.
  • Postgres RLS on every table; decisions only via transactional RPC with version check.
  • Private bucket; uploads via server function (signature + size checks); 60 s signed downloads.
  • Starts empty — no demo data is ever written to the live database.

Access matrix

ActionAnonymousClient AClient B on A’s projectAdmin
Read projects / rooms / boards / milestones—Own assigned onlyOther projects: noAll
Read draft selections & draft invoices—NoNoAll
Create / edit projects, rooms, boards, milestones, options—NoNoYes
Publish / request approval—NoNoYes (RPC)
Approve / request changes—Own project, awaiting, current version (RPC)NoNo (client decision only)
Comment—Own project, as selfNoYes, as self
Upload document—Own project (server fn)NoYes (server fn)
Download document (60s signed URL)—Own projectNoAll
Delete document—Own uploadsNoYes
Grant / revoke client access—NoNoYes (invited accounts)
Change roles (user_roles)—NoNoNo — SQL/owner only
Edit decision history—NoNoNo (immutable)

Readiness checklist

  • Lovable Cloud backend provisioned; schema, RLS, RPCs, triggers and private bucket applied
  • Public sign-up disabled; email/password sign-in enabled; leaked-password check on
  • Database RLS/RPC suite executed: 36/36 checks passed (see HANDOFF.md → Test evidence)
  • Unit tests for upload validation, decision rules and sandbox workflow
  • Invite the first studio user (Cloud → Users) and bootstrap admin with the documented SQLowner action
  • Invite real clients, then grant project access by email in each projectowner action
  • Run a signed-in end-to-end pass with two real test clients + admin (checklist in HANDOFF.md)owner action
  • Configure custom domain + auth redirect URLs before publishingowner action
  • Customize auth emails (invite, reset) with studio brandingowner action
  • Add malware scanning for uploads before accepting files from the publicowner action
  • Public website pages with exact current logo bundled locally (source + checksum in HANDOFF.md)
  • Contact composer opens a mailto draft only — no server delivery, no stored inquiries
  • Public copy migrated verbatim from the current site (provenance in docs/content-provenance.md)
  • Approve the few new navigation/label strings listed in docs/content-provenance.mdowner action
  • 39 owner-authorized photos migrated into the app (galleries + lightbox); manifest in docs/portfolio-assets.md
  • Review photo alt text, portraits, and which project the featured kitchen photo belongs toowner action
  • Before DNS cutover: redirect /residential → /work/michigan-farmhouse, /commercial → /work/chicago-projects, /experiential → /about; keep Squarespace as rollbackowner action
  • Payments / billing — intentionally not implemented (demo invoices only)

Known limitations

  • No malware scanning of uploads yet (type is verified by file signature, size ≤ 10 MB). Mitigation in HANDOFF.md.
  • No payments, Stripe, or outgoing app email. Invoices are demo records labeled non-payable.
  • Signed-in browser end-to-end tests against live accounts were not run (no real test accounts exist yet).
  • Logo and portfolio photos are the studio’s own files (owner-confirmed), bundled unaltered with resized web copies. The Squarespace CDN serves Chicago photos at most 2500 px wide, so ask the owner for the camera originals if larger prints are needed.
  • No form backend or email provider: inquiries rely on the visitor’s email app.