Build SQLite3 .lib file on windows

build_sqlite3_lib.md

How to build SQLite3 .lib file on Windows 10

1. Download source from source

   For example: source https://www.sqlite.org/2023/sqlite-amalgamation-3430100.zip

2. Download binary from binary

   For example: binary https://www.sqlite.org/2023/sqlite-dll-win64-x64-3430100.zip

3. Extract both archives to the same directory

4. Open Developer Command Prompt for VS 2017 by typing Developer Command in Windows Search

5. Go to directory where you've extracted source code and binary files (via opened cmd)

6. Run lib /DEF:sqlite3.def /OUT:sqlite3.lib /MACHINE:x64

Blog post

Ty a lot

thank

great

Thank you!

Thanks! And this works on windows 11 VS2022.

Thanks! And this works on windows 11 VS2022.

Great!

this was a life saver

Thank you!

Thank you ! You're my god now.

I'm having an issue where, after following the final command, LINK : fatal error LNK1104: cannot open file 'sqlite3.def'

This is how the directory looks if it matters

This is how the command prompt looks

@TheUniKian You have to be inside sqlite directory.
So, you first have to do cd C:\Users\_USER_\Downloads\sqlite

It never worked in CMD so I never thought to try it there. I'm so sorry

nice， thank you！

Thank you!

Updated to latest source and binary (version 3.43.1.)

SQLITE_VERSION=$(echo $(curl -s 'https://www.sqlite.org/download.html') | awk '{ sub(".*sqlite-autoconf-",""); sub("\\.tar.*",""); sub("/.*",""); print; }')

DLL_URL="https://www.sqlite.org/`date +"%Y"`/sqlite-dll-win64-x64-${SQLITE_VERSION}.zip"
SOURCE_URL="https://www.sqlite.org/`date +"%Y"`/sqlite-amalgamation-${SQLITE_VERSION}.zip"

Hi Everyone, I have a issue about the final command , it says ### fatal error LNK1104: cannot open file 'sqlite3.def'
Here is the picture

You are in wrong directory, you are executing lib command in C:\Program Files\Microsoft Visual Studio\2022\Community but you should first move to D:\sqlite-amalgamation-3430100

Issue solved ,thank you @zeljic

thank you, sir~

thank you

thank you!

thank you!

You are so handsome！

thanks saviour

thankyou sir!

Thank you, concise and clear and works perfectly.

Hello
When I download sqlite-amalgamation-3430100, there are several files.

How to build static sqlite3.lib file on windows?

Give me an advise.
If someone know that, let me know.

@AustinBrown12
read more carefully 2-6 points.

Your folder will look like this

then open the "Developer Command Prompt For VS..." cd into the folder with the files and run lib /DEF:sqlite3.def /OUT:sqlite3.lib /MACHINE:x64