go-sqlite3
go-sqlite3 copied to clipboard
mattn
sqlite3 driver for go using database/sql
I've encountered an issue where a temporary table is not deleted when its associated database connection is closed. Furthermore, it appears the closed connection is being reused, allowing subsequent users...
I'm running a blob of sql line this: ``` if _, err := db.ExecContext(ctx, statement); err != nil { return err } ``` and I'm getting `FOREIGN KEY constraint failed`;...
I'm working on a library which works with many different SQL drivers and maps to common errors for things like unique constraints etc. I'd like to avoid having to import...
`struct sqlite3_index_info` includes a mask of all column indexes used: https://github.com/mattn/go-sqlite3/blob/7658c06970ecf5588d8cd930ed1f2de7223f1010/sqlite3-binding.h#L7487 This should be included as a parameter to the BestIndex virtual table callback.
A bunch of the constraint op types are missing. sqlite3-binding.h defines the following: ```c #define SQLITE_INDEX_CONSTRAINT_EQ 2 #define SQLITE_INDEX_CONSTRAINT_GT 4 #define SQLITE_INDEX_CONSTRAINT_LE 8 #define SQLITE_INDEX_CONSTRAINT_LT 16 #define SQLITE_INDEX_CONSTRAINT_GE 32 #define...
is the default mutex_mode is full_mutex, which means sqlite will run in Serialized mode ?
This PR fixes issue #1316.
The `vtable_eponymous_only` example is missing a start value assignment to the vtable cursor in one of the four variants of the Filter call For calls with zero to two parameters...
The new version contains some nice improvements like: - Allow a two-argument version of the [iif() SQL function](https://www.sqlite.org/lang_corefunc.html#iif). Also allow [if()](https://www.sqlite.org/lang_corefunc.html#iif) as an alternative spelling for [iif()](https://www.sqlite.org/lang_corefunc.html#iif). - Increase the...
Because of sqlite's flexible typing, even though the column was declared as jsonb, the values are stored as the TEXT-typed json because they're converted to strings by Value/Scan. If the...
