LuaSQLite3 0.8
 

News:

29 December 2022 - PtokaX 0.5.3.0 (20th anniversary edition) released...
11 April 2017 - PtokaX 0.5.2.2 released...
8 April 2015 Anti child and anti pedo pr0n scripts are not allowed anymore on this board!
28 September 2015 - PtokaX 0.5.2.1 for Windows 10 IoT released...
3 September 2015 - PtokaX 0.5.2.1 released...
16 August 2015 - PtokaX 0.5.2.0 released...
1 August 2015 - Crowdfunding for ADC protocol support in PtokaX ended. Clearly nobody want ADC support...
30 June 2015 - PtokaX 0.5.1.0 released...
30 April 2015 Crowdfunding for ADC protocol support in PtokaX
26 April 2015 New support hub!
20 February 2015 - PtokaX 0.5.0.3 released...
13 April 2014 - PtokaX 0.5.0.2 released...
23 March 2014 - PtokaX testing version 0.5.0.1 build 454 is available.
04 March 2014 - PtokaX.org sites were temporary down because of DDOS attacks and issues with hosting service provider.

Main Menu

LuaSQLite3 0.8

Started by PPK, 09 September, 2011, 09:09:23

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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.ptokax.org/files/Libs-240/LuaSQLite3-0.8-sqlite-3.7.7.1.7z
Binary x64: http://www.ptokax.org/files/Libs-240/LuaSQLite3-0.8-sqlite-3.7.7.1-x64.7z

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

Initializing:
require "lsqlite3"


This will register global sqlite3, more is in docs 8)
"Most of you are familiar with the virtues of a programmer. There are three, of course: laziness, impatience, and hubris." - Larry Wall

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://forum.ptokax.org/index.php?topic=8849.0 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

#3
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.ptokax.org/files/Libs-240/LuaSQLite3-0.8-sqlite-3.7.10.7z
Binary x64: http://www.ptokax.org/files/Libs-240/LuaSQLite3-0.8-sqlite-3.7.10-x64.7z

Source: http://www.ptokax.org/files/Libs-240/LuaSQLite3-0.8-sqlite-3.7.10-src.7z
"Most of you are familiar with the virtues of a programmer. There are three, of course: laziness, impatience, and hubris." - Larry Wall

PPK

Quote from: whitestatic on 01 February, 2012, 07:31:34
Used the sources from http://forum.ptokax.org/index.php?topic=8849.0 to generate the PXLua.lib file to compile LuaSQLite against.
PXLua.lib in that archive, you don't need to generate it ;)
"Most of you are familiar with the virtues of a programmer. There are three, of course: laziness, impatience, and hubris." - Larry Wall

whitestatic

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

Quote from: PPK on 01 February, 2012, 10:24:11
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 :-X
"Most of you are familiar with the virtues of a programmer. There are three, of course: laziness, impatience, and hubris." - Larry Wall

PPK

#7
New version for PtokaX 0.4.2.0 build 376 and higher.

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

This lib is compatible with PXLua 5.1.5, 5.2.0 and 5.2.1 ;)

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 ;)
"Most of you are familiar with the virtues of a programmer. There are three, of course: laziness, impatience, and hubris." - Larry Wall

SMF spam blocked by CleanTalk