go-sqlite VS WBO

Check out https://github.com/zombiezen/go-sqlite if you're interested in trying out Sqlite in Go again. Nice interface, negligible compile time impact, fast, compiles without CGO. It's very comfortable.

I agree that going from text to sqlite is a bit of a hurdle, especially if you're not writing C :)

struggling figuring out how to make my cgo sqlite cross-compile to Windows

Plenty of people trying to fix that.

There's at least:

https://modernc.org/sqlite

Then there's https://github.com/zombiezen/go-sqlite that actually builds https://crawshaw.io/sqlite on top of modernc.

And there's mine that has both a low level and a database/sql driver builds and runs everywhere Go does: https://github.com/ncruces/go-sqlite3

There are several different Go bindings for SQLite. I maintain https://pkg.go.dev/zombiezen.com/go/sqlite

I like and use https://github.com/zombiezen/go-sqlite for CGo-free SQLite. It avoids some of the problems database/sql has, discussed here: https://crawshaw.io/blog/go-and-sqlite.

> C libraries are required to interact with SQLite

Or: modernc.org/sqlite (https://github.com/zombiezen/go-sqlite), "an automatically generated translation of the original C source code of SQLite into Go"

https://pkg.go.dev/modernc.org/sqlite via https://pkg.go.dev/zombiezen.com/go/sqlite

modernc.org/sqlite provides a database/sql driver, but does not (currently) provide an easy way to get at the more advanced functionality of SQLite, like streaming blob I/O or user-defined functions. David Crawshaw has argued that the database/sql API is not a good fit for SQLite, which is how crawshaw.io/sqlite came about.

As a maintainer of an open source JavaScript infinite canvas application [1], I was very interested, and now I am a little disappointed. The set of supported objects on the canvas is quite minimal.

[1] https://github.com/lovasoa/whitebophir

Could a self-hosted whiteboard work? * Excalidraw allows images to be inserted * WBO has a built-in grid mode (but no ruler)

You can share and use a Scrumblr only with the link. But no possibility to import other than opening the same board again (and exporting, printing the page as PDF). Same with the whiteboard WBO, but much more complete and polished one (and has SSL).

Aside from kanban boards, a virtual whiteboard might also work well: * Excalidraw (live) * WBO (live)

A whiteboard thing? Like WBO or Spacedeck

Fluffyboard and WBO - I prefer Fluffyboard because it has an Android app.

This one seems to work well: https://wbo.ophir.dev/

It's basically this: https://wbo.ophir.dev/