混合架构：两全其美，使用 Supabase 与 Spring Boot

@startuml
skinparam backgroundColor #FEFEFE
skinparam componentStyle rectangle

package "传统架构" {
  actor Utilisateur as user
  component "前端" as frontend #LightBlue
  component "单体后端" as backend #LightCoral {
    [Authentification]
    [CRUD]
    [Logique Métier]
    [Jobs]
    [APIs Tierces]
  }
  database "数据库" as db #LightGray

  user --> frontend
  frontend --> backend : 所有请求
  backend --> db
}

note right of backend
一切都通过后端
即使是简单的操作
⚠️ 单点瓶颈
⚠️ 从一开始就很复杂
⚠️ 强耦合
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE
skinparam componentStyle rectangle

package "架构 BaaS 纯" {
  actor Utilisateur as user
  component "前端" as frontend #LightBlue
  cloud "Supabase / Firebase" as baas #LightGreen {
    [Auth]
    [Database]
    [Storage]
    [Edge Functions]
  }

  user --> frontend
  frontend --> baas : 所有操作
}

note right of baas
快速开发
无需管理服务器
⚠️ 复杂逻辑受限
⚠️ 厂商锁定
⚠️ 边缘函数受限
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE
skinparam componentStyle rectangle

actor Utilisateur as user #LightBlue

package "前端层" {
  component "静态网站 JBake" as frontend #SkyBlue
}

package "简单层 (Supabase)" #LightGreen {
  component "身份验证" as auth
  component "CRUD 基础" as crud
  component "文件存储" as storage
  component "实时" as realtime
}

package "业务层 (Spring Boot)" #Coral {
  component "复杂逻辑" as logic
  component "编排" as orchestration
  component "计划作业" as jobs
  component "集成" as integrations
}

database "PostgreSQL 共享" as db #LightGray

user --> frontend

frontend --> auth : OAuth2, JWT
frontend --> crud : 文章, 资料
frontend --> storage : 图片，文件
frontend --> realtime : 通知

frontend --> logic : 计算, 报告
frontend --> orchestration : 工作流程
logic --> integrations : 条纹, APIs
orchestration --> db
jobs --> db

crud --> db
auth --> db

note bottom of db
**单一真实来源**
由 Supabase 和 Spring Boot 共享
end note

note right of auth
免费，最高可达 50k 用户
配置仅需几次点击
OAuth2 多提供商
end note

note right of logic
仅在必要时启用
Kotlin + 协程
复杂事务
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE

rectangle "**阶段 1 : MVP**" #LightGreen {
  component "JBake + Supabase" as mvp
  note right
✓ 开发天数
✓ 成本：0欧元
✓ 概念验证
  end note
}

rectangle "**阶段 2 : 增长**" #LightYellow {
  component "JBake + Supabase\n+ Spring Boot (可选)" as growth
  note right
✓ 业务逻辑浮现
✓ 首批作业已计划
✓ 第三方集成
户
  end note
}

rectangle "**阶段 3 : 规模**" #LightCoral {
  component "完整架构" as scale
  note right
✓ 复杂的编排
✓ 性能已优化
✓ 分布式缓存
  end note
}

mvp -down-> growth : 当复杂性\n是合理的
growth -down-> scale : 优化\n继续
@enduml

@startmindmap
skinparam backgroundColor #FEFEFE
* 操作\n适用

left side

** 简单操作\n(Supabase)
***_ CRUD 标准
****_ 阅读
****_ 创建
****_ 更新
****_ 删除
***_ 身份验证
****_ 登录/Logout
****_ OAuth2
****_ 会话管理
***_ 存储
****_ 上传文件
****_ CDN 自动
***_ 实时
****_ WebSocket
****_ 通知

right side

** 复杂操作\n(Spring Boot)
***_ 业务逻辑
****复杂计算
****_ 业务规则
****_ 高级验证
***_ 编排
****_ 多服务
****_ 分布式事务
****_ Saga模式
***_ 已计划的任务
****_ 定期报告
****_ 同步
****_ 清洁
***_ 集成
****_ 付款 (Stripe)
****_ APIs 第三方
****_ 服务 ML/AI

@endmindmap

