Skip to content

Instantly share code, notes, and snippets.

@zeljic
Last active January 16, 2026 19:25
Show Gist options
  • Select an option

  • Save zeljic/d8b542788b225b1bcb5fce169ee28c55 to your computer and use it in GitHub Desktop.

Select an option

Save zeljic/d8b542788b225b1bcb5fce169ee28c55 to your computer and use it in GitHub Desktop.
Build SQLite3 .lib file on windows

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

@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.

@0riginaln0
Copy link

@AustinBrown12
read more carefully 2-6 points.

Your folder will look like this
image
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

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