go-sqlite3 icon indicating copy to clipboard operation
go-sqlite3 copied to clipboard

sqlite3 driver for go using database/sql

Results 242 go-sqlite3 issues
Sort by recently updated
recently updated
newest added

It doesn't create a new database file if opened in a `network drive` with `:encrypted.db?_key`. I attempted to open a new encrypted database on a network drive, and there were...

vscode { "type": "go", "label": "go: build x86 Windows", "command": "build", "args": [ "-ldflags", "-H=windows -s -w", "-o", "dist/juice_x86.exe", "-tags", "windows cgo", "-v", "-mod=mod" ], "problemMatcher": [ "$go" ], "group":...

# github.com/mattn/go-sqlite3 v1.14.0 sqlite3-binding.c: In function ‘sqlite3SelectNew’: sqlite3-binding.c:129019:10: warning: function may return address of local variable [-Wreturn-local-addr] 129019 | return pNew; | ^~~~ sqlite3-binding.c:128979:10: note: declared here 128979 | Select...

cost so lang time to build . Is there any way to speed it up?

Sqlite in standard [amalgamation](https://www.sqlite.org/amalgamation.html) there is [geopoly](https://www.sqlite.org/geopoly.html). It requires the `DSQLITE_ENABLE_GEOPOLY=1` compile time option. Would you accept a PR for this?

``` compilepkg: nogo: errors found by nogo during build-time code analysis: /var/folders/m7/4f6m74nn2b1322hz5q72s1bm0000gn/T/rules_go_work-2711865906/cgo/github.com/mattn/go-sqlite3/__main__/external/com_github_mattn_go_sqlite3/sqlite3_opt_serialize.go:46:36: possible misuse of reflect.SliceHeader (unsafeptr) /var/folders/m7/4f6m74nn2b1322hz5q72s1bm0000gn/T/rules_go_work-2711865906/cgo/github.com/mattn/go-sqlite3/__main__/external/com_github_mattn_go_sqlite3/sqlite3_opt_serialize.go:70:36: possible misuse of reflect.SliceHeader (unsafeptr) ```

Other drivers, in particular [modernc](https://pkg.go.dev/modernc.org/sqlite#Driver.Open) and [ncruces](https://pkg.go.dev/github.com/ncruces/go-sqlite3/driver) support a generic `_pragma` URI parameter. Basically, potentially multiple PRAGMA statements are executed in the order specified in the URI for every connection...

sqlite3-binding.c current has this code: ``` /* ** Macro to disable warnings about missing "break" at the end of a "case". */ #if GCC_VERSION>=7000000 # define deliberate_fall_through __attribute__((fallthrough)); #else #...

sqlite has a feature called `sqlar` which allows one to use the database as a file store: https://www.sqlite.org/sqlar.html. It means we need zlib and two SQL functions (sqlar_compress/sqlar_uncompress). I read...