How to build this on Windows 10

[baristar]

Hello!
The guideline provided here seems to work on Linux (or Ubuntu).
I tried to connect maria-db from Octave on Windows 10.
Is it possible to build mex files for Octave on Windows 10?
Thanks
Joohwa Lee

[markuman]

In general, it should be possible. See: https://mariadb.com/kb/en/compiling-connectorc/

You need cmake and a C compiler.

AdHoc I've no Windows available. But I try to test it in the cloud. But be aware, I've no windows experiences at all.

[markuman]

Basically you need to install the Mariadb C/C++ Connector library and do from octave

 mkoctfile --mex -I"C:/Program Files/MariaDB/MariaDB Connector C 64-bit/include" -lmysqlclient -lz -lm -ldl -lssl -lcrypto mariadb.c

But this results in some mingw32 errors.

I've absolutely no idea about windows.
I highly recommend to use the WSL and run octave from there. From that point it should be easy to use mex-mariadb.

Another try is mingw. Start with mingw-get https://osdn.net/projects/mingw/releases/p15522
and install from there all necessary build dependencies (gcc, openssl (bin + lib)).
Then you can try to compile mex-mariadb from shell using gcc.exe.
The Makefile https://github.com/markuman/mex-mariadb/blob/master/Makefile offers some examples how to compilate directly with gcc.

But again - I've absolutely no idea about windows.

[baristar]

Thank you markuman for your kind guide. I spent several days to get ideas.
I installed the following:

• C & C++ Connectors
• cmake
• c compiler (WinGW-w64 for 32 and 64 bit Windows)
  I tried, then, in Octave (latest version as of today)
• mkoctfile --mex -I"C:/Program Files/MariaDB/MariaDB Connector C 64-bit/include" -lmysqlclient -lz -lm -ldl -lssl -lcrypto mariadb.c

I got the following errors

• cannot find -lmysqlclient
• cannot find -dl
• cannot find -lssl
• cannot find -lcrypto

I will try some more to get over.
Joohwa