Sqlite3 Mac Library
Introduction
Jan 28, 2020 SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects. SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside. At the time of this writing, the latest version is sqlite-jdbc-3.27.2.1.jar. The JAR file includes both Java class files and SQLite binaries for Mac OX S, Linux, and Windows, Both 32-bit and 64-bit. SQLite connection strings. The SQLite JDBC driver allows you to load an SQLite database from the file system using the following connection string.
If you want to write a C++ program that utilizes Sqlite3 you will need to takean extra step in the compile and link process in order to compile Sqlite3 with theC compiler (gcc), and then your C++ program with the C++ compiler (g++)If you try to compile Sqlite3 with g++ it will error.
For this example, I am using g++ and gcc to compile. I tested this in Windows 10 with MinGW64, but it should also work in Linux and Mac.
If you want to learn more about using SQLite3, check out my other tutorials:
- All SQLite tutorials of mine at https://www.devdungeon.com/tags/sqlite
Install Mingw
I am using the 64-bit version of MinGW downloaded from http://mingw-w64.org/doku.php/download/mingw-builds which links to a Sourceforge download.
After installing, add the MinGW bin directory to your PATH environment variable. For example:
This will put gcc and g++ in your PATH.
Obtain Sqlite3 source code
Download Sqlite3 source code from https://www.sqlite.org/download.html.
Download the file labeled amalgamation (e.g. https://www.sqlite.org/2019/sqlite-amalgamation-3300100.zip) and then extract the zip file. It will contain some .c and .h files.
To compile Sqlite3 by itself as the standalone executable application, run:
To compile the object file so you can later link it with a C++ program compiled using g++, firstcompile only to get the object file:
Then compile your .cpp file with g++, linking it to the sqlite3.o file.Here is an example C++ file that will output the SQLite version and create an empty database file.
Learn more about the API and what functions are available at https://www.sqlite.org/c3ref/intro.html or look inside the sqlite3.h file.
When you first start using the app, it offers to look for your photos on the current device, on an external drive, and even on your Facebook.Once all the photos you’ve taken in your lifetime are imported, Mylio organizes into a variety of views. Mylio: A free photo manager appIf you’ve been meaning to consolidate your photos in one place for years, will help you do just that. At this point, it’s just a really good piece of photo management software. 
Once you have the sqlite3.o object file to link against (statically), and you have your main.cpp file, you can compile and link with the following command:
As a trusted tech blog, AWT provides opinion and analysis on the news in addition to the facts. 
Our staff consists of experienced writers who live and breathe Apple products every day.Apple World Today is a trusted source for news, information and analysis about Apple and its products. Our readership is made up of new users, intermediate and business users and advanced users.
Be sure to set the include directory with -I so it knows where to find the sqlite3.h file.
Sqlite3 Mac
After compiling and linking you should have an a.exe that will print out the SQLite version and generate the empty database file.
Conclusion
After following these steps you should be able to compile a C++ application that uses the C library SQLite3 using gcc and g++.
References
Mcmaster Library
- All SQLite tutorials of mine at https://www.devdungeon.com/tags/sqlite