fantasia-sqlite-main

Configure SQLite per-user storage in the Electron main process by using app.getPath('userData') and ensuring directories exist before opening the database to isolate data safely per user.

Avoiding SQLite queries in the Electron renderer process prevents untrusted access. Keep sqlite3 as a native dependency in the main process to enforce safe lifecycle handling and production security constraints.

Handle SQLite database migrations during app upgrades by planning versioned schemas and safe upgrade paths, applying migrations automatically on startup to ensure user data continuity and prevent data loss.

Yes, sqlite3 works as a native dependency in the Electron main process for local user data persistence. Enforce native sqlite3 constraints and safe lifecycle handling in production to prevent database corruption.

Limitations of using native sqlite3 for Electron persistence include strict main process isolation requirements, careful per-user path handling, and the need for versioned migration planning to avoid data corruption during upgrades.