Q: Compiling with SQLite on macOS #20498

1. 
   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?”

2. 
   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.
3. 
   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
   

4. 
   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
5. 
   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?

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

   @jonasschnelli @fanquake Mind looking into #20527?
7. jonasschnelli closed this on Dec 10, 2020

   ---

8. DrahtBot locked this on Feb 15, 2022

Contributors
hebasto jonasschnelli fanquake