Nuno Cruces

Generic PRAGMA URI parameters

12

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...

Port to wazero.

1

As mentioned in [reddit](https://www.reddit.com/r/golang/comments/1cpdrdn/comment/l3p1531/?context=3). Took the liberty of trying it out. This required an unreleased https://github.com/tetratelabs/wazero/pull/2216 fix. You may want to hold out for the next release.

I'm guessing this version (from the CGO example) is more widely applicable (I ship a `database/sql` driver as well). PS: if you find that all the copies and allocs are...

See [this](https://github.com/ncruces/go-sqlite3/blob/main/embed/exports.txt) for an (approximated) list of what's already supported (some APIs don't need wrapping of every function). Compare with [this](https://www.sqlite.org/c3ref/funclist.html). API coverage is already pretty decent. Reply to this...

Wrap more of sqlite-createtable-parser

1

Now that we're [bundling](https://github.com/ncruces/go-sqlite3/tree/main/util/sql3util) [sqlite-createtable-parser](https://github.com/marcobambini/sqlite-createtable-parser), wrap more of it.

Could `db.BeginTx` use `db.ReadOnly` if `sql.TxOptions.ReadOnly` is true?

https://duckdb.org/docs/api/go.html#appender

The SQLite FAQ [advises](https://www.sqlite.org/faq.html#q5) against this, but people [still do it](https://github.com/superseriousbusiness/gotosocial/issues/3360). Investigate what, if anything, can be done to improve the situation.

Implement proper path resolution

3

This is an umbrella issue intended to track the effort to implement the path resolution algorithm described by [WASI filesystem](https://github.com/WebAssembly/wasi-filesystem/blob/main/path-resolution.md). As described prominently in our documentation, our current WASI filesystem...

xts: avoid redundant bounds checks

6

Small changes to improve performance of xts by about 6%. This removes all bounds checks, which can be verified by running: go build -gcflags="-d=ssa/check_bce/debug=1" . Before this would show mutiple...