We update the Firebird CMake files and built and run Firebird on Win, Linux and macOS

[Sergey Khalyutin]

We update the Firebird CMake files and built and run Firebird using CMake+Clang(under VSCode IDE) on Windows, Linux(Ubunta Gnome and Suse KDE), and MacOS.

We would like to contribute our corrections to the overall project.

We are targeting to achieving the ability to assemble a Firebird in three steps:

1. install msys2 on Windows or homebrew for macOS
2. clone Firebird from GitHub
3. run CMake.

We also planning to wrote up instructions on this matter and make GitHub action for automatic build.

During the full rebuild Firebird, we discovered and fixed several unexpected, non-critical compilation errors in the C++ code.

We understand the responsibility involved in making changes to the current source code, and therefore have broken the process into separate PRs, each of which, in our view, should not raise fundamental questions.

The first three PRs:

https://github.com/FirebirdSQL/firebird/pull/8893
https://github.com/FirebirdSQL/firebird/pull/8887
https://github.com/FirebirdSQL/firebird/pull/8882

The first of them has been accepted, and the others are pending. We are preparing about ten more corrections... (not fount #include files,  c++20 standard error etc.) Do I need to open a ticket about this?


It would be much easier for us to debug the result of the CMake build if these and subsequent fix to the C++ source code had already been accepted into the project :), or if we understood that they would not be accepted  :( ...

Fixing CMake files is interrelated and requires a complex commit. But since this isn't working now, the risk of breaking anything is minimal.

[Sergey Khalyutin]

The pull request for building the FirebirdSQL project using CMake+Clang is complete.  https://github.com/FirebirdSQL/firebird/pull/9111

We thank all project participants for their support. :)

Build FirebirdSQL project with CMake+CLang only (win, lin, osx for amd64 and arm64 ) (except icu4c win prebuild with MSBuild+MSVC)

Build possible as CMake project and sub-project both.

CLI build command in ./builds/cmake/BuildCommandCLI.txt, result zip-forder make in ./distr .

Successful build here: https://github.com/notesoft/SQLfb/actions/runs/30694701552

We plan to support and expand the CMake+CLang build in the future.

The current goal is to minimize the overhead of project builds by unifying the process.

The main goal is to increase the project's popularity by reducing the entry point for new advanced users who need to have their own fork/derivative of industrial open source SQL-server. (like us)