can't build go-api with mongoDB about spin

[itowlson]

Unfortunately, the current preview of WASI (WebAssembly System Interface) does not provide for outbound sockets, so TinyGo cannot emit socket code when targeting WASI. This means that libraries that depend on socket code do not compile (and the error, as you see, don't clearly identify the root cause). (This is why Spin has to special-case HTTP.)

As WASI Preview 2 stabilises, hopefully TinyGo will port their standard library to that, and sockets code will start working.

Sorry for the inconvenience and thanks for trying it out!

[souravsk]

Thanks @itowlson for your awesome explanation.
One more Question if I created a Postgres db locally instant of that MongoDB then it will work?

[itowlson]

Spin does have a Postgres interface (see https://developer.fermyon.com/spin/rdbms-storage) but, unfortunately, it's not surfaced in the Go SDK at the moment, only Rust (and C#, but that SDK is a bit out of date). And I don't think you'd be able to use the Go Postgres drivers, because even with a local instance they'll be using sockets.

I'm afraid Spin's Go relational database story is not great right now - MySQL is also Rust/C#-only, and SQLite doesn't yet have a Go SDK because of some implementation issues (hopefully soon though!). If a key-value store works for you then Go does have both Spin's built-in key-value storage, and "bring your own instance" Redis...?