go-sqlite
This is a pure-Go SQLite driver for Golang's native database/sql package. The driver has Go-based implementation of SQLite embedded in itself (so, you don't need to install SQLite separately)
This is a fork of cznic/sqlite with changes to make it compatible with GORM.
Usage
Example
package main
import (
"database/sql"
"log"
_ "github.com/glebarez/go-sqlite"
)
func main() {
// connect
db, err := sql.Open("sqlite", ":memory:")
if err != nil {
log.Fatal(err)
}
// get SQLite version
_ := db.QueryRow("select sqlite_version()")
}
Connection string examples
- in-memory SQLite:
":memory:" - on-disk SQLite:
"path/to/some.db" - Foreign-key constraint activation:
":memory:?_pragma=foreign_keys(1)"
Settings PRAGMAs in connection string
Any SQLIte pragma can be preset for a Database connection using _pragma query parameter. Examples:
- journal mode:
path/to/some.db?_pragma=journal_mode(WAL) - busy timeout:
:memory:?_pragma=busy_timeout(5000)
Multiple PRAGMAs can be specified, e.g.:
path/to/some.db?_pragma=busy_timeout(5000)&_pragma=journal_mode(WAL)
