Skip to content

Miller on Windows

Native builds as of Miller 6

Miller was originally developed for Unix-like operating systems including Linux and MacOS. Since Miller 5.2.0 which was the first version to support Windows at all, that support has been partial. But as of version 6.0.0, Miller builds directly on Windows.

The experience is now almost the same on Windows as it is on Linux, NetBSD/FreeBSD, and MacOS.

MSYS2 is no longer required -- although you can of course still use Miller from within MSYS2 if you prefer. There is now simply a single mlr.exe, with no msys2.dll alongside anymore.

See Installation for how to get a copy of mlr.exe.

Setup

Simply place mlr.exe somewhere within your PATH variable.

pix/miller-windows.png

To use Miller from within MSYS2/Cygwin, also make sure mlr.exe is within the PATH variable.

pix/miller-msys.png

Differences

Output Colorization doesn't work on Windows, outside of MSYS2.

The Windows-support code within Miller makes effort to support Linux/Unix/MacOS-like command-line syntax including single-quoting of expressions for mlr put and mlr filter -- and in the examples above, this often works. However, there are still some cases where more complex expressions aren't successfully parsed from the Windows prompt, even though they are from MSYS2:

pix/miller-windows-complex.png

pix/miller-msys-complex.png

Single quotes with && or || inside are fundamentally unhandleable within Windows; there is nothing Miller can do here as the Windows command line is split before Miller ever receives it.

One workaround is to use MSYS2. Another workaround is to put more complex DSL expressions into a file:

pix/miller-windows-complex-workaround.png

A third workaround is to replace " with """, then ' with ":

pix/miller-windows-triple-double-quote.png