What is the missing 'sqlite3.lib' file when trying to run rustqlite with precompiled binary on Windows 11?

Question

I'm new to the rust ecosystem bare in mind. I'm trying to use rustqlite crate so I can store really large indexes that don't fit into memory. I get an immediate RUNTIME ERROR where it faults and says:

= note: LINK : fatal error LNK1181: cannot open input file 'sqlite3.lib'

linking with `link.exe` failed: exit code: 1181

I'm using the precompiled binary for sqlite3 windowsx86 and I only have a "tokens.db" along with my sqlite3.exe. What is the sqlite3.lib supposed to be? I've found no informative videos or searching and I've even installed brand new MS build tools and etc.

The rust code itself has no compiler errors and seems to look okay. I look forward to any insight on how to fix this

Answer 1

Simple fix in the Cargo.toml as @pigeonhands pointed out. All I had to do was specify the features bundled option in the rustqlite dependency.

rusqlite = { version = "0.31", features = ["bundled"] }

Getting super slow writes to my DB but other than that works now thanks.