sqlite

sqlite copied to clipboard

database/sql driver

3

I think this sqlite package provides enough interesting features that it is worth building a database/sql driver on top of it. In particular it has better multi-threaded support than the...

crawshaw

Column methods, error and NULL handling

1

I've learned a lot about the sqlite3_column_* functions and redid my methods in [go-sqlite-lite](https://github.com/bvinc/go-sqlite-lite/). * sqlite3_column_blob and sqlite3_column_text might fail with the NOMEM error. * sqlite3_column_text returns a NULL pointer...

bvinc

tracing with runtime/trace

2

If sqlite.Pool moves to sqlitex as described in #47, it can take a context and that opens up the possibility of using runtime/trace for tracing. As the sqlite package cannot...

crawshaw

special support for constants in prepared statements

1

(Thinking aloud.) One of the more annoying aspects of my queries is using constants defined in Go as part of a statement: ``` type Role int const ( RoleAdmin Role...

crawshaw

sqlitex.Exec should protect against nesting

2

I was fairly scared to realize that calling Prepare again with the same query resets the statement even if it's still in use, but I can't think of any way...

FiloSottile

Check all statements are reset at Pool.Close

1

We already check `Conn.CheckReset` in `Pool.Put`. All we have to do is make sure all connections are returned to the pool before `Close` is called.

crawshaw

More HAVE_* defines

1

You might want to add the following HAVE_* defines in sqlite.go: ``` #cgo CFLAGS: -DHAVE_FDATASYNC #cgo CFLAGS: -DHAVE_GMTIME_R #cgo CFLAGS: -DHAVE_ISNAN #cgo CFLAGS: -DHAVE_LOCALTIME_R #cgo linux CFLAGS: -DHAVE_STRCHRNUL #cgo CFLAGS:...

mdevan

Support sqlite3_db_cacheflush

5

It would be great to be able to force [flushing cache to disk](https://www.sqlite.org/c3ref/db_cacheflush.html) using `sqlite3_db_cacheflush`, but it does not seem to be supported.

mitar

I've been at this for days and can't seem to figure out what I'm doing wrong, so I'm hoping someone can help. I have a series of sql statements in...

Dilemma1980

Build failure when using gcc 12.

1

Attempt to build when using gcc 12.2.0 fails with the following error: ``` go build # crawshaw.io/sqlite In file included from /home/niko/go/pkg/mod/crawshaw.io/[email protected]/static.go:19: /home/niko/go/pkg/mod/crawshaw.io/[email protected]/./c/sqlite3.c: In function 'sqlite3Fts5IndexQuery': /home/niko/go/pkg/mod/crawshaw.io/[email protected]/./c/sqlite3.c:220863:18: warning: 'memcpy' specified...

nkolotov