Auditoría de mi consumo LLM : SQLite, OpenCode, Ollama Cloud, y por qué mi suscripción Pro rompe el mercado mundial

Failed to generate image: PlantUML preprocessing failed: [From <input> (line 11) ]

@startuml
skinparam backgroundColor #FEFEFE
skinparam defaultFontSize 12

title Los Tres Actores de Mi Stack LLM
left to right direction

actor "Yo (Desarrollador)" as Dev

package "OpenCode\n(github.com/anomalyco/opencode)" as OC {
  rectangle "CLI de vibe coding
^^^^^
 Syntax Error? (Assumed diagram type: component)

@startuml
skinparam backgroundColor #FEFEFE
skinparam defaultFontSize 12

title Los Tres Actores de Mi Stack LLM
left to right direction

actor "Yo (Desarrollador)" as Dev

package "OpenCode\n(github.com/anomalyco/opencode)" as OC {
  rectangle "CLI de vibe coding
Código abierto, gratuito" as CLI
  note right of CLI
    C'est l'outil que j'utilise
    pour coder avec des agents IA.
    Il ne fournit AUCUN modèle.
    C'est un terminal + un orchestrateur.
  end note
}

package "Ollama (Instalación Local)" as OL {
  rectangle "Cliente de inferencia
Instalado en mi máquina" as Client
  note right of Client
    C'est le logiciel qui fait tourner
    les modèles. Il peut les exécuter
    en local OU les déléguer au cloud
    selon le tag (:cloud).
    Il s'authentifie via clé SSH.
  end note
}

package "Ollama Cloud
(ollama.com)" as OCloud {
  rectangle "Servicio de inferencia en la nube
Suscripción Pro : 20€/mes" as Cloud
  note right of Cloud
    C'est le fournisseur d'inférence.
    Mes modèles avec le tag :cloud
    sont exécutés sur LEURS serveurs.
    L'abonnement Pro donne accès
    à des quotas supérieurs.
  end note
}

Dev --> CLI : "Yo tecleo prompts"
CLI --> Client : "Llame este modelo"
Client --> Cloud : "Clave SSH + solicitud\n(modelos :cloud)"
Client --> Client : "Ejecución local
(modelos sin :cloud)"

@enduml

$ ls -lh ~/.local/share/opencode/opencode.db
-rw-r--r-- 1 cheroliv cheroliv 660M mai 18 12:25 opencode.db

Failed to generate image: PlantUML preprocessing failed: [From <input> (line 7) ]

@startuml
skinparam backgroundColor #FEFEFE
skinparam defaultFontSize 11

title Costo Mensual Proyectado — 220M Entrada + 1,9M Salida
rectangle "Ollama Cloud Pro
~20€" as OC #4CAF50
^^^^^
 Syntax Error? (Assumed diagram type: activity)

@startuml
skinparam backgroundColor #FEFEFE
skinparam defaultFontSize 11

title Costo Mensual Proyectado — 220M Entrada + 1,9M Salida
rectangle "Ollama Cloud Pro
~20€" as OC #4CAF50
rectangle "Gemini Flash
$69" as GF #8BC34A
rectangle "Promoción DeepSeek
$98" as DSP #FFC107
rectangle "GPT Mini\n\$174" as GM #FF9800
rectangle "Claude Haiku
$230" as CH #FF5722
rectangle "HF/Novita\n\$374" as HF #F44336
rectangle "DeepSeek normal\n\$390" as DSN #F44336
rectangle "GPT 5.4
\$579" as G4 #D32F2F
rectangle "Claude Sonnet
$689" as CS #D32F2F
rectangle "Claude Opus
$1 148" as CO #B71C1C
rectangle "GPT 5.5
$1 157" as G5 #880E4F

note bottom of OC
  DeepSeek V4 Pro 1.6T MoE
  + accès à tout le catalogue
  Ollama Cloud (Qwen, GLM, Kimi...)
  Inclus dans l'abonnement
end note
@enduml

Failed to generate image: PlantUML preprocessing failed: [From <input> (line 9) ]

@startuml
skinparam backgroundColor #FEFEFE
skinparam defaultFontSize 12

title Arquitectura — Dos suscripciones Ollama Cloud Pro en una máquina
left to right direction

node "Mi Máquina Física" {
  frame "Ollama Instancia A (nativo)
^^^^^
 Syntax Error? (Assumed diagram type: class)

@startuml
skinparam backgroundColor #FEFEFE
skinparam defaultFontSize 12

title Arquitectura — Dos suscripciones Ollama Cloud Pro en una máquina
left to right direction

node "Mi Máquina Física" {
  frame "Ollama Instancia A (nativo)
puerto :11434" as Native {
    database "Identidad A
/usr/share/ollama/.ollama/id_ed25519"
  }
  frame "Ollama instancia B (Docker)
puerto:11435" as Docker {
    database "Identity B\n~/ollama-b-data/id_ed25519"
  }
}

cloud "Ollama Cloud" {
  actor "Cuenta Pro A\n(email 1)" as A
  actor "Cuenta Pro B\n(correo 2)" as B
}

Native --> A : "Clave del dispositivo A"
Docker --> B : "Dispositivo tecla B"

note bottom of Docker
  Conteneur Docker isolé :
  - Clé SSH distincte
  - Port réseau distinct (11435)
  - Volume persistant (~/ollama-b-data)
  - restart: always
end note
@enduml