home/categories/sql-databases/ecnu-icalk-autoskill-skillbank-convskill-english-gpt4-8-sqlite-fts5-full-text-search-implementation-skill-md
sql-databasesdatabases
sqlite-fts5-full-text-search-implementation
Implement full-text search using SQLite's FTS5 extension with SQLAlchemy. This includes creating a virtual FTS table, synchronizing data between standard tables and the FTS index, and executing raw SQL queries for search operations.
maintainer
ECNU-ICALK
업데이트됨 3/16/2026
스타
304
포크
34
quick start
Installation and usage
Implement full-text search using SQLite's FTS5 extension with SQLAlchemy. This includes creating a virtual FTS table, synchronizing data between standard tables and the FTS index, and executing raw SQL queries for search operations.
설치
$ install --globalskills.sh
사용법
설치 후 터미널에서 다음 명령을 실행하여 이 스킬을 사용할 수 있습니다:
skills use sqlite-fts5-full-text-search-implementation