go-sqlite3
go-sqlite3 copied to clipboard
ncruces
Go bindings to SQLite using wazero
https://steampipe.io/ https://sqlite.org/forum/forumpost/87a01d8a9f3e51e8
Found a difference between our and SQLite's `memdb` VFS: theirs is reference counted. When the last connection to a shared database is closed, it gets deleted. I'm wondering whether I...
Both the BSDs and illumos support shared memory, but not OFD locks. Some form of in-memory locks would allow them to (safely) support WAL mode, as long we lock the...
Port #71 to Windows. Mostly: - [internal/util/alloc.go](https://github.com/ncruces/go-sqlite3/blob/main/internal/util/alloc.go) - [internal/util/mmap.go](https://github.com/ncruces/go-sqlite3/blob/main/internal/util/mmap.go) Also, [vfs/shm.go](https://github.com/ncruces/go-sqlite3/blob/main/vfs/shm.go) needs tweaks to the DMS lock. Reference: https://devblogs.microsoft.com/oldnewthing/20240201-00/?p=109346
https://sqlite.org/fts5.html#extending_fts5
https://sqlite.org/rtree.html#customquery
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...
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.
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.