sqlite-amalgamation | The SQLite amalgamation mirror with cmake | Build Tool library

I want to use sqlite3 as a database interface for my c++, so i decided to start from this tutorial: https://www.tutorialspoint.com/sqlite/sqlite_c_cpp.htm

I have installed sqlite3 on my computer and add a environment variable for it, but when I try to compile a very simple program as the tutorial suggest by typing

I'm building a database in SQLite using R and Rmarkdown. Both the CRAN and development RSQLite packages are using SQLite version 3.30.1. Recently (1/2020) SQLite released v 3.31.1 which supports the creation of generated columns within tables. This would really "tie the room together". If anyone knows how to update the version used by RSQLite, I'm all ears. I'm running windows 10 and R version 3.5.

Ive downloaded SQLite v3.31.1 from https://www.sqlite.org/download.html. I'm not capable of building the data structures from the command line. I have used SQLite studio, however, its running on SQLite v 3.24.

I found this on https://www.r-project.org/nosvn/pandoc/RSQLite.html

I have the following schema:

I try to build native libraries (in my case SQLite) to add them to my Android project.

My problem: My Nexus7 with Android 6.0.1 tries to load it from the ../lib/arm/libsqlite3.so path. But this path doesn't exist.

From the beginning:

1. I downloaded the sqlite-amalgamation-3310100.zip

2. In this folder, I created a CMakeLists.txt file with this content: