On macOS 10.15.7 I've removed the previously installed sqlite
brew 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?"
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.
% pkg-config --debug --libs sqlite3
Error printing enabled by default due to use of output options besides --exists, --atleast/exact/max-version or --list-all. Value of --silence-errors: 0
Error printing enabled
Adding virtual 'pkg-config' package to list of known packages
Looking for package 'sqlite3'
Looking for package 'sqlite3-uninstalled'
Reading 'sqlite3' from file '/usr/local/Homebrew/Library/Homebrew/os/mac/pkgconfig/10.15/sqlite3.pc'
Parsing package file '/usr/local/Homebrew/Library/Homebrew/os/mac/pkgconfig/10.15/sqlite3.pc'
line>homebrew_sdkroot=/Library/Developer/CommandLineTools/SDKs/MacOSX10.15.sdk
Variable declaration, 'homebrew_sdkroot' has value '/Library/Developer/CommandLineTools/SDKs/MacOSX10.15.sdk'
line>prefix=${homebrew_sdkroot}/usr
Variable declaration, 'prefix' has value '/Library/Developer/CommandLineTools/SDKs/MacOSX10.15.sdk/usr'
line>exec_prefix=/usr
Variable declaration, 'exec_prefix' has value '/usr'
line>libdir=${exec_prefix}/lib
Variable declaration, 'libdir' has value '/usr/lib'
line>includedir=${prefix}/include
Variable declaration, 'includedir' has value '/Library/Developer/CommandLineTools/SDKs/MacOSX10.15.sdk/usr/include'
line>
line>Name: SQLite
line>Description: SQL database engine
line>Version: 3.28.0
line>Libs: -L${libdir} -lsqlite3
line>Libs.private:
Unknown keyword 'Libs.private' in '/usr/local/Homebrew/Library/Homebrew/os/mac/pkgconfig/10.15/sqlite3.pc'
line>Cflags:
Path position of 'sqlite3' is 4
Adding 'sqlite3' to list of known packages
Package sqlite3 has -L /usr/lib in Libs
Removing -L /usr/lib from libs for sqlite3
post-recurse: sqlite3
original: sqlite3
sorted: sqlite3
adding LIBS_L string ""
post-recurse: sqlite3
adding LIBS_OTHER | LIBS_l string "-lsqlite3 "
returning flags string "-lsqlite3"
-lsqlite3
@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
"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?
@jonasschnelli @fanquake Mind looking into #20527?