Skills
.Work. You
Rest

fantasia-sqlite-main

Community

SQLite usage in Fantasia's Electron main.

Software Engineering#database#migration#sqlite#persistence#electron#user-data
Authorvishiri
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Managing SQLite persistence in Fantasia Archive's Electron main process requires careful per-user data isolation, safe path handling, and migration planning to prevent data loss or corruption at upgrade time.

Core Features & Use Cases

  • Define per-user storage location using app.getPath('userData') and ensure directories exist before opening the DB.
  • Keep sqlite3 as a native dependency in the main process, avoiding renderer-initiated SQL to prevent untrusted access.
  • Plan and implement migrations with versioned schemas and safe upgrade paths for user data continuity.
  • Use Case: When upgrading Fantasia Archive to a new schema version, apply migrations automatically on startup.

Quick Start

Configure per-user SQLite storage in the Electron main process and plan migrations.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: fantasia-sqlite-main
Download link: https://github.com/vishiri/fantasia-archive/archive/main.zip#fantasia-sqlite-main

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.