Questions

[mythrz]

1. Do you have a roadmap, final-features, main goals, OS-targets, dates for what will come with sqlgen version 1.0?

2. I am having trouble getting started with your project on Linux. Do you have a forum, social media, community, discussions panel... where I can ask some questions and get some help troubleshooting?

3. Can the entry-point to test sqlgen be improved?

   • Maybe videos, tutorials, sample-projects with all the necessary dependencies, libs availability on pacman/apt/dnf package managers.
   • I still haven't figured out how to make this work...

4. Has the overall community or scientific community reviewed and analysed your work so far?

5. Is sqlgen currently being used/applied at any company, on a production level to reinforce your commitment, security and trust on product?

6. Is this project maintained or part of some (non-profit) organisation, company, group, ... ?

ty4the hard work on bringing such a cool c++ open source project to life (:

[liuzicheng1987]

Hi @mythrz,

1. I think that in terms of functionality the main goals have been reached. However, it might be a good idea to wait a bit longer until we give it 1.0.

2, 3. Have you followed the installation instructions in the README? Just to be sure, I followed them again and I was able to get it running on Linux in under 5 min or so, just by copying and pasting from the instructions. Moreoever, we have Github Action pipelines to test the library in all kinds of settings. For your convenience, here are the steps:

ubuntu@dev:~$ git clone https://github.com/getml/sqlgen.git
ubuntu@dev:~$ sudo apt-get install autoconf bison flex # Linux (Ubuntu, Debian, ...)
ubuntu@dev:~$ cd sqlgen/
ubuntu@dev:~/sqlgen$ git submodule update --init
ubuntu@dev:~/sqlgen$ cmake -S . -B build -DCMAKE_CXX_STANDARD=20 -DCMAKE_BUILD_TYPE=Release
ubuntu@dev:~/sqlgen$ cmake --build build -j 4  # gcc, clang

If you have any specific problems and something isn't working the way it is documented, please open an issue and explain your problems at greater detail.

4., 5., 6. We are certainly using it in our own projects and I know of some others who are using it as well. This being open-source, though, I cannot give you any exact numbers. However, we are certainly maintaining it.

[mythrz]

Here is my test on archlinux eos. The readme includes all of the steps I done; the rest is the code itself.
https://github.com/mythrz/CodeFirstCppDB_sqlgen/tree/main#

Your sqlgen project is configuring and building correctly. I took your suggestion and adapted it to my OS. In isolation, that appears to be working.

The error occurs when I configure my own project with cmake, and my manually-installed-system-packages. When I try to configure I get this

cmake -S . -B build -DCMAKE_BUILD_TYPE=Release

CMake Error at extern/sqlgen/CMakeLists.txt:136 (find_package):
  Could not find a package configuration file provided by
  "unofficial-sqlite3" with any of the following names:

    unofficial-sqlite3Config.cmake
    unofficial-sqlite3-config.cmake

  Add the installation prefix of "unofficial-sqlite3" to CMAKE_PREFIX_PATH or
  set "unofficial-sqlite3_DIR" to a directory containing one of the above
  files.  If "unofficial-sqlite3" provides a separate development package or
  SDK, be sure it has been installed.


-- Configuring incomplete, errors occurred!

sqlgen/CMakeLists.txt is hardcoded to get packages using vcpkg or conan only. It could/should try to find the libs on the system?
Why the hard-coded-dependency on a "foreign" package manager, when the system have perfectly reliable packages?

if (SQLGEN_SQLITE3 OR SQLGEN_CHECK_HEADERS)
    list(APPEND SQLGEN_SOURCES src/sqlgen_sqlite.cpp)

    if (SQLGEN_USE_VCPKG)
        if (NOT TARGET unofficial-sqlite3)
            find_package(unofficial-sqlite3 CONFIG REQUIRED)
        endif()
        target_link_libraries(sqlgen PUBLIC unofficial::sqlite3::sqlite3)
    else()
        if (NOT TARGET unofficial-sqlite3)
            find_package(SQLite3 CONFIG REQUIRED)
        endif()
        target_link_libraries(sqlgen PUBLIC SQLite::SQLite3)
    endif()
endif()

[mythrz]

Currently configuring and building on EOS without the vcpkg manager. Havent create the DB yet, but looks promising.
https://github.com/mythrz/CodeFirstCppDB_sqlgen/tree/main#

cmake_minimum_required(VERSION 3.23)
project(SqlGenIsolationTest LANGUAGES CXX)

set(CMAKE_CXX_STANDARD 20)
set(CMAKE_CXX_STANDARD_REQUIRED ON)

# NOT using vcpkg
set(SQLGEN_USE_VCPKG OFF CACHE BOOL "" FORCE) 

# reflect-cpp (Submodule)
add_subdirectory(extern/reflect-cpp)
set(reflectcpp_DIR "${CMAKE_CURRENT_BINARY_DIR}" CACHE PATH "" FORCE)
file(WRITE "${CMAKE_CURRENT_BINARY_DIR}/reflectcppConfig.cmake" "")

# sqlite3 (System)
find_package(SQLite3 REQUIRED)
if(NOT TARGET SQLite::SQLite3)
    add_library(SQLite::SQLite3 INTERFACE IMPORTED)
    target_link_libraries(SQLite::SQLite3 INTERFACE SQLite3::SQLite3)
endif()
set(SQLite3_DIR "${CMAKE_CURRENT_BINARY_DIR}" CACHE PATH "" FORCE)
file(WRITE "${CMAKE_CURRENT_BINARY_DIR}/SQLite3Config.cmake" "include_directories(\"${SQLite3_INCLUDE_DIRS}\")")

# sqlgen (submodule)
set(SQLGEN_BUILD_TESTS OFF CACHE BOOL "" FORCE)
set(SQLGEN_SQLITE3 ON CACHE BOOL "" FORCE)
add_subdirectory(extern/sqlgen)

# googleTest (submodule)
set(INSTALL_GTEST OFF CACHE BOOL "" FORCE)
add_subdirectory(extern/googletest)

# code & tests
add_executable(unit_tests 
    tests/test_main.cpp
)

target_include_directories(unit_tests 
    PRIVATE 
        ${CMAKE_CURRENT_SOURCE_DIR}/src
)
target_link_libraries(unit_tests 
    PRIVATE 
        sqlgen::sqlgen 
        GTest::gtest_main
)

Will do some more tests later.