webdav/sync/go/pkg/mod/github.com/glebarez/go-sqlite@v1.21.2 - 志元云盘

File OriginalPic	EditTime	Size
examples	2024-09-11 12:24:37	968 B
functest	2024-09-11 12:24:37	6.4 KB
addport.go	2024-09-11 12:24:37	1.37 KB
all_test.go	2024-09-11 12:24:37	68.7 KB
AUTHORS	2024-09-11 12:24:37	790 B
CONTRIBUTORS	2024-09-11 12:24:37	985 B
embed.db	2024-09-11 12:24:37	8 KB
embed2.db	2024-09-11 12:24:37	8 KB
go.mod	2024-09-11 12:24:37	501 B
go.sum	2024-09-11 12:24:37	7.16 KB
LICENSE	2024-09-11 12:24:37	1.45 KB
mutex.go	2024-09-11 12:24:37	502 B
norlimit.go	2024-09-11 12:24:37	298 B
null_test.go	2024-09-11 12:24:37	478 B
README.md	2024-09-11 12:24:37	1.54 KB
rlimit.go	2024-09-11 12:24:37	434 B
rulimit.go	2024-09-11 12:24:37	499 B
sqlite.go	2024-09-11 12:24:37	47.68 KB
sqlite_go18.go	2024-09-11 12:24:37	1.48 KB
sqlite_go18_test.go	2024-09-11 12:24:37	972 B
sqlite_version_test.go	2024-09-11 12:24:37	534 B
SQLITE-LICENSE	2024-09-11 12:24:37	1.47 KB

[![Tests](https://github.com/glebarez/go-sqlite/actions/workflows/tests.yml/badge.svg)](https://github.com/glebarez/go-sqlite/actions/workflows/tests.yml)
![badge](https://img.shields.io/endpoint?url=https://gist.githubusercontent.com/glebarez/0fd7561eb29baf31d5362ffee1ae1702/raw/badge-sqlite-version-with-date.json)

# go-sqlite
This is a pure-Go SQLite driver for Golang's native [database/sql](https://pkg.go.dev/database/sql) package.
The driver has [Go-based implementation of SQLite](https://gitlab.com/cznic/sqlite) embedded in itself (so, you don't need to install SQLite separately)

# Usage

## Example

```go
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](https://www.sqlite.org/pragma.html#pragma_journal_mode): ```path/to/some.db?_pragma=journal_mode(WAL)```
- [busy timeout](https://www.sqlite.org/pragma.html#pragma_busy_timeout): ```:memory:?_pragma=busy_timeout(5000)```

Multiple PRAGMAs can be specified, e.g.:<br>
```path/to/some.db?_pragma=busy_timeout(5000)&_pragma=journal_mode(WAL)```

云盘

Home / 志元云盘 / webdav / sync / go / pkg / mod / github.com / glebarez / [email protected]