How to install SQLite 3.49.0 using CMake and Visual Studio 2022 for Desktop

• Install Visual Studio 2022 Community and CMake using this guide: Installation of Visual Studio 2022 Community with CMake support
• Type sqlite download in the browser search field, press "Enter", and click on the first link:

• You will be moved to this page: https://www.sqlite.org/download.html
• Click on the "sqlite-amalgamation-3490000.zip" link:

• Move the downloaded archive somewhere, for example, in the "E:\libs" folder and "Extract Here":

• Create the "E:\libs\sqlite-3.49.0-msvc\win\debug" folder
• Create the "include" and "lib" folders inside of the "E:\libs\sqlite-3.49.0-msvc\win\debug" folder:

• Copy the "sqlite3.h" and "sqlite3ext.h" files from the "E:\libs\sqlite-amalgamation-3490000" folder to the "E:\libs\sqlite-3.49.0-msvc\win\debug\include" folder:

• Create the "src" folder inside of the "E:\libs\sqlite-amalgamation-3490000" folder:

• Drag and drop (or cut/paste) the "shell.c" and "sqlite3.c" files to the "src" folder:
• Create the "include" folder inside of the "E:\libs\sqlite-amalgamation-3490000" folder:

• Drag and drop (or cut/paste) the "sqlite3.h" and "sqlite3ext.h" files to the "include" folder:

• Create the "CMakeLists.txt" file inside of the "E:\libs\sqlite-amalgamation-3490000" folder:

• Copy and paste the following code to the "CMakeLists.txt" file:

cmake_minimum_required(VERSION 3.20)

project(sqlite3_lib)

# Set where the ImGui files are stored
set(SQLITE_PATH_INCLUDE "E:/libs/sqlite-amalgamation-3490000/include")
set(SQLITE_PATH_SRC "E:/libs/sqlite-amalgamation-3490000/src")

# Compile as static library 
file(GLOB SQLITE_SOURCES ${SQLITE_PATH_SRC}/*.c)
add_library("sqlite3" STATIC ${SQLITE_SOURCES})
target_include_directories("sqlite3" PUBLIC ${SQLITE_PATH_INCLUDE})

• Open CMD inside of the "E:\libs\sqlite-amalgamation-3490000" folder
• Copy and paste the following command to CMD to configure:

cmake -G "Visual Studio 17 2022" -S . -B dist

• Note. Configuration output:

-- Selecting Windows SDK version 10.0.22621.0 to target Windows 10.0.19045.
-- Configuring done (0.1s)
-- Generating done (0.1s)
-- Build files have been written to: E:/libs/sqlite-amalgamation-3490000/dist

• Double click on the "dist\sqlite3_lib.sln" file
• VS 2022 will be opened
• Press F7 to build
• Note. Build output:

Build started at 7:40 PM...
1>------ Build started: Project: ZERO_CHECK, Configuration: Debug x64 ------
1>1>Checking Build System
2>------ Build started: Project: sqlite3, Configuration: Debug x64 ------
2>Building Custom Rule E:/libs/sqlite-amalgamation-3490000/CMakeLists.txt
2>shell.c
2>sqlite3.c
2>Generating Code...
2>sqlite3.vcxproj -> E:\libs\sqlite-amalgamation-3490000\dist\Debug\sqlite3.lib
3>------ Skipped Build: Project: ALL_BUILD, Configuration: Debug x64 ------
3>Project not selected to build for this solution configuration 
========== Build: 2 succeeded, 0 failed, 0 up-to-date, 1 skipped ==========
========== Build completed at 7:40 PM and took 18.836 seconds ==========

• The "sqlite3.lib" file was generated here: "E:\libs\sqlite-amalgamation-3490000\dist\Debug\sqlite3.lib"
• Copy the "sqlite3.lib" file and paste it to the "E:\libs\sqlite-3.49.0-msvc\win\debug\lib" folder:

Building to Release

• Click on the "Debug" in VS:

• Select "Release":

• Press F7 to build
• Note. Build output:

Build started at 7:51 PM...
1>------ Build started: Project: ZERO_CHECK, Configuration: Release x64 ------
1>1>Checking Build System
2>------ Build started: Project: sqlite3, Configuration: Release x64 ------
2>Building Custom Rule E:/libs/sqlite-amalgamation-3490000/CMakeLists.txt
2>shell.c
2>sqlite3.c
2>Generating Code...
2>sqlite3.vcxproj -> E:\libs\sqlite-amalgamation-3490000\dist\Release\sqlite3.lib
3>------ Skipped Build: Project: ALL_BUILD, Configuration: Release x64 ------
3>Project not selected to build for this solution configuration 
========== Build: 2 succeeded, 0 failed, 0 up-to-date, 1 skipped ==========
========== Build completed at 7:52 PM and took 53.030 seconds ==========

• The "sqlite3.lib" file was generated here: "E:\libs\sqlite-amalgamation-3490000\dist\Release\sqlite3.lib"
• Copy the "sqlite3.lib" file and paste it to the "E:\libs\sqlite-3.49.0-msvc\win\release\lib" folder:

• Copy "include" folder from the "" folder:

• Paste the copied folders to the "E:\libs\sqlite-3.49.0-msvc\win\release" folder:

• Next guide: Setting up SQLite 3.49.0 in Visual Studio 2022 using CMake