Looking for a good SQLite Lua library. I found LuaSQLite3 but trying to figure out how to use it in Lua. I've created DLL's to expose functions to Lua before with RakNet (a networking library), but can't see how this SQLite would work. This seems to be setup to compile for non-Windows machines and I would need it for Windows. I can create a DLL but not following how it works.
The examples that come with it simply say require("lsqlite3") at the top of the files, but I don't know where that Lua file is. The C code would create the DLL that I would expect that lsqlite3 would load in because I'm pretty sure require() doesn't load a DLL as when I did my RakNet DLL I had to use package.load() I believe it was. So lsqlite3 must be a Lua file, but I don't see it in the downloaded package. Maybe I'm blind :)
Any ideas?
I pulled the C source file into a new Visual Studio Express 2010 DLL project. Brought in Lua source and sqlite source and compiled the DLL. That worked all well and so I have a lsqlite3.dll file. When I put require("lsqlite3") in my Lua project I get an error from Lua saying it can't open the file. The file is in the same dir as my lua interpreter.
