Naive question on building wxsqlite3 through msys2

[easior]

Hi, I plan to do something with sqlite by using wxWidgets library on MS Windows. I found that wxSQLite3 is useful. However, I ran into a problem after I cloned the wxSQLite3 repository and built it. Specifically, I executed the following command lines in msys2 terminal:

$ cd build
$ mingw32-make

I got some errors:

==== Building wxsqlite3 (debug_win32) ====
wxsqlite3_version.rc
../src/wxsqlite3_version.rc:9: fatal error: when writing output to : Invalid argument
    9 |
      |
compilation terminated.
D:\Developer\msys64\mingw64\bin\windres.exe: can't open file `codes': No such file or directory
D:\Developer\msys64\mingw64\bin\windres.exe: preprocessing failed.
mingw32-make[1]: *** [wxsqlite3.make:259: obj/gcc/Win32/Debug/wxsqlite3/wxsqlite3_version.res] Error 1
mingw32-make: *** [Makefile:86: wxsqlite3] Error 2

I don't know how to resolve those errors.

[utelle]

Actually I have no idea why windres throws such an error message, especially, because there is no such file codes used in wxSQLite3. However, since windres complains about writing a file, it may help to instruct windres to use a temporary file. To do that try the following:

Adjust the makefile wxsqlite3.make by adding

RESFLAGS = --use-temp-file

before or after line 21

RESCOMP = windres

[easior]

Following your instruction, I resolved my problem. Let me take a note here:

$ pacman -S autoconf m4 automake-wrapper mingw-w64-x86_64-dlfcn mingw-w64-x86_64-wxWidgets mingw-w64-x86_64-sqlite3
$ autoreconf
$ mkdir msbuild && cd msbuild
$ MAKE="mingw32-make" ../configure
$ mingw32-make

Except for some trivial warnings, the library is successfully built.

If I have any time in the coming week, I would like to make a mingw package for wxsqlite3.

[utelle]

Except for some trivial warnings, the library is successfully built.

That's good news. You may show the warnings here. Unless they occur for the original SQLite source code, I'll try to fix them.

If I have any time in the coming week, I would like to make a mingw package for wxsqlite3.

Of course, you are welcome to do so. Thanks.

[easior]

I made a mistake. In fact, there is still something wrong in the library. Let me generate some log file. Before I installed mingw-w64-x86_64-dlfcn, I got errors:

$ mingw32-make
  CXX      samples/minimal.o
  CC       src/sqlite3mc_amalgamation.lo
cc1.exe: warning: command-line option '-fpermissive' is valid for C++/ObjC++ but not for C
  CXX      src/wxsqlite3.lo
  CXXLD    libwxcode_mswu_wxsqlite3-3.0.la

*** Warning: linker path does not have real file for library -ldl.
*** I have the capability to make that library automatically link in when
*** you link to this library.  But I can only do this if you have a
*** shared version of the library, which you do not appear to have
*** because I did check the linker path looking for a file starting
*** with libdl but no candidates were found. (...for file magic test)
*** The inter-library dependencies that have been dropped here will be
*** automatically added whenever a program is linked with this library
*** or is declared to -dlopen it.

*** Since this library must not contain undefined symbols,
*** because either the platform does not support them or
*** it was explicitly requested with -no-undefined,
*** libtool will only create a static version of it.
  CXXLD    samples/minimal.exe
libtool: link: warning: `-no-install' is ignored for x86_64-w64-mingw32
libtool: link: warning: assuming `-no-fast-install' instead
D:/Developer/msys64/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/10.3.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -ldl
collect2.exe: error: ld returned 1 exit status
mingw32-make: *** [Makefile:642: samples/minimal.exe] Error 1

After it is installed, the library is successfully built only with the following additional warnings

libtool: link: warning: `-no-install' is ignored for x86_64-w64-mingw32
libtool: link: warning: assuming `-no-fast-install' instead
  CXX      samples/treeview/foldertree.o
  CXX      samples/treeview/projectlist.o
  CXX      samples/treeview/treeviewapp.o
  CXX      samples/treeview/treeviewsample.o
  CXXLD    samples/treeview/treeview.exe
libtool: link: warning: `-no-install' is ignored for x86_64-w64-mingw32
libtool: link: warning: assuming `-no-fast-install' instead

However, I did these procedures on Windows 10 in another PC, it gave rises to many strip errors caused by wrong character set. I can't figure out why.

[easior]

For msys2 part, there is less progress to make a mingw package. Fortunately, a Homebrew formula (cf. https://raw.githubusercontent.com/easior/homebrew-wunderland/master/wxsqlite3.rb) has been made by me.

[utelle]

I have a few comments regarding the homebrew formula:

1. Homepage link
   Please use https://utelle.github.io/wxsqlite3.
2. License
   The license is not pure LGPL-3.0+, but LGPL-3.0+ WITH WxWindows-exception-3.1. This is an important difference when using the library for a commercial application, because it allows to statically link the library without causing license issues.
3. Dependencies
   wxSQLite3 does not depend on SQLite3, at least not in the sense that SQLite3 has to be installed as a prerequisite. wxSQLite3 includes the source code amalgamation of SQLite3 Multiple Ciphers, which in turn is based on a the patched source code amalgamation of SQLite3.

Regarding the linker error you experienced before installing mingw-w64-x86_64-dlfcn I think another solution could be to simply remove the linker option -ldl, when building with msys. In fact, the autoconf/automake build files are meant to be used on non-Windows platforms and may need adjustments when used with msys.

Regarding the linker warning about the linker option -no-install it is most likely that simply replacing it by -no-fast-install inMakefile.am would be sufficient.