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)

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)