Someone is working on a libpglite based around pglite. I think this is what will provide an actual sqlite alternative:

https://github.com/electric-sql/pglite-bindings

It would still be missing the standardized disk format aspect of sqlite, but otherwise will be neat.

This is very much the point of https://pglite.dev

It's an embeddable Postgres you can run in process as a local client DB, just like SQLite but it's actually Postgres.

I wish this were available for Go lang, perhaps via Wazero.

Me too. There's only so much time in life. I'd take it for a spin if someone else did it. :)

Ah, I thought I recognized your username from a Github URL. :D Thank you for your contributions in the SQLite & Go space!

For sure. I’m curious if anyone using it in production as an alternative to SQLite and, if so, what the performance and experience is like.

Interesting! I'm going to look into that. :-) Thank you for sharing.

You got my hopes up, but it's WASM for now, not something I could add into a golang [1] or python app and have running like sqlite. OK, still hoping...!

[1]https://github.com/electric-sql/pglite/issues/89