SQLite Forum

compiling extensions for Windows x64 with mingw-w64
Specifically I am trying to compile the [CSV virtual table extension][1]. I followed the basic instructions [here][2] for mingw gcc, though I am using mingw-w64 gcc.

It compiles fine, but then gives this error trying to load it (via python 3.8 x64 SQLite3 library):  `The specified procedure could not be found`

I have read [this similar question on Stack Overflow][3], but I do not think it applies here as the CSV source does have the proper template for a SQLite extension and I have built it successfully in the past as a 32-bit DLL using mingw.

Has anyone successfully used mingw-w64 to build SQLite extensions or should I be looking at another compiler?

[1]: https://www.sqlite.org/csv.html
[2]: https://www.sqlite.org/loadext.html
[3]: https://stackoverflow.com/questions/52266158/sqlite3-extension-functions-the-specified-module-could-not-be-found