Support running on Windows

[jiacai2050]

Describe This Problem

Background: #1411 (comment)

Although Windows is not recommended as production env, it's convenient for testing and develop.

Proposal

We have two choices:

• Build horaedb in Linux with static link(musl libc), and cross compile to Windows
• Build horaedb in Windows natively

Method 1 maybe simpler than 2, but I little experience here, so welcome any voltenner to tackle this issue in either ways.

Additional Context

No response

[kcrazy]

I tried to compile it on Windows, but the compilation failed when it reached pprof because pprof uses the crate nix and libc, which are not supported on Windows.

[jiacai2050]

Thanks for trying.

I think you can add a feature gate on that crate, and see what happens next.

[kcrazy]

The repository at rust-rocksdb also does not support Windows.

[jiacai2050]

The repository at rust-rocksdb also does not support Windows.

Try build with make build-wal-message-queue, this will disable rocksdb and use kafka as wal.

[kcrazy]

The repository at rust-rocksdb also does not support Windows.

Try build with make build-wal-message-queue, this will disable rocksdb and use kafka as wal.

Can we directly use cargo to replace make?

[tanruixiang]

The repository at rust-rocksdb also does not support Windows.

Try build with make build-wal-message-queue, this will disable rocksdb and use kafka as wal.

Can we directly use cargo to replace make?

Of course you can, our makefile is very simple, you can refer to the https://github.com/apache/incubator-horaedb/blob/main/Makefile#L40

[jiacai2050]

If you're interested in contributing more, welcome to join our community.

[kcrazy]

If you're interested in contributing more, welcome to join our community.

I don't have much experience in developing databases and I'm not particularly interested at the moment. However, I'm open to occasionally testing builds on Windows.

[kcrazy]

The repository at rust-rocksdb also does not support Windows.

Try build with make build-wal-message-queue, this will disable rocksdb and use kafka as wal.

Can we directly use cargo to replace make?

Of course you can, our makefile is very simple, you can refer to the https://github.com/apache/incubator-horaedb/blob/main/Makefile#L40

I tried using the command

cargo build --no-default-features --features wal-message-queue

but encountered some issues with jemalloc: jemalloc-sys@0.3.2 states that 'jemalloc support for x86_64-pc-windows-msvc is untested'.

[jiacai2050]

Thanks for testing, I will add a feature gate for jemalloc and pprof this week, so you can disable them on Windows.