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

Updated for latest version 3310100 and URLs are added.

Thank you!

God bless you, kind sir.

Thank you! It works.

Thank you!! Straight forward!

thanks

Updated to current version 3.34.1 (3340100)

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!