LuaSQLite3 0.8

[PPK]

LuaSQLite3 with SQLite 3.7.7.1 for PtokaX 0.4.1.2 build 240 and higher (Lua 5.1.4 only).

Homepage: http://lua.sqlite.org/

Binary: http://www.czdc.org/PtokaX/Libs-240/LuaSQLite3-0.8-sqlite-3.7.7.1.7z
Binary x64: http://www.czdc.org/PtokaX/Libs-240/LuaSQLite3-0.8-sqlite-3.7.7.1-x64.7z

Source: http://www.czdc.org/PtokaX/Libs-240/LuaSQLite3-0.8-sqlite-3.7.7.1-src.7z

Initializing:

Code: [Select]

require "lsqlite3"

This will register global sqlite3, more is in docs

[whitestatic]

Is there any chance somebody could build a copy of this with FTS3 & FTS4 support? (http://www.sqlite.org/fts3.html#section_2)

[whitestatic]

Just gave it a go myself and failed miserably. Used the sources from http://board.ptokax.ch/index.php/topic,8849.0.html to generate the PXLua.lib file to compile LuaSQLite against. Everything compiled OK but I could not require() it from a LUA script (the DLL in the first post works fine for this script). It complained about PXLua.dll missing an entry point for create_metatable or some such function. So I replaced the PXLua.dll in the PtokaX folder with the one I had compiled from the sources, but then PtokaX failed to start.

If somebody who actually knew what they were doing could compile this that would be awesome.

I'm running PtokaX version 0.4.2.0 (build 241) if that makes a difference.

[PPK]

Updated LuaSQLite3 with SQLite 3.7.10 and enabled FTS3 & FTS4 for PtokaX 0.4.1.2 build 240 and higher (Lua 5.1.4 only).

Homepage: http://lua.sqlite.org/

Binary: http://www.czdc.org/PtokaX/Libs-240/LuaSQLite3-0.8-sqlite-3.7.10.7z
Binary x64: http://www.czdc.org/PtokaX/Libs-240/LuaSQLite3-0.8-sqlite-3.7.10-x64.7z

Source: http://www.czdc.org/PtokaX/Libs-240/LuaSQLite3-0.8-sqlite-3.7.10-src.7z

[PPK]

Used the sources from http://board.ptokax.ch/index.php/topic,8849.0.html to generate the PXLua.lib file to compile LuaSQLite against.

PXLua.lib in that archive, you don't need to generate it

[whitestatic]

Thats awesome, thanks. I've just had a play with it and it works beautifully .

PXLua.lib in that archive, you don't need to generate it

I tried linking with that, but it failed to build - complained about a number of unknown Lua functions. Hence why I tried building my own. Not sure what was going on there ?

Thanks for all your work.

[PPK]

Maybe you used different compiler or some different compiler configuration

[PPK]

New version for PtokaX 0.4.2.0 build 376 and higher.

Binary: http://www.czdc.org/PtokaX/Libs-376/LuaSQLite3-0.8-sqlite-3.7.11.7z
Binary x64: http://www.czdc.org/PtokaX/Libs-376/LuaSQLite3-0.8-sqlite-3.7.11-x64.7z
Source: http://www.czdc.org/PtokaX/Libs-376/LuaSQLite3-0.8-sqlite-3.7.11-src.tar.gz

This lib is compatible with PXLua 5.1.5 and PXLua 5.2.0

Update 8/May/2012:

• Fixed: With Lua 5.2 lib now remain on top of stack after require, to restore Lua 5.1 behavior where lib was possible to load like local sqlite3 = require "lsqlite3"
• Changed: Source is now packed with tar.gz to make it more friendly with non-windows OS