search

coleifer / pysqlite3

SQLite3 DB-API 2.0 driver from Python 3, packaged separately, with improvements
zlib License
183 stars 51 forks source link

Building wheels for Windows? #69

Closed andreped closed 7 months ago

andreped commented 7 months ago

I have been using this package as part of a Docker build. But for local development on Windows, we are having issues, as we do not have access to C++ build tools. Hence, it would be of value to have precompiled binaries for Windows as well.

I see that you have precompiled binaries for Python 3.6-3.12 for manylinux here, but could you add the same for Windows.

You likely do not have this, as you are running the builds locally on a Linux desktop. But I would suggest just making a GitHub Actions workflow for this.

If you want, I can draft up a PR for this, which produces the binaries for Windows and Linux.

cc: @coleifer

EDIT: It would even be possible to use twine to push built binaries to PyPI directly, if of interest. But thats up to you what you want. Alternatively, just storing the precompiled binaries are Artifacts is a simple way to solve this, but then you would need to manually download these and run these twine command locally.

coleifer commented 7 months ago

I haven’t used windows in 15 years, I suggest setting up your own build process to generate the wheels.

coleifer commented 7 months ago

No interest here, but other interested parties are welcome to set up a build process for wheels.

nalgeon commented 7 months ago

@andreped maybe try sqlean.py, which is based on pysqlite3 and provides builds for Windows, Linux and macOS.

andreped commented 7 months ago

@andreped maybe try sqlean.py, which is based on pysqlite3 and provides builds for Windows, Linux and macOS.

@nalgeon That looks like exactly what I want! Thank you for the great suggestion, @nalgeon! :]