@startuml
skinparam backgroundColor #FEFEFE

database "PostgreSQL" as db #LightGray {
  package "Schema: auth (Supabase)" #LightGreen {
    [users]
    [sessions]
    [identities]
  }

  package "Schema: public (共享)" #SkyBlue {
    [articles]
    [comments]
    [profiles]
  }

  package "Schema: business (Spring Boot)" #Coral {
    [orders]
    [payments]
    [reports]
  }
}

component "Supabase" as supabase #LightGreen
component "Spring Boot" as spring #Coral

supabase -down-> users : 管理
supabase -down-> sessions : 管理
supabase -down-> articles : 访问
supabase -down-> comments : 访问
supabase -down-> profiles : 访问

spring -down-> articles : 访问
spring -down-> profiles : 访问
spring -down-> orders : 管理
spring -down-> payments : 管理
spring -down-> reports : 管理

note right of db
优势：
• 无需复杂同步
• JOINs 在表之间可行
• 一致性得到保证
• 统一迁移
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE
autonumber

actor "用户" as user
participant "JBake" as jbake
participant "Supabase Auth" as auth
participant "Spring Boot" as spring
database "PostgreSQL" as db

== Authentification ==
user -> jbake : Clique "登录"
jbake -> auth : 重定向 OAuth2 (Google/GitHub)
auth -> user : 同意界面
user -> auth : 允许
auth -> auth : 生成 JWT
auth -> jbake : 返回 JWT + Refresh Token
jbake -> jbake : 存储令牌 (sessionStorage)

== Accès aux Ressources ==
group Opération Simple (CRUD)
  user -> jbake : 创建一篇文章
  jbake -> db : POST 和 JWT
  note right: Supabase 行级安全\n自动检查 JWT
  db -> jbake : 文章已创建
end

group Opération Complexe (Métier)
  user -> jbake : 生成报告
  jbake -> spring : POST /api/reports\n与 JWT
  spring -> spring : 验证 JWT Supabase
  spring -> spring : 摘录 声称(user_id, roles)
  spring -> db : 复杂查询
  spring -> jbake : 已生成的报告
end

note over auth, spring
**JWT 是通用的**
经 Supabase 和 Spring Boot 验证
没有 double 身份验证
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE
autonumber

actor "客户" as user
participant "JBake" as jbake
participant "Spring Boot" as spring
participant "Supabase 数据库" as supadb
participant "Stripe API" as stripe
participant "库存服务" as inventory
participant "邮件服务" as email
database "PostgreSQL" as db

user -> jbake : 下订单
jbake -> spring : POST /api/orders/create

== Orchestration Spring Boot ==
spring -> db : BEGIN TRANSACTION

par Vérifications Parallèles
  spring -> inventory : 检查库存
  inventory -> spring : 库存正常
else
  spring -> db : 检查客户资料
  db -> spring : 已验证的客户
end

spring -> stripe : 创建 Payment Intent
stripe -> spring : 意图已创建 (ID: pi_xxx)

spring -> db : 创建 Order (status: PENDING)
db -> spring : 订单已创建

spring -> stripe : 确认支付
stripe -> spring : 付款已确认

spring -> db : 更新订单 (状态: PAID)
spring -> inventory : 减少库存
spring -> db : COMMIT TRANSACTION

par Notifications Asynchrones
  spring -> email : 邮件确认
else
  spring -> supadb : 插入通知
  note right: 实时通知\nvia Supabase 实时
end

spring -> jbake : 订单已确认
jbake -> user : 显示 确认

note over spring
**Spring Boot 的职责：**
• 事务 ACID
• 多服务编排
• 错误时自动回滚
• 边界情况处理
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE

participant "调度器\n(Spring Boot)" as scheduler
participant "报告服务" as report
participant "PostgreSQL" as db
participant "外部 API" as api
participant "邮件服务" as email
participant "Supabase 存储" as storage

== Job Quotidien : 2点整
activate scheduler
scheduler -> report : 触发生成报告

activate report
report -> db : 获取数据\n 过去24小时的
db -> report : 数据集

report -> report : 计算与聚合
report -> report : 生成 PDF

