Sqlite3 WebAssembly

(sqlite.org)

647 points whatever3 | 1 comments | 15 Oct 24 17:45 UTC | HN request time: 0.771s | source

Show context

koeng ◴[15 Oct 24 18:48 UTC] No.41851815[source]▶

For use in Golang, I really like ncruces wasm SQLite package - https://github.com/ncruces/go-sqlite3 . Unlike cznic's go package (which is great, btw), the wasm version works well on OpenBSD and the like.

replies(1): >>41853244 #

ncruces ◴[15 Oct 24 21:20 UTC] No.41853244[source]▶

>>41851815 #

Author here. If you're interested, do ask questions.

replies(2): >>41853458 #>>41855097 #

infogulch ◴[16 Oct 24 02:41 UTC] No.41855097[source]▶

>>41853244 #

Hey how's the mmap-based shared memory WAL approach working out? It's been about half a year since you finished the implementation and I only see one issue about it on the tracker, a good sign?

replies(1): >>41856487 #

1. ncruces ◴[16 Oct 24 07:28 UTC] No.41856487[source]▶

>>41855097 #

It's turning out great, I guess.

The current approach is not portable to Windows, but it works fine on Linux, macOS, BSD and illumos. In general, portability is hindered more by file locking (I hate POSIX locks) than mmap.

The currently open GitHub issue is more bad default configuration than anything else. Configuring connections to use less memory by default should fix it.

I already have a PR ready for the next release that also opens this up for 32-bit platforms.

Also, GoToSocial (a self-hostable Mastodon alternative) moved to it (from modernc) for its first beta release.

https://github.com/superseriousbusiness/gotosocial

↑