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

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.