Hello There!. This is my first ever blog post.
Very recently, I have started exploring Rust language and I already have so much fun learning this language.
I was trying to do some basic database CRUD implementations in Rust and as you know, most famous framework for the same is Diesel .
Since I faced lots of issues while setting up Diesel on my local machine, I thought of putting it as blog post so that, it can be of useful to someone who will face similar issues of mine.
For your information, I am using Windows 10 operating system (64-bit) and Rust v1.45.0.
In case if you have not installed Rust with Visual C++ build tools , when you're trying to install Diesel framework, you may get some errors related to Linker.exe. It is better to install latest version of Microsoft Visual C++ build tools first and then re-install Rust on your computer.
Installing Diesel framework is a 2-step process.
Step 1: Install Diesel using CARGO
cargo install diesel
As of writing of this post, Diesel supports MySQL, Postgres and SQLite. The above command expects all the client tools pre-exists on your computer.
If you have one of the client tools, you can use following command
cargo install diesel --no-default-features --features mysql postgres sqlite
In my case, i am having Postgres so, i tried with
cargo install diesel --no-default-features --features postgres
Initially, when i try the above command, I was getting following error
error: diesel = note: link : fatal error lnk1181: cannot open input file 'libpq.lib'
After spending few minutes on google, I figured out, i need to setup environment variable named PQ_LIB_DIR mapped to lib directory of Postgres installation folder.
In my computer, I have Postgres installed on C:\Program Files\Postgres\12\. So, I setup PQ_LIB_DIR as C:\Program Files\Postgres\12\lib.
Due to spaces in the folder name, cargo install diesel threw me error message. So, I had to correct it like c:/Program Files/Postgres/12/lib to solve the first level of issue.
Step 2: Setting up Diesel
To setup Diesel, we need run following command
diesel setup
It throws me following error:
The code execution cannot proceed because libpq.dll was not found.
Even though, I had added PQ_LIB_DIR environment variable, I got the above error. After a little search, I found out that, diesel is not able to find the libpq.dll from folders listed under PATH variable. After added PQ_LIB_DIR to PATH variable, that error was gone.
Then, I was getting another error:
The code execution cannot proceed because libssl-1_1-x64.dll was not found.
This dll file is shipped alongwith postgres and it can be found under BIN folder. After I have added Postgres' BIN folder to PATH variable, diesel setup was completed successfully.
Hope you find the above post useful. Please share your feedback in case if i miss any other points.
Happy reading!!!
Top comments (0)