please make it work with GEN=ninja CORE_EXTENSIONS='httpfs;json;spatial' make

[cjbd]

hello, i need to build duckdb with extensions from source and statically link everything to my project, it'll be great if we can build this extension like httpfs and json from official document

i've installed dependencies (from ubuntu 24.04):

• libgeos-dev
• libproj-dev
• libgdal-dev

and tried GEN=ninja CORE_EXTENSIONS='httpfs;json;spatial' make, but stuck at below step

$ GEN=ninja CORE_EXTENSIONS='httpfs;json;spatial' make
mkdir -p ./build/release && \
cd build/release && \
cmake -G "Ninja" -DFORCE_COLORED_OUTPUT=1        -DENABLE_EXTENSION_AUTOLOADING= -DENABLE_EXTENSION_AUTOINSTALL= -DCORE_EXTENSIONS="httpfs;json;spatial" -DLOCAL_EXTENSION_REPO=""  -DOVERRIDE_GIT_DESCRIBE=""  -DCMAKE_BUILD_TYPE=Release ../.. && \
cmake --build . --config Release
-- git hash 8e52ec4395, version v1.2.1, extension folder v1.2.1
-- Extensions will be deployed to: /lab/duckdb/build/release/repository
-- Load extension 'httpfs' from https://github.com/duckdb/duckdb-httpfs @ 85ac466
-- Load extension 'spatial' from https://github.com/duckdb/duckdb-spatial @ 2905968
-- Load extension 'json' from '/lab/duckdb/extensions' @ v1.2.1
-- Load extension 'core_functions' from '/lab/duckdb/extensions' @ v1.2.1
-- Load extension 'parquet' from '/lab/duckdb/extensions' @ v1.2.1
-- Load extension 'jemalloc' from '/lab/duckdb/extensions' @ v1.2.1
CMake Warning at CMakeLists.txt:1319 (message):
  Extension 'httpfs' has a vcpkg.json, but build was not run with VCPKG.  If
  build fails, check out VCPKG build instructions in
  'duckdb/extension/README.md' or try manually installing the dependencies in
  /lab/duckdb/build/release/_deps/httpfs_extension_fc-src/vcpkg.json


CMake Warning at CMakeLists.txt:1319 (message):
  Extension 'spatial' has a vcpkg.json, but build was not run with VCPKG.  If
  build fails, check out VCPKG build instructions in
  'duckdb/extension/README.md' or try manually installing the dependencies in
  /lab/duckdb/build/release/_deps/spatial_extension_fc-src/vcpkg.json


CMake Deprecation Warning at build/release/_deps/spatial_extension_fc-src/CMakeLists.txt:1 (cmake_minimum_required):
  Compatibility with CMake < 3.5 will be removed from a future version of
  CMake.

  Update the VERSION argument <min> value or use a ...<max> suffix to tell
  CMake that the project does not need compatibility with older versions.


-- Find libraries path: '/lab/duckdb/build/release/deps/local/'
-- Building with network functionality
-- OpenSSL root dir hint: ''
-- Extensions linked into DuckDB: [httpfs, json, core_functions, parquet, jemalloc]
-- Extensions built but not linked: [spatial]
-- Tests loaded for extensions: [httpfs, spatial]
-- Configuring done (1.2s)
CMake Error: The following variables are used in this project, but they are set to NOTFOUND.
Please set them or make sure they are set and tested correctly in the CMake files:
SQLITE3_MEMVFS
    linked by target "spatial_loadable_extension" in directory /lab/duckdb/build/release/_deps/spatial_extension_fc-src
    linked by target "spatial_extension" in directory /lab/duckdb/build/release/_deps/spatial_extension_fc-src

-- Generating done (0.2s)
CMake Generate step failed.  Build files cannot be regenerated correctly.
make: *** [Makefile:323: release] Error 1