MySQL workbench

well still the goto tool for workbenching.

Sadly not on trixie, compile yourself! Grab a release tar, like 8.0.42

sudo apt install -y   build-essential   cmake   default-libmysqlclient-dev   qtbase5-dev   qtchooser   qt5-qmake   qtbase5-dev-tools   libzip-dev   libgnomecanvas2-dev   libcurl4-openssl-dev   libsqlite3-dev   libgtk-3-dev   pkg-config   libprotobuf-dev   protobuf-compiler   libboost-all-dev   libglib2.0-dev   libgdk-pixbuf-2.0-dev   libsdl1.2-dev

cmake will complain a lot

cmake . -DCMAKE_BUILD_TYPE=Release

ANTLR4:

apt install libantlr4-runtime-dev

youll most likely need the official mysql repo:

wget https://dev.mysql.com/get/mysql-apt-config_0.8.34-1_all.deb
dpkg -i mysql-apt-config_0.8.34-1_all.deb 
apt update

cppconn

apt install libmysqlclient-dev libmysqlcppconn-dev

you need to patch build/cmake/Modules/FindMySQLCppConn.cmake, line ~25:

if (MySQLCppConn_INCLUDE_DIRS AND MySQLCppConn_LIBRARIES)
# Already in cache, be silent
set(MySQLCppConn_FIND_QUIETLY TRUE)
endif ()

#find_path(MySQLCppConn_INCLUDE_DIR NAMES mysql_connection.h PATHS /usr/include /usr/local/include)
find_path(MySQLCppConn_INCLUDE_DIR NAMES mysql_connection.h PATHS /usr/include /usr/include/mysql-cppconn/jdbc/ /usr/include/jdbc /usr/local/include /usr/local/include/jdbc)

SET(MySQLCppConn_NAMES mysqlcppconn)

if these dont work find / -iname mysql_connection.h

sqlite

apt install libvsqlitepp-dev

gdal

apt install libgdal-dev

this might get removed somewhere later, reinstall this during make!

ssh

apt install libssh-dev

rapidjson

apt install rapidjson-dev

odbc

apt install unixodbc-dev

now rerun cmake with:

cmake . -DCMAKE_BUILD_TYPE=Release -DUSE_UNIXODBC=ON

libsecret

apt install libsecret-1-dev

will still break due to missing antlr4 jar. Check in CMakeLists.txt | grep ANTLR_JAR_FILENAME

--> set(ANTLR_JAR_FILENAME "antlr-4.13.2-complete.jar")

download this jar to /tmp:

wget https://www.antlr.org/download/antlr-4.13.2-complete.jar -o /tmp/antlr-4.13.2-complete.jar

you also need to compile the correct runtime version.

git clone https://github.com/antlr/antlr4
git checkout tags/4.13.2

you find the runtime in runtime/cpp, it will just make and make install fine.

The libs are now in /usr/local/include, so add this new path too:

rerun cmake with

cmake . -DCMAKE_BUILD_TYPE=Release -DUSE_UNIXODBC=ON -DWITH_ANTLR_JAR=/tmp/antlr-4.13.2-complete.jar -DANTLR4_INCLUDE_DIR=/usr/local/include