How to build a visual studio CMake project using SQLite?

Question

C++ / C#

How to build a project for visual studio CMake Using SQLite3?

Answer 1

https://www.sqlite.org/download.html#amalgtarball
download from here sqlite-autoconf-3330000.tar.gz
run
x64 Native Tools Command Prompt for VS 2019

cd C:/sql
C:\sql>nmake /f Makefile.msc

similar to build tiff
nmake /f Makefile.vc
but it doesn't work for visual studio
https://progi.pro/kak-skompilirovat-curl-s-openssl...
build curl
open the downloaded project in Visual Studio (file - open CMake)

in the CMake settings set the path before ninja and files: EXE_SQLITE3, SQLITE_LIBRARY (.lib), SQLite3 include dir
save json
It doesn't work
How to include SQLite3 in CMake project?
I try this:
installed CMake, downloaded the project from github.com
for the project you need sqlite3
download 1 archive https://sqlite.org/sqlite-shell-win32-x86-3071300.zip
and the second archive for x64 https://www.sqlite .org/2020/sqlite-dll-win64-x64-3...
unzip all this into the C: / sql2 folder,
now go to the visual studio terminal
and run the command:

lib /MACHINE:X64 /DEF:"C:\sql2\sqlite3.def" /OUT:"C:\sql2\sqlite3.lib"

a .lib file should appear
download 3 archive: https://www.sqlite.org/2020/sqlite-amalgamation-33...
and unpack the contents in C:/sql2
now you need to start / parameters
in the search for "environment variables"


add as in the picture and check in cmd

now run Git Bash

go to the directory of the downloaded project, create the build folder there and go to it and
run the command:

cmake -DSQLITE3_INCLUDE_DIR=C:/sql2 -DSQLITE3_LIBRARY=C:/sql2/sqlite3.lib -DEXE_SQLITE3=C:/sql2/sqlite3.exe ..

for tiff and curl:

cmake -DSQLITE3_INCLUDE_DIR=C:/sql2 -DSQLITE3_LIBRARY=C:/sql2/sqlite3.lib -DEXE_SQLITE3=C:/sql2/sqlite3.exe -DCURL_INCLUDE_DIR=C:/curl/include -DCURL_LIBRARY=C:/curl/include/curl/libcurl-x64.dll -DTIFF_INCLUDE_DIR=C:/tiff2/libtiff -DTIFF_LIBRARY_RELEASE=C:/tiff2/libtiff/libtiff.lib ..

for curl, you need to drop everything from the folders into the include / curl folder and drop two files libcrypto, libssl version 1.4 into the include folder.
c in this post you can find how to install openssl https://stackoverrun.com/en/q/12876670
compile curl https://github.com/curl/curl
here all paths related to sqlite go to sql2 folder
SQLITE3_INCLUDE_DIR - .h files , .c
SQLITE3_LIBRARY - .lib file
EXE_SQLITE3 - the downloaded exe
will be built into the build folder and you can run the project in visual studio
Here are the compiled library files, but it's better to compile the
compiled files yourself