Windows Support: Unable to Install Micrate Due to SQLite3 Library Issue

I am trying to install Micrate on a Windows machine, but I am encountering an issue related to the SQLite3 library. The error message I receive is as follows:

I: Building: micrate
E: Error target micrate failed to compile:
Error: Cannot locate the .lib files for the following libraries: sqlite3

Steps to Reproduce:

  1. Set up a Windows environment with Crystal Lang installed.
  2. Attempt to install Micrate using the standard installation instructions.
  3. Observe the error message related to the SQLite3 library.

Expected Behavior:
Micrate should install successfully on a Windows environment without issues related to locating the SQLite3 library.

Actual Behavior:
The installation fails with an error indicating that it cannot locate the .lib files for the SQLite3 library.


  • Operating System: Windows 11
  • Crystal Lang Version: Crystal 1.12.1 [4cea101] (2024-04-11) LLVM: 18.1.1 Default target: x86_64-pc-windows-msvc
  • Micrate Version: 0.15.1

Additional Information:
I have tried to resolve this issue by downloading the SQLite3 DLL file and placing it in various directories. Specifically, I attempted the following:

  1. Downloaded the SQLite3 DLL file.
  2. Created an environment variable CRYSTAL_LIBRARY_RPATH and set its value to the directory containing the DLL file.
  3. Placed the DLL file in the directory specified by the CRYSTAL_LIBRARY_RPATH environment variable.

Despite these efforts, the error persists. It seems that the build process is still unable to locate the necessary .lib files for SQLite3. Any guidance on how to properly configure the environment or any adjustments needed in the build process for Windows would be greatly appreciated.

By following this instruction, the installation was successful