Skip to content

Instantly share code, notes, and snippets.

@zeljic

zeljic/build_sqlite3_lib.md

Last active January 16, 2026 19:25
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save zeljic/d8b542788b225b1bcb5fce169ee28c55 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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

@AustinBrown12
Copy link

AustinBrown12 commented Apr 22, 2025

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

@0riginaln0
Copy link

0riginaln0 commented Jan 16, 2026

@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