Does this skill support database migrations?

Yes, it includes standard patterns for using Goose with Go's embed package, allowing you to bundle SQL migrations directly into your compiled binary.

Which SQLite driver should I use for Go?

For CLI tools and simple deployment, this skill recommends the pure-Go modernc.org/sqlite driver. For maximum performance where CGO is acceptable, the github.com/mattn/go-sqlite3 driver is preferred.

How can I prevent multiple instances of my Go app from corrupting the database?

The skill implements a single-instance locking pattern using file-based locks (flock) to ensure only one process can access the database file at a time.

How do I handle concurrent writes in SQLite with Go?

The skill provides patterns for enabling WAL (Write-Ahead Logging) mode and setting a busy_timeout, which allow for better concurrency and prevent 'database is locked' errors.

SQLite for Go Development

Name: SQLite for Go Development
Author: ksawaneh

byksawaneh

데이터베이스 관리

Implements high-performance SQLite patterns in Go applications using best practices for drivers, migrations, and concurrency.

소개

This skill provides Claude with comprehensive domain knowledge to architect robust local-first Go applications using SQLite. It guides developers through critical architectural decisions including driver selection between pure-Go and CGO implementations, XDG-compliant file pathing, and optimal PRAGMA configurations for WAL mode. By integrating patterns for migrations, repository abstractions, and automated backups, it ensures Go applications maintain data integrity and high performance without external database dependencies.

주요 기능

Comprehensive pure-Go vs CGO driver comparison and selection
Optimized SQLite PRAGMA configurations for WAL and concurrency
Embedded SQL migration workflows using Goose
Production-ready Repository Pattern implementations
Automated backup rotation and single-instance locking mechanisms
0 GitHub stars

사용 사례

Building cross-platform CLI tools requiring persistent local storage
Creating embedded databases for Go-based desktop or TUI applications
Developing local-first applications with high-concurrency needs

소개

주요 기능

Comprehensive pure-Go vs CGO driver comparison and selection
Optimized SQLite PRAGMA configurations for WAL and concurrency
Embedded SQL migration workflows using Goose
Production-ready Repository Pattern implementations
Automated backup rotation and single-instance locking mechanisms
0 GitHub stars

사용 사례

Building cross-platform CLI tools requiring persistent local storage
Creating embedded databases for Go-based desktop or TUI applications
Developing local-first applications with high-concurrency needs