Q: Compiling with SQLite on macOS

hebasto commented at 8:23 pm on November 25, 2020: member

On macOS 10.15.7 I’ve removed the previously installed sqlite

0brew uninstall sqlite

and brew list does not show it.

BUT I still able to run configure that prints with sqlite = yes, and to compile binaries with sqlite functionality.

I’m not a macOS expert, so the question is “Has macOS its own SQLite? If so, is this documented somewhere?”

jonasschnelli commented at 8:37 pm on November 25, 2020: contributor

Have you tried pkg-config --debug --libs sqlite3 to get some more information where it could be located? sqlite is by default installed on macOS (its also used for the Cocoa persistent frameworks). I very much assume that when you install Xcode the sqlite headers/libs come with it.

hebasto commented at 9:10 pm on November 25, 2020: member

 0% pkg-config --debug --libs sqlite3
 1Error printing enabled by default due to use of output options besides --exists, --atleast/exact/max-version or --list-all. Value of --silence-errors: 0
 2Error printing enabled
 3Adding virtual 'pkg-config' package to list of known packages
 4Looking for package 'sqlite3'
 5Looking for package 'sqlite3-uninstalled'
 6Reading 'sqlite3' from file '/usr/local/Homebrew/Library/Homebrew/os/mac/pkgconfig/10.15/sqlite3.pc'
 7Parsing package file '/usr/local/Homebrew/Library/Homebrew/os/mac/pkgconfig/10.15/sqlite3.pc'
 8  line>homebrew_sdkroot=/Library/Developer/CommandLineTools/SDKs/MacOSX10.15.sdk
 9 Variable declaration, 'homebrew_sdkroot' has value '/Library/Developer/CommandLineTools/SDKs/MacOSX10.15.sdk'
10  line>prefix=${homebrew_sdkroot}/usr
11 Variable declaration, 'prefix' has value '/Library/Developer/CommandLineTools/SDKs/MacOSX10.15.sdk/usr'
12  line>exec_prefix=/usr
13 Variable declaration, 'exec_prefix' has value '/usr'
14  line>libdir=${exec_prefix}/lib
15 Variable declaration, 'libdir' has value '/usr/lib'
16  line>includedir=${prefix}/include
17 Variable declaration, 'includedir' has value '/Library/Developer/CommandLineTools/SDKs/MacOSX10.15.sdk/usr/include'
18  line>
19  line>Name: SQLite
20  line>Description: SQL database engine
21  line>Version: 3.28.0
22  line>Libs: -L${libdir} -lsqlite3
23  line>Libs.private:
24Unknown keyword 'Libs.private' in '/usr/local/Homebrew/Library/Homebrew/os/mac/pkgconfig/10.15/sqlite3.pc'
25  line>Cflags:
26Path position of 'sqlite3' is 4
27Adding 'sqlite3' to list of known packages
28Package sqlite3 has -L /usr/lib in Libs
29Removing -L /usr/lib from libs for sqlite3
30 post-recurse: sqlite3
31 original: sqlite3
32   sorted: sqlite3
33adding LIBS_L string ""
34 post-recurse: sqlite3
35adding LIBS_OTHER | LIBS_l string "-lsqlite3 "
36returning flags string "-lsqlite3"
37-lsqlite3

jonasschnelli commented at 9:20 pm on November 25, 2020: contributor

@hebasto: looks like you still have a pkg-config file in your homebrew area /usr/local/Homebrew/Library/Homebrew/os/mac/pkgconfig/10.15/sqlite3.pc

fanquake commented at 6:11 am on November 26, 2020: member

“Has macOS its own SQLite? If so, is this documented somewhere?”

As @jonasschnelli has said, macOS ships with sqlite3 and it’s used by many macOS frameworks, both public and private. It’s also included as part of the macOS SDK. Are you asking about the presence of sqlite3 on macOS being documented in Apples docs somewhere, or in our docs?

hebasto commented at 11:43 am on November 29, 2020: member

@jonasschnelli @fanquake Mind looking into #20527?

jonasschnelli closed this on Dec 10, 2020

DrahtBot locked this on Feb 15, 2022

Q: Compiling with SQLite on macOS #20498