Iptvnator Sqlite DB Worker
4gray/iptvnator
A skill your agent uses when changing Electron SQLite IPC, database-worker operations, request-scoped progress or cancellation, worker packaging, or runtime verification of non-EPG database work.
SQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。
$ npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install jiushiwon/wg-skills sqlite-guide-skill --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/vibeCoding/backend/database/sqlite-guide-skill .claude/skills/sqlite-guide-skill && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "sqlite-guide-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/backend/database/sqlite-guide-skill into .claude/skills/sqlite-guide-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-guide-skill", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/backend/database/sqlite-guide-skillType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install jiushiwon/wg-skills sqlite-guide-skill --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/vibeCoding/backend/database/sqlite-guide-skill .agents/skills/sqlite-guide-skill && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "sqlite-guide-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/backend/database/sqlite-guide-skill into .agents/skills/sqlite-guide-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-guide-skill", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install jiushiwon/wg-skills sqlite-guide-skill --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/vibeCoding/backend/database/sqlite-guide-skill .cursor/skills/sqlite-guide-skill && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "sqlite-guide-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/backend/database/sqlite-guide-skill into .cursor/skills/sqlite-guide-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-guide-skill", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/jiushiwon/wg-skills.git --path vibeCoding/backend/database/sqlite-guide-skill--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install jiushiwon/wg-skills sqlite-guide-skill --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/vibeCoding/backend/database/sqlite-guide-skill .gemini/skills/sqlite-guide-skill && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "sqlite-guide-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/backend/database/sqlite-guide-skill into .gemini/skills/sqlite-guide-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-guide-skill", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install jiushiwon/wg-skills sqlite-guide-skillInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/vibeCoding/backend/database/sqlite-guide-skill .github/skills/sqlite-guide-skill && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "sqlite-guide-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/backend/database/sqlite-guide-skill into .github/skills/sqlite-guide-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-guide-skill", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install jiushiwon/wg-skills sqlite-guide-skill --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/vibeCoding/backend/database/sqlite-guide-skill .opencode/skills/sqlite-guide-skill && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "sqlite-guide-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/backend/database/sqlite-guide-skill into .opencode/skills/sqlite-guide-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-guide-skill", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
sqlite-guide-skillSQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。
Sqlite Guide Skill is an agent skill from jiushiwon/wg-skills. SQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。
Its SKILL.md is about 910 tokens, which your agent loads only when the skill is triggered. The skill folder holds 5 other files, including reference files (for example `README.md`, `references/connection-pool.md` and `references/performance-tuning.md`).
It sits in Databases. It works with SQLite. The licence is Apache-2.0.
Read from SKILL.md and the folder at commit a4a640b. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
No scripts in the folder and no shell commands in SKILL.md (its code samples are python, go, java and sql).
From the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Sqlite Guide Skill loads about 908 tokens when it runs, and up to ~7.5k if it reads all its reference files. Until then it costs about 43 tokens; SKILL.md has 55 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
The full file from jiushiwon/wg-skills at commit a4a640b, republished under its Apache-2.0 licence (© jiushiwon). 55 words, ~908 tokens.
.claude/skills/sqlite-guide-skill/SKILL.md (or your agent's skills folder). This skill also uses 4 other files; get the full folder from GitHub.面向已有后端项目的开发者,快速集成 SQLite 能力。
| 能力 | 说明 |
|---|---|
| 连接配置 | SQLite 连接/文件路径配置 |
| CRUD 操作 | 增删改查/批量操作 |
| 事务处理 | 事务提交/回滚 |
| 并发访问 | WAL 模式/锁机制 |
| ORM 映射 | 实体类/Repository |
用户说"帮我加 SQLite"或"集成 SQLite"时触发。
# config.py
class Settings(BaseSettings):
db_path: str = "./data/myapp.db"
# database.py
import sqlite3
from contextlib import contextmanager
class SQLiteClient:
def __init__(self, db_path: str):
self.db_path = db_path
# 启用 WAL 模式提升并发
self._init_db()
def _init_db(self):
with self.get_conn() as conn:
conn.execute("PRAGMA journal_mode=WAL")
conn.execute("PRAGMA synchronous=NORMAL")
@contextmanager
def get_conn(self):
conn = sqlite3.connect(self.db_path)
conn.row_factory = sqlite3.Row
try:
yield conn
conn.commit()
finally:
conn.close()
def execute(self, sql: str, params: tuple = ()):
with self.get_conn() as conn:
cursor = conn.execute(sql, params)
return cursor.lastrowid
def query(self, sql: str, params: tuple = ()):
with self.get_conn() as conn:
cursor = conn.execute(sql, params)
return [dict(row) for row in cursor.fetchall()]import (
"database/sql"
_ "github.com/mattn/go-sqlite3"
)
func InitDB(dbPath string) (*sql.DB, error) {
db, err := sql.Open("sqlite3", dbPath)
if err != nil {
return nil, err
}
// 启用 WAL 模式
db.Exec("PRAGMA journal_mode=WAL")
db.Exec("PRAGMA synchronous=NORMAL")
return db, nil
}// application.yml
spring:
datasource:
url: jdbc:sqlite:./data/myapp.db
driver-class-name: org.sqlite.JDBCCREATE TABLE IF NOT EXISTS "wg_user" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"username" TEXT NOT NULL UNIQUE,
"password" TEXT NOT NULL,
"nickname" TEXT,
"email" TEXT,
"status" INTEGER NOT NULL DEFAULT 1,
"created_at" TEXT NOT NULL DEFAULT (datetime('now')),
"updated_at" TEXT NOT NULL DEFAULT (datetime('now')),
"deleted_at" TEXT
);
CREATE INDEX IF NOT EXISTS "idx_username" ON "wg_user"("username");
CREATE INDEX IF NOT EXISTS "idx_status" ON "wg_user"("status");def transfer_money(from_id: int, to_id: int, amount: float):
with sqlite_client.get_conn() as conn:
try:
# 扣款
conn.execute(
"UPDATE wg_account SET balance = balance - ? WHERE id = ?",
(amount, from_id)
)
# 加款
conn.execute(
"UPDATE wg_account SET balance = balance + ? WHERE id = ?",
(amount, to_id)
)
conn.commit()
except Exception:
conn.rollback()
raise# WAL 模式:读写可以并发
conn.execute("PRAGMA journal_mode=WAL")
# 同步模式:平衡安全与性能
conn.execute("PRAGMA synchronous=NORMAL") # 推荐
# 缓存大小(MB)
conn.execute("PRAGMA cache_size=10000")
# 临时文件内存
conn.execute("PRAGMA temp_store=MEMORY")| 场景 | 适用性 |
|---|---|
| 单机工具 | ✅ 完美 |
| 小型应用 | ✅ 推荐 |
| 嵌入式设备 | ✅ 完美 |
| 高并发 Web | ❌ 不推荐 |
| 分布式系统 | ❌ 不推荐 |
© jiushiwon, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 4 other files (references) in vibeCoding/backend/database/sqlite-guide-skill of jiushiwon/wg-skills.
Open the folder on GitHubat commit a4a640b
Sqlite Guide Skill next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Sqlite Guide Skill this skilljiushiwon/wg-skills | 110 | — | ~908 | Automated safety check: Pass | Apache-2.0 | |
| Iptvnator Sqlite DB Worker4gray/iptvnator | 7.3k | — | ~824 | Automated safety check: Pass | MIT | |
| Analyze Nsys Profilemlc-ai/pith-train | 355 | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | |
| Reactive Sqlite UIfastrepl/anarlog | 9.4k | — | ~699 | Automated safety check: Pass | MIT | |
| Composer Forensicsdxos/dxos | 525 | — | ~3.1k | Automated safety check: Pass | Custom licence | |
| Sqlite Schema Designfastrepl/anarlog | 9.4k | — | ~1.9k | Automated safety check: Pass | MIT |
4gray/iptvnator
A skill your agent uses when changing Electron SQLite IPC, database-worker operations, request-scoped progress or cancellation, worker packaging, or runtime verification of non-EPG database work.
mlc-ai/pith-train
Query a captured PithTrain Nsight Systems profile to measure compute/communication overlap, locate exposed comm by DualPipeV stage, and inspect per-rank stream behavior.
fastrepl/anarlog
Build SQLite-backed reactive UI in apps/desktop using stable patterns for reads, selection, forms, writes, and loading states.
dxos/dxos
Forensically inspect and repair Composer browser profiles — offline (Chrome OPFS / SQLite extract) or live via /recovery.html debug port.
fastrepl/anarlog
Design or review schemas for crates/cloudsync using SQLite Sync constraints, not generic SQLite advice.
deusXmachina-dev/memorylane
Create SQLite migrations for MemoryLane storage schema changes.
jiushiwon/wg-skills
A skill your agent uses when generating UI for a specific scenario (mobile/PC/官网/管理端/营销页/文档/金融/原生/3D), when refactoring an existing HTML/Vue/React project to a unified design system, when extracting…
jiushiwon/wg-skills
A skill your agent uses when 用户想用一句话生成流程图、工作流图解、开发流程图、AI 流程图或任何步骤型图解,支持多风格输出(flat icon / 暖白手账风 / dark / cute),并提供现成模板一键出图。
jiushiwon/wg-skills
This skill should be used when the user wants to create a standardized uni-app project for WeChat mini-program, H5, and App from scratch.
jiushiwon/wg-skills
FastAPI 项目一键初始化技能。面向零基础小白,提供环境探测、自动安装、完整 Web 骨架生成、SSE 流式框架、JWT 鉴权、统一响应封装、文件上传接口、一键启动/重启脚本、Swagger 文档,内置 MySQL(默认)/ PostgreSQL / MongoDB 数据库选择。用户只需说"帮我搭一个 FastAPI 项目"即可一条命令完成从零到跑的完整链路。触发词:"FastAPI…
jiushiwon/wg-skills
FFmpeg 多媒体处理技能 — 将自然语言描述转为正确的 ffmpeg 命令,覆盖视频剪辑、转码、水印、合成、提取、生成等操作。内置一键安装脚本(Windows/Mac/Linux)。触发词:ffmpeg、视频剪辑、视频裁剪、视频转码、视频压缩、去水印、加水印、视频拼接、视频合成、提取音频、视频转…
jiushiwon/wg-skills
A skill your agent uses when designing or reviewing the request layer of a frontend project (web / uni-app / mini-program), including request.ts wrappers, interceptors, deduplication, mocks, error…
Works with
Categories
SQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。. Sqlite Guide Skill is an agent skill from jiushiwon/wg-skills.
Sqlite Guide Skill fits situations like: databases work in your project.
Run `npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a claude-code`. Or copy the skill folder (vibeCoding/backend/database/sqlite-guide-skill in jiushiwon/wg-skills) into .claude/skills/sqlite-guide-skill in your project. Claude Code loads it when a task matches its description.
Run `npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a codex`. Or copy the skill folder (vibeCoding/backend/database/sqlite-guide-skill in jiushiwon/wg-skills) into .agents/skills/sqlite-guide-skill in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sqlite-guide-skill, .gemini/skills/sqlite-guide-skill, .github/skills/sqlite-guide-skill and .opencode/skills/sqlite-guide-skill in your project.
SKILL.md names no scripts, command-line tools or credentials: Sqlite Guide Skill is instructions for the agent only. Our summary lists: Python 3.
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Sqlite Guide Skill is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 908 tokens (SKILL.md is roughly 3.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 6.6k tokens, read only when the agent opens those files.
Skills that share tags, products or a category with Sqlite Guide Skill: Iptvnator Sqlite DB Worker (4gray/iptvnator, 7.3k stars), Analyze Nsys Profile (mlc-ai/pith-train, 355 stars), Reactive Sqlite UI (fastrepl/anarlog, 9.4k stars) and Composer Forensics (dxos/dxos, 525 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
jiushiwon (a GitHub user) maintains it in jiushiwon/wg-skills, which has 110 GitHub stars. The repository holds 121 skills in this directory. The repository was last updated on October 4, 2026.
Source: jiushiwon/wg-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.