using sqlite3 with lua

Question

I'm trying to use sqlite3 with lua (am already using c++, but I'm a n00b with lua- I read this) but I'm getting the following when trying to build the library or whatever:

C:\lib\lsqlite3-7>mingw32-make
process_begin: CreateProcess(NULL, pkg-config --version, ...) failed.
makefile:53: *** windows32.  Stop.

I'm not at all surprised at a makefile failing but I can't do them (is it spaces or tabs? where is it they have to go?), I would have thought there was a binary for windows?

Any simple answers appreciated. I haven't got the time to learn make or install cygwin or whatever.

Answer 1

You might consider using LuaSQL as your wrapper instead, since it is already included in the Lua for Windows package and so it is likely already on your system. It includes support for SQLite3 among other databases.

It does look like you are trying to build the latest release of lsqlite3, but that this release was not packaged to be easily built on or for Windows. I didn't attempt to track down a binary since LuaForge only has a source package. It looks like building it successfully will require manually editing the Makefile, and then running the Makefile under either MSYS or Cygwin so that the *nix utilities it assumes exist are available to it.