Add support for Windows

[mihow]

This is a great project, thank you! But unfortunately we can't use it any software because not all of our colleagues are on Linux.

[coleifer]

Surely it will compile on windows if you have sqlite3 header and shared library.

[mihow]

Is there documentation on that? Currently it is not possible to pip install pysqlite3 or pysqlite3-binary

[coleifer]

Currently it is not possible to pip install pysqlite3

How is that?

Edit: to be clear, this project should build fine on windows.

[Sums123]

Hi guys, I'm also having issues building on Windows Visual Studio Build Tools 2022 is installed

I added the sqlite library according to this thread. https://github.com/dlang-community/d2sqlite3/issues/49 It also fails, when I change "Machine" to x86

When compiling I get the following issue: LINK : fatal error LNK1181: cannot open input file 'sqlite3.lib' error: command 'C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\VC\Tools\MSVC\14.34.31933\bin\HostX86\x86\link.exe' failed with exit code 1181

Full error message

When trying to run install through pip, I get the same error

[r0ny123]

Hi @coleifer, I am too having issues when building pysqlite3 on windows (Visual Studio Build Tools 2022) as @Sums123 stated above.

[coleifer]

You appear to be missing sqlite3 headers.

[r0ny123]

But I can successfully build it using pysqlite3==0.4.8

[r0ny123]

Hey, @coleifer pinging again, can you take a look?

[coleifer]

https://github.com/coleifer/pysqlite3/issues/44#issuecomment-1298415467