report -> storage : 上传 PDF
storage -> report : URL publique

report -> email : 发送给管理员\n带有链接 PDF
deactivate report

== Job Hebdomadaire : 星期日 3h00 ==
scheduler -> report : 外部同步

activate report
report -> api : 获取外部数据
api -> report : 新数据

report -> db : 更新表格
report -> db : 清理过时数据
deactivate report

== Job Mensuel : 每月1日 ==
scheduler -> report : 开票

activate report
report -> db : 活跃客户列表
report -> report : 计算金额
report -> api : 生成 发票 (Stripe)
report -> email : 发送发票
deactivate report

deactivate scheduler

note right of scheduler
仅使用 Supabase 无法完成
边缘函数不适用
针对长期及周期性任务
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE

start

:Nouvelle fonctionnalité à implémenter;

if (CRUD simple ?) then (oui)
  :✅ **Supabase**;
  stop
else (non)
  if (Authentification ?) then (oui)
    :✅ **Supabase Auth**;
    stop
  else (non)
    if (Upload fichiers ?) then (oui)
      :✅ **Supabase Storage**;
      stop
    else (non)
      if (Temps réel ?) then (oui)
        :✅ **Supabase Realtime**;
        stop
      else (non)
        if (Row Level Security\nsuffisante ?) then (oui)
          :✅ **Supabase + Policies**;
          stop
        else (non)
          :⚠️ **Considérer Spring Boot**;
          #Coral:Passer à l'arbre\nde décision Spring Boot;
          stop
        endif
      endif
    endif
  endif
endif

@enduml

@startuml
skinparam backgroundColor #FEFEFE

start

:Nouvelle fonctionnalité complexe;

if (Orchestration\nmulti-services ?) then (oui)
  :✅ **Spring Boot**;
  stop
else (non)
  if (Transaction ACID\ncritique ?) then (oui)
    :✅ **Spring Boot**;
    stop
  else (non)
    if (Job planifié ?) then (oui)
      :✅ **Spring Boot Scheduler**;
      stop
    else (non)
      if (Intégration API\ntierce complexe ?) then (oui)
        :✅ **Spring Boot**;
        stop
      else (non)
        if (Calculs lourds\n> 10 secondes ?) then (oui)
          :✅ **Spring Boot**;
          stop
        else (non)
          if (Cache distribué\nnécessaire ?) then (oui)
            :✅ **Spring Boot + Redis**;
            stop
          else (non)
            :⚠️ **Probablement Supabase**;
            #LightGreen:Revenir à l'arbre\nde décision Supabase;
            stop
          endif
        endif
      endif
    endif
  endif
endif

@enduml

@startuml
skinparam backgroundColor #FEFEFE
skinparam componentStyle rectangle

package "个人博客 - 95% Supabase" {
  component "JBake" as jbake #SkyBlue

  package "Supabase (免费)" #LightGreen {
    [Auth: OAuth2 Google]
    [Articles (CRUD)]
    [Commentaires]
    [Images (Storage)]
    [Notifications Realtime]
  }

  package "Spring Boot (可选)" #LightCoral {
    [Newsletter Mensuelle]
    note bottom: 仅计划的任务
  }

  database "PostgreSQL" as db

  jbake --> [Auth: OAuth2 Google]
  jbake --> [Articles (CRUD)]
  jbake --> [Commentaires]
  jbake --> [Images (Storage)]
  jbake --> [Notifications Realtime]

  [Articles (CRUD)] --> db
  [Commentaires] --> db
  [Newsletter Mensuelle] --> db
}

note bottom of "Spring Boot (可选)"
Spring Boot 非必须
Newsletter 可由第三方服务（如 Mailchimp）管理
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE
skinparam componentStyle rectangle

