요즘 하는거

07/01/2026, 14:06:35

1378 views · 0 likes

RisuAI 구버전 기반으로 스파게티 해체랑 강결합 구조 분리하고 DB랑 임베딩 까지 대규모 리펙토링 중.

src/ts/
├── core/           Pure types + utils (framework-agnostic)
│   ├── types/      Database, character, Chat, Message ...
│   └── platform.ts PlatformId, PlatformAdapter interface
│
├── database/       SQL layer (PGlite / native PG)
│   ├── driver/     DbDriver interface + PGlite·PG implementations
│   ├── schema.ts   12 tables DDL (characters 82 cols, fully normalized)
│   ├── queries.ts  Parameterized CRUD
│   ├── migrations.ts  RISUSAVE → SQL auto-migration
│   └── export.ts   SQL → RISUSAVE reverse conversion
│
├── frontend/       Browser-specific
│   ├── platform/adapter.ts  PlatformAdapter implementation
│   ├── reactive/bridge.svelte.ts  SQL ↔ DBState.db bidirectional sync
│   └── init.ts     DB bootstrap (PGlite or native PG)
│
├── backend/        Node/Docker server
│   ├── server.ts   Express + runtime flag injection
│   └── proxy.ts    /hub-proxy, /proxy2
│
└── process/        Runtime (sendChat, streaming, tokenizer)
    └── index.svelte.ts  ChatConfig/ChatCallbacks decoupling

Browser (Vercel etc.)             Node / Docker
┌──────────────────┐             ┌──────────────────┐
│  Svelte UI       │             │  Svelte UI       │
│  ↕ DBState.db    │             │  ↕ DBState.db    │
│  ↕ bridge.svelte │             │                  │
│  ↕ PGlite WASM   │             │  ↕ native PG 18  │
│  + pgvector      │             │  + pgvector      │
│    (IndexedDB)   │             │  + WAL-G         │
└──────────────────┘             └──────────────────┘