Skip to content

Instantly share code, notes, and snippets.

@zeljic

zeljic/build_sqlite3_lib.md

Last active April 22, 2025 03:28
Show Gist options
  • Save zeljic/d8b542788b225b1bcb5fce169ee28c55 to your computer and use it in GitHub Desktop.
Save zeljic/d8b542788b225b1bcb5fce169ee28c55 to your computer and use it in GitHub Desktop.
Download ZIP
Build SQLite3 .lib file on windows
Raw
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

@liukuo362573
Copy link

thank you!

@danhiu
Copy link

danhiu commented Aug 15, 2024

You are so handsome！

@prajjwalsingh11
Copy link

thanks saviour

@Amitminer
Copy link

thankyou sir!

@BuckSevereSky
Copy link

Thank you, concise and clear and works perfectly.

@AustinBrown12
Copy link

Hello
When I download sqlite-amalgamation-3430100, there are several files.
sqlite
How to build static sqlite3.lib file on windows?

@AustinBrown12
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment