Low-level Go interface to SQLite 3
Version 1.3 is largely a bug-fix release, but is a minor version change because of the new sqlitemigration.Pool.Take method.
sqlitemigration.Pool now has a new method Take so that it implements a common interface with sqlitex.Pool (#97).OpenWAL behavior on sqlite.OpenConn.Version 1.2.0 adds a sqlitex.Pool.Take method and improves error messages.
sqlitex.Pool has a new method Take which returns an error along with a Conn (#83).sqlite.ErrorOffset is a new function that returns the SQL byte offset that an error references.sqlite.Conn.Prep, sqlite.Conn.Prepare, and sqlite.Conn.PrepareTransient now include position information in error messages if available.sqlitex.Pool.Get method has been deprecated in favor of the new Take method.Version 1.1.1 improves performance on write-contended workloads.
Version 1.1 introduces the ability to prepare connections on sqlitex.Pool, improves performance, and improves documentation.
sqlitex.NewPool function with support for a ConnPrepareFunc (#65).SetCollation (#64).sqlitex.Open in favor of sqlitex.NewPool.Version 1.0 is the first officially stable release of zombiezen.com/go/sqlite. It includes improved documentation and is cleaned up for current versions of Go. There are no breaking changes to the API: this release is more a recognition that the API has been stable and a promise that it will continue to be stable.
*Stmt.ColumnIsNull and *Stmt.IsNull methods (#55).sqlitefile and sqlitex.interface{} with any. This should be a compatible change.modernc.org/sqlite version updated to 1.27.0.io.* interface fields on sqlitefile.Buffer and sqlitefile.File. These were unused.zombiezen.com/go/sqlite/fs package. It existed to help transition around Go 1.16, but is no longer useful.Version 0.13.1 fixed a bug with the sqlitemigration package.
sqlitemigration will no longer disable foreign keys during operation (#54).Version 0.13 added support for user-defined collating sequences and user-defined virtual tables.
ext/generateseries provides an optional generate_series table-valued function extension.regexp function example as a new ext/refunc package.*Conn.Serialize and *Conn.Deserialize methods (#52).AggregateFunction.WindowValue incorrectly stated that it would not be called in non-window contexts. The sentence has been removed, but the behavior has not changed.Version 0.12 added support for the online backup API.
OpenFlags.OpenNoMutex and OpenFullMutex no longer have an effect on sqlite.OpenConn. OpenNoMutex (i.e. multi-thread mode) is now the only supported mode. *sqlite.Conn has never been safe to use concurrently from multiple goroutines, so this is mostly to prevent unnecessary locking and to avoid confusion. (#32).Version 0.11 changes the aggregate function API.
AggregateFunction. The previous 4-callback approach has been removed and replaced with a single MakeAggregate callback. Not only was the previous API unwieldy, but it failed to handle concurrent aggregate function calls in a single query.modernc.org/sqlite version updated to 1.20.0.