public.oracle_artifacts
Oracle artifacts
PDF, share-card, gift artifact, and print-view as separate deliverable entities.
production persistence
Data that remembers the scroll and knows how to forget the person
This wave connects Echo, Council, Artifacts, Passport, Shop, and Stripe to real Supabase tables: consent, jobs, purchase links, audit trail, and deletion requests. Without it, the site is beautiful but lives like stained glass without a wall.
live persistence lab
Build the product's real trail
Choose the layer, delivery channels, and consent. The panel shows tables, jobs, env, RLS, and risks before a user pays.
Channels
ready
Scroll artifacts
PDF and share-card separate private and public fields.
Tables
public.oracle_artifactspublic.delivery_jobspublic.admin_audit_events
Jobs
- pdf_render_job
- share_card_render_job
- gift_delivery_job
- private_pdf_render_job
Env
NEXT_PUBLIC_SUPABASE_URLSUPABASE_SERVICE_ROLE_KEYSTRIPE_SECRET_KEYSTRIPE_WEBHOOK_SECRETNEXT_PUBLIC_SITE_URLMissing consent
- none
Risks
- lost_delivery
- duplicate_payment
- orphan_artifact
public.delivery_jobs
Delivery jobs
Email, PDF, gift, receipt, Echo, and recovery are sent as tracked jobs.
Missing consent
Do not write to Passport, email, or public share without explicit consent.
Public/private leak
Share-card receives safe fields only; full question remains private.
Lost delivery
Delivery jobs have attempts, status, next_run_at, and support path.
Duplicate payment
Stripe event id and checkout session id have unique indexes.
production persistence
Legendary persistence standard
What must live in the database instead of a polished mockup.
production persistence
Supabase schema
Tables for scrolls, artifacts, Echo, Council, consent, and delivery.
production persistence
Consent ledger
Consent as a separate story, not a forgotten checkbox.
production persistence
Reading records v2
Sealed records connect to products, artifacts, and Passport.
production persistence
Echo, Council, Artifacts
New premium layers receive durable records.
production persistence
Delivery jobs
Email, PDF, gift, and recovery move through a tracked queue.
production persistence
Email queue
Emails do not expose the question and have a retry path.
production persistence
Purchase links
Stripe product, Price ID, and unlock route are connected durably.
production persistence
Audit trail
The operator sees events without unnecessary private details.
production persistence
Data deletion
Export, deletion, and anonymization get a clear workflow.
production persistence
RLS policy map
Public access is closed; service role works only on the server.
production persistence
Backup and restore
Launch requires a recovery plan, not hope in the stars.
production persistence
Operator handbook
How to verify real data after payment and delivery failures.
production persistence
AI contract
AI receives only needed fields and writes to safe tables.
production persistence
World-class audit
Criteria for a mature production system.
production persistence
Completion plan
What remains after this pass before a real launch.