Skip to content

Instantly share code, notes, and snippets.

@zeljic

zeljic/build_sqlite3_lib.md

Last active February 21, 2025 04:19
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

@zeljic
Copy link
Author

zeljic commented Dec 19, 2023

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

@Leow12487
Copy link

Issue solved ,thank you @zeljic

@hunter2009pf
Copy link

thank you, sir~

@KerwinChina
Copy link

thank you

@thefox61
Copy link

thank you!

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

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