sqlite-to-fast-sql

Originally fromcap-go/capgo-skills
Installation
SKILL.md
Contains Shell Commands

This skill contains shell command directives (!`command`) that may execute system commands. Review carefully before installing.

SQLite to Fast SQL Migration

Migrate bridge-based SQLite or SQL plugins to @capgo/capacitor-fast-sql.

When to Use This Skill

  • User wants to replace an existing SQLite or SQL plugin
  • User needs better performance for large result sets or sync-style writes
  • User wants encrypted local storage, transactions, batch writes, or BLOB support
  • User wants a key-value wrapper backed by Fast SQL instead of a legacy storage plugin

Live Project Snapshot

Detected SQL-related packages: !node -e "const fs=require('fs');if(!fs.existsSync('package.json'))process.exit(0);const pkg=JSON.parse(fs.readFileSync('package.json','utf8'));const needles=['sqlite','sqlcipher','typeorm','watermelondb','pouchdb','@capacitor-community/sqlite','@capawesome-team/capacitor-sqlite','@capgo/capacitor-fast-sql'];const out=[];for(const section of ['dependencies','devDependencies']){for(const [name,version] of Object.entries(pkg[section]||{})){if(needles.some((needle)=>name.includes(needle)))out.push(section+'.'+name+'='+version)}}console.log(out.sort().join('\n'))"

Why Fast SQL

Fast SQL is the preferred migration target because it avoids heavy bridge serialization by using a local HTTP transport to native SQLite. That makes it much faster for large result sets and sync-heavy write patterns.

Related skills

More from cap-go/capacitor-skills

Installs
26
GitHub Stars
37
First Seen
Mar 18, 2026