How to add SQLite into your VS project as Static Library

sqlite_static_cpp.md

I assume that you already created C++ Win32 project where you want to include SQLite.

1. Navigate to https://www.sqlite.org/download.html and download latest amalgamation source version of SQLite.
2. Extract all the files into your project directory, or your include path, or separate path that you will add/added as include path in your project properties.
3. Run Developer Command Prompt for VS **** which is usually available at Start -> Programs -> Visual Studio **** -> Visual Studio Tools.
4. Navigate with command prompt to that directory where we extracted our SQLite.
5. Run next command to compile: cl /c /EHsc sqlite3.c
6. Run next command to create static library: lib sqlite3.obj
7. Open properties of your project and add sqlite3.lib to Linker -> Input -> Additional Dependencies.

Now you ready to include and use sqlite3.h in your project.

If anybody gets unresolved reference linker errors when trying to use the sqlite library, make sure that the bitness of the developer command prompt matches your target platform. It ran in 32 bit mode by default for me which I didn't realize at the time.

Thanks for this guide, it works perfectly.

Worked perfectly thank you!

How would i go about doing this working on a windows application on linux?