sqliteutil

Documentation

Index

• func DiagnoseDBOpenError(path string, originalErr error) error
• func IsCantOpenError(err error) bool
• func IsNoSuchColumnError(err error) bool
• func OpenDB(path string) (*sql.DB, error)

Functions

func DiagnoseDBOpenError

func DiagnoseDBOpenError(path string, originalErr error) error

DiagnoseDBOpenError provides a more helpful error message when SQLite fails to open/create a database file.

func IsCantOpenError

func IsCantOpenError(err error) bool

IsCantOpenError checks if the error is a SQLite CANTOPEN error (code 14).

func IsNoSuchColumnError

func IsNoSuchColumnError(err error) bool

IsNoSuchColumnError checks if the error is due to a missing column in SQLite. This typically happens when querying a column that doesn't exist in the schema.

func OpenDB

func OpenDB(path string) (*sql.DB, error)

OpenDB opens a SQLite database with recommended pragmas for concurrency and foreign key support. It configures the connection pool for serialized writes (MaxOpenConns=1).