package "应用 SaaS - 混合架构" {
  component "JBake / React" as frontend #SkyBlue

  package "Supabase" #LightGreen {
    [Auth Multi-tenant]
    [Profils Utilisateurs]
    [Données Simples]
    [Storage Documents]
  }

  package "Spring Boot" #Coral {
    [Facturation (Stripe)]
    [Analytics Avancées]
    [Rapports Mensuels]
    [Quotas & Limites]
    [Webhooks Stripe]
  }

  cloud "外部服务" {
    [Stripe API]
    [SendGrid Email]
  }

  database "PostgreSQL Partagé" as db

  frontend --> [Auth Multi-tenant]
  frontend --> [Profils Utilisateurs]
  frontend --> [Données Simples]
  frontend --> [Facturation (Stripe)]
  frontend --> [Analytics Avancées]

  [Auth Multi-tenant] --> db
  [Profils Utilisateurs] --> db
  [Données Simples] --> db

  [Facturation (Stripe)] --> db
  [Facturation (Stripe)] --> [Stripe API]
  [Analytics Avancées] --> db
  [Rapports Mensuels] --> db
  [Rapports Mensuels] --> [SendGrid Email]
  [Webhooks Stripe] ..> [Stripe API] : Écoute
}

note right of "Spring Boot"
必要用于：
• 管理订阅
• 循环计费
• 动态配额
• 复杂分析
• 可靠的 Webhook
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE
skinparam componentStyle rectangle

package "电子商务 - 70% Spring Boot" {
  component "店面 (JBake/React)" as frontend #SkyBlue

  package "Supabase" #LightGreen {
    [Auth Clients]
    [Catalogue Produits\n(lecture seule)]
    [Images Produits]
  }

  package "Spring Boot (核心业务)" #Coral {
    [Gestion Commandes]
    [Paiements Stripe]
    [Gestion Stock]
    [Calcul Frais Port]
    [Génération Factures]
    [Synchronisation ERP]
    [Emails Transactionnels]
  }

  cloud "集成" {
    [Stripe]
    [Transporteur API]
    [ERP Externe]
  }

  database "PostgreSQL" as db

  frontend --> [Auth Clients]
  frontend --> [Catalogue Produits\n(lecture seule)]
  frontend --> [Gestion Commandes]

  [Auth Clients] --> db
  [Catalogue Produits\n(lecture seule)] --> db

  [Gestion Commandes] --> db
  [Paiements Stripe] --> [Stripe]
  [Gestion Stock] --> db
  [Calcul Frais Port] --> [Transporteur API]
  [Génération Factures] --> db
  [Synchronisation ERP] --> [ERP Externe]
  [Synchronisation ERP] --> db
}

note right of "Spring Boot (核心业务)"
Spring Boot 不可或缺：
• 关键事务
• 复杂编排
• 多重集成
• 法律合规
• 同步作业
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE

package "估算的月成本" {

  rectangle "阶段 MVP\n(0-1000 users)" #LightGreen {
    [JBake (GitHub Pages): 0€]
    [Supabase: 0€]
    [Spring Boot: N/A]
    note bottom: 总计: 0€/mois
  }

  rectangle "增长阶段\n(1k-10k users)" #LightYellow {
    [JBake (GitHub Pages): 0€]
    [Supabase: 0€]
    [Spring Boot (Cloud Run): 20-50€]
    [PostgreSQL (si séparé): 0-30€]
    note bottom: 合计：20-80€/mois
  }

  rectangle "规模阶段\n(10k-100k users)" #LightCoral {
    [JBake (Netlify Pro): 19€]
    [Supabase Pro: 25€]
    [Spring Boot (instances multiples): 100-300€]
    [Redis Cache: 20-50€]
    [Monitoring: 20€]
    note bottom: 总计： 184-414€/mois
  }
}

note right of "规模阶段\n(10k-100k users)"
此时，收入已经充分证明了成本的合理性。
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE

package "谁管理什么？" {

  rectangle "Supabase 管理 (0 努力)" #LightGreen {
    [Authentification]
    [Base de données]
    [Backups automatiques]
    [Scaling automatique]
    [Monitoring DB]
    [Sécurité DB]
  }

  rectangle "GitHub 管理 (0 努力)" #SkyBlue {
    [Hébergement site statique]
    [HTTPS/SSL]
    [CDN global]
    [Déploiement automatique]
  }

  rectangle "待管理 (Spring Boot)" #LightCoral {
    [Déploiement application]
    [Monitoring APM]
    [Logs centralisés]
    [Scaling horizontal]
    [Mises à jour sécurité]
  }
}

