Build from source fails in Windows VM about rqlite

[otoolep]

@LuKks -- you can see successful Windows build here: https://ci.appveyor.com/project/otoolep/rqlite

@dwco-z -- you build on Windows. Do you do anything special, beyond the docs at https://rqlite.io/docs/install-rqlite/building-from-source/

[otoolep]

@LuKks -- do you have a C compiler installed, and is CGO_ENABLED=1 set?

[otoolep]

Because what you are seeing implies it is not. I can reproduce your build errors like this:

$ CGO_ENABLED=0 go build .
# github.com/rqlite/rqlite/v8/db
../../db/db.go:84:28: undefined: sqlite3.Version
../../db/db.go:1225:21: c.Prepare undefined (type *sqlite3.SQLiteConn has no field or method Prepare)
../../db/db.go:1335:17: dst.Backup undefined (type *sqlite3.SQLiteConn has no field or method Backup)

See https://github.com/mattn/go-sqlite3?tab=readme-ov-file#compilation

[otoolep]

I've updated the build documentation to make this clearer:

https://rqlite.io/docs/install-rqlite/building-from-source/#compilation-errors-locating-sqlite-functions

I can leave this issue open, but may close it soon. I'm pretty sure you just need to make sure you have a C compiler installed.

[LuKks]

Thanks! CGO_ENABLED=1 plus installing gcc via https://jmeubank.github.io/tdm-gcc did it!

[LuKks]

In case someone wants to easily install it anywhere: https://github.com/like/rqlite-runtime

npm i -g rqlite

Then just rqlited ./data1 or rqilte

I'm missing builds for macOS x64 and Raspberry Pi but will look into it when I find some machines for that

[LuKks]

There is also a new tiny and simple Node.js wrapper in the works but private atm until it's complete, excited for that!