fatal error LNK1104: cannot open file 'sqlite3.lib'

[aberba]

This issue at https://github.com/dlang-community/d2sqlite3/issues/49 still occurs for windows. Wasted almost an hr getting my head around it until I came across the issue. The lib/win64 needs to be available in the root directory.

How can we fix it?

[Geod24]

What we do is adding it to LIB: https://github.com/bpfkorea/agora/blob/537ca3be259d5aa76698e14fc97a3e61de1bab5c/.github/workflows/main.yml#L101