note bottom of "待管理 (Spring Boot)"
可最小化使用：
• Cloud Run（无服务器）
• Kubernetes（如有必要）
• 托管服务（RDS，等）
end note
@enduml

@startmindmap
skinparam backgroundColor #FEFEFE
* 架构\n混合

** 简约开始
***_ MVP 与 Supabase
***_ 0€ 的初始成本
***_ 快速验证

** 智能进化
***_ 添加 Spring Boot\n 如有必要
***_ 逐步迁移
***_ 不进行全面改版

** 利用优势
***_ Supabase: 简洁
***_ Spring Boot: 功率
***_ PostgreSQL: 唯一来源

** 最小化复杂性
***_ 无同步
***_ 不重复
***清晰的架构

** 优化成本
***_ 起始免费
***_ 渐进式缩放
***_ ROI 显而易见

@endmindmap

@startuml
skinparam backgroundColor #FEFEFE

package "完整混合架构" {

  actor "用户" as users

  rectangle "前端 (静态)" #SkyBlue {
    [JBake / GitHub Pages]
    note right: 免费, CDN 全局
  }

  rectangle "简单后端 (Supabase)" #LightGreen {
    [Auth OAuth2]
    [CRUD APIs]
    [Storage]
    [Realtime]
    note right
免费最高支持 50k 用户
零配置服务器
    end note
  }

  rectangle "业务后端 (Spring Boot)" #Coral {
    [Orchestration]
    [Jobs Planifiés]
    [Intégrations]
    [Transactions]
    note right
仅在必要时启用
    end note
  }

  database "PostgreSQL\nSource 唯一真理" as db #LightGray

  users --> [JBake / GitHub Pages]

  [JBake / GitHub Pages] --> [Auth OAuth2]
  [JBake / GitHub Pages] --> [CRUD APIs]
  [JBake / GitHub Pages] --> [Storage]
  [JBake / GitHub Pages] --> [Realtime]
  [JBake / GitHub Pages] --> [Orchestration]

  [Auth OAuth2] --> db
  [CRUD APIs] --> db
  [Orchestration] --> db
  [Jobs Planifiés] --> db
  [Intégrations] --> db
}

note bottom of db
单一基础，双消费者
• Supabase 用于简单场景
• Spring Boot 用于复杂场景
• 无需同步
end note

@enduml

@startuml
skinparam backgroundColor #FEFEFE

rectangle "当代建筑" #SkyBlue {
  [JBake]
  [Supabase]
  [Spring Boot]
}

rectangle "可能的发展" #LightYellow {

  package "性能" {
    [Redis Cache]
    [CDN pour Assets]
    [PostgreSQL Replicas]
  }

  package "监控" {
    [Grafana]
    [Prometheus]
    [Sentry]
  }

  package "CI/CD" {
    [GitHub Actions]
    [Tests Automatisés]
    [Déploiement Continu]
  }

  package "功能" {
    [Search (ElasticSearch)]
    [Queue (RabbitMQ)]
    [Event Sourcing]
  }
}

[Spring Boot] .down.> [Redis Cache] : Peut ajouter
[Spring Boot] .down.> [Queue (RabbitMQ)] : Peut ajouter
[Spring Boot] .down.> [Search (ElasticSearch)] : Peut ajouter

[Supabase] .down.> [PostgreSQL Replicas] : Peut ajouter

note bottom
**可扩展架构**
每个添加都是独立的
无需进行全局重构
end note
@enduml

@startuml
skinparam backgroundColor #FEFEFE

package "操作分布" {

  rectangle "80% - 标准操作" #LightGreen {
    [Lecture de données]
    [Création d'entités]
    [Mise à jour simple]
    [Suppression]
    [Upload fichiers]
    [Authentification]

    note bottom: 由 Supabase 管理
  }

  rectangle "20% - 业务逻辑" #Coral {
    [Calculs complexes]
    [Workflows multi-étapes]
    [Transactions critiques]
    [Intégrations tierces]
    [Jobs planifiés]

    note bottom: 由 Spring Boot 管理
  }
}

note right
**最佳聚焦：**
您的开发时间
专注于使您的产品脱颖而出的20%
end note
@enduml