package sqlite

import (
	"database/sql"
	"strings"

	_ "github.com/mattn/go-sqlite3"
)

// https://github.com/mattn/go-sqlite3#connection-string
var dsnOpts = []string{
	"_foreign_keys=1",
	"_journal_mode=WAL",
	"_synchronous=NORMAL",
	"_auto_vacuum=incremental",
	"_busy_timeout=5000",
	"_txlock=immediate",
}

func Open(dbPath string) (*sql.DB, error) {
	return sql.Open("sqlite3", dbPath+"?"+strings.Join(dsnOpts, "&"))
}