메뉴
SQLite migrations with sql-migrate and litemigrate. Use when setting up SQLite migrations, configuring foreign keys, or using modernc.org/sqlite driver.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
| name | use-sql-migrate-sqlite |
| description | SQLite migrations with sql-migrate and litemigrate. Use when setting up SQLite migrations, configuring foreign keys, or using modernc.org/sqlite driver. |
| depends | ["use-sqlmigrate"] |
sql-migrate -d ./sql/migrations/ init --sql-command sqlite
# .env
SQLITE_PATH='./app.db'
import (
"database/sql"
_ "modernc.org/sqlite"
"github.com/therootcompany/golib/database/sqlmigrate"
"github.com/therootcompany/golib/database/sqlmigrate/litemigrate"
)
// MUST: enable foreign keys via pragma
db, err := sql.Open("sqlite", dbPath+"?_pragma=foreign_keys(1)")
conn, err := db.Conn(ctx)
defer func() { _ = conn.Close() }()
runner := litemigrate.New(conn)
applied, err := sqlmigrate.Latest(ctx, runner, scripts)
MUST: The caller imports the SQLite driver (modernc.org/sqlite recommended — pure Go, no CGo).
datetime('now') instead of CURRENT_TIMESTAMP for default values in expressionsTEXT for timestamp columns (SQLite has no native datetime type)INSERT OR IGNORE for idempotent seeds (not INSERT IGNORE)id || CHAR(9) || name (used by sync query)ALTER TABLE ... DROP COLUMN requires SQLite 3.35.0+ (2021-03-12)_migrations tabletodos.db if no env var setSQLite CHAR(n) columns map to interface{} in sqlc. Use column-level overrides:
# sqlc.yaml
sql:
- schema: "sql/migrations/"
queries: "sql/queries/"
engine: "sqlite"
gen:
go:
out: "internal/tododb"
overrides:
- column: "todos.id"
go_type: "string"
- column: "todos.status"
go_type: "string"
PostgreSQL migrations with sql-migrate and pgmigrate. Use when setting up PostgreSQL migrations, schema multi-tenancy, or pgx connection for migrations.
sql-migrate CLI tool for database migrations. Use when initializing migrations, creating migration files, running up/down, checking status, or generating migration scripts. Covers psql, mariadb, mysql, sqlite, sqlcmd.
Embed SQL migrations in Go applications using sqlmigrate library. Use when writing Go code that runs migrations on startup, implements auto-migrate, or uses the Migrator interface. Covers pgmigrate, mymigrate, litemigrate, msmigrate.
MySQL and MariaDB migrations with sql-migrate and mymigrate. Use when setting up MySQL/MariaDB migrations, configuring multiStatements, or MY_CNF credentials.
SQL Server migrations with sql-migrate and msmigrate. Use when setting up SQL Server migrations, configuring sqlcmd, TDS 8.0 encryption, or SQLCMD environment variables.
Database migration tools for Go projects. Use when writing migrations, running sql-migrate CLI, embedding migrations in Go apps, or setting up new database schemas. Covers PostgreSQL, MySQL/MariaDB, SQLite, SQL Server.