Installation
Quick Start
Install using vcpkg or Conan
You can install the latest release of sqlgen using either vcpkg or Conan.
Build using vcpkg
Alternatively, you can build sqlgen from source using vcpkg:
- Set up vcpkg:
git submodule update --init
./vcpkg/bootstrap-vcpkg.sh # Linux, macOS
./vcpkg/bootstrap-vcpkg.bat # Windows- Build the library:
cmake -S . -B build -DCMAKE_CXX_STANDARD=20 -DCMAKE_BUILD_TYPE=Release
cmake --build build -j 4 # gcc, clang
cmake --build build --config Release -j 4 # MSVCThis will build the static library. To build the shared library
add -DBUILD_SHARED_LIBS=ON -DVCPKG_TARGET_TRIPLET=... to the first line.
Run ./vcpkg/vcpkg help triplets to view all supported triplets.
Common triplets for shared libraries are x64-linux-dynamic,
arm64-osx-dynamic or x64-osx-dynamic.
Add -DSQLGEN_POSTGRES=ON to the first line to support PostgreSQL. Add -DSQLGEN_MYSQL=ON to support MySQL/MariaDB. Add -DSQLGEN_DUCKDB=ON to support DuckDB.
On Linux and macOS, you may need to install additional dependencies to get Postgres to compile:
sudo apt-get install autoconf bison flex # Linux (Ubuntu, Debian, ...)
brew install autoconf bison flex # macOSIf you want to build the tests, add -DSQLGEN_BUILD_TESTS=ON.
If you want to build ‘dry’ tests only (those that do not require a database connection), add -DSQLGEN_BUILD_DRY_TESTS_ONLY=ON.
- Include in your CMake project:
find_package(sqlgen REQUIRED)
target_link_libraries(your_target PRIVATE sqlgen::sqlgen)Build using Conan
You can also build sqlgen from source using Conan:
- Install Conan (assuming you have Python and pipx installed):
pipx install conan
conan profile detectFor older versions of pip, you can also use pip instead of pipx.
- Build the library:
conan build . --build=missing -s compiler.cppstd=gnu20This will build the static library. To build the shared library,
add -o */*:shared=True.
Add -o sqlgen/*:with_mysql=True to support MySQL/MariaDB.
- Include in your CMake project:
find_package(sqlgen REQUIRED)
target_link_libraries(your_target PRIVATE sqlgen::sqlgen)You can call conan inspect . to get an overview of the supported options.