use-sql-migrate-sqlite

Estrelas1

Forks0

Atualizado9 de abril de 2026 às 23:08

SQLite migrations with sql-migrate and litemigrate. Use when setting up SQLite migrations, configuring foreign keys, or using modernc.org/sqlite driver.

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Fonte

therootcompany

therootcompany/golib

Abrir repositório GitHub Ver repositórios do creator

Download

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Arquitetos de banco de dadosInformática e Matemática·SOC 15-1243

SKILL.md

readonly

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"]

CLI setup

sql-migrate -d ./sql/migrations/ init --sql-command sqlite

Environment

# .env
SQLITE_PATH='./app.db'

Go library

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).

SQL dialect notes

datetime('now') instead of CURRENT_TIMESTAMP for default values in expressions
TEXT for timestamp columns (SQLite has no native datetime type)
INSERT OR IGNORE for idempotent seeds (not INSERT IGNORE)
String concatenation: id || CHAR(9) || name (used by sync query)
ALTER TABLE ... DROP COLUMN requires SQLite 3.35.0+ (2021-03-12)
"no such table" error string used to detect missing _migrations table
Default path: todos.db if no env var set

sqlc with SQLite

SQLite 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"

Mais deste repositório

mesmo repositório

use-sql-migrate-postgres

therootcompany/golib

PostgreSQL migrations with sql-migrate and pgmigrate. Use when setting up PostgreSQL migrations, schema multi-tenancy, or pgx connection for migrations.

2026-04-201

use-sql-migrate-cli

therootcompany/golib

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.

2026-04-091

use-sql-migrate-golang

therootcompany/golib

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.

2026-04-091

use-sql-migrate-mysql

therootcompany/golib

MySQL and MariaDB migrations with sql-migrate and mymigrate. Use when setting up MySQL/MariaDB migrations, configuring multiStatements, or MY_CNF credentials.

2026-04-091

use-sql-migrate-sqlserver

therootcompany/golib

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.

2026-04-091

use-sqlmigrate

therootcompany/golib

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.

2026-04-091

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"]

CLI setup

sql-migrate -d ./sql/migrations/ init --sql-command sqlite

Environment

# .env
SQLITE_PATH='./app.db'

Go library

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).

SQL dialect notes

datetime('now') instead of CURRENT_TIMESTAMP for default values in expressions
TEXT for timestamp columns (SQLite has no native datetime type)
INSERT OR IGNORE for idempotent seeds (not INSERT IGNORE)
String concatenation: id || CHAR(9) || name (used by sync query)
ALTER TABLE ... DROP COLUMN requires SQLite 3.35.0+ (2021-03-12)
"no such table" error string used to detect missing _migrations table
Default path: todos.db if no env var set

sqlc with SQLite

SQLite 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"