941 B
941 B
1. Scope and Migration Confirmation
- 1.1 Confirm migration scope (internal DB vs external IDE DB).
- 1.2 Confirm Drizzle driver choice (keep
better-sqlite3). - 1.3 Confirm no changes to existing database schema.
2. Design and Preparation
- 2.1 Build Drizzle schema (
accounts/settings/ItemTable). - 2.2 Define connection initialization and pragma strategy (WAL,
busy_timeout). - 2.3 Define runtime validation strategy (external IDE DB, loose compatibility).
3. Implementation
- 3.1 Migrate read/write paths in
cloudHandler.ts. - 3.2 Migrate read/write paths in
database/handler.ts. - 3.3 Preserve existing transaction and retry semantics.
4. Testing and Verification
- 4.1 Update unit tests and mocks.
- 4.2 Run regression checks for account backup/restore and injection flow.
- 4.3 Complete cross-platform smoke verification (Win/macOS/Linux).