Compiling for Windows and MySQL Server crash when generating index.

[BillyGeat]

We have managed to compile myvector for using under Windows and it works, except the creation of indexes. The MySQL server crashes then - see also here: p3io/myvector-dev#21

Attached here are the changed files to make it compile / work in Windows, including creating the index without crashing the server.
There are many changes, some critical (as locking for read / write operations, what caused the crash) and some other more or less important changes. These changes are for sure also important or needed for Linux and other OS.

myvector-modified.zip

Important to make it work in Windows is the config file. We found that it does not work giving only a MySQL sock file (or at all) but needs the parameters host and port:

myvector_user_id=myvectoruser
myvector_user_password=***
#myvector_socket=D:/MySQLData/mysql.sock
myvector_host=127.0.0.1
myvector_port=3306

[askdba]

Hi, we have no Windows development environment, hence I neither have the ability nor the desire to build it on that platform. I believe it's not our target audience's interest to run a vector search on Windows. I would be happier if you'd like to support this build yourself. Please follow the workflow and submit a PR. Also, if you'd like to discuss further, please join our Slack space

[BillyGeat]

And what are we? We are also "your audience", even if not your target.
I don't know how many people have used this great solution to build something under Linux, but we are one of the first that made it work successfully in our application under Windows...
We wanted to help others that maybe want also to build it for windows MySQL. The changes made regarding the locking are important also for Linux & Co. I am not sure if I am able to do a pull request for these. Maybe I will try by time.
Thank you for the work and I hope you will support it with better documentation.

[askdba]

@BillyGeat, I think you misunderstood me. This is an open-source project and is driven by the community. If this is something the community wants, I would expect some contributions on this end. I will be happy to help, but I do not have the resources to support this, even if I wanted to. If you have the platform codex or Claude code, it should help you build it on Windows. Documentation requests are noted; we're working on a major release for component architecture, and we'll improve the documentation by that time.