lua-sqlite3
 

This is Lua-Sqlite3 release 0.4.1.
Lua-Sqlite3 is a sqlite3 wrapper for lua.
The lua-sqlite3_deb package does include lua and luac vresion 5.1.1 for ease of experimenting !
To learn more about lua-sqlite3 take a look in documentation.html.
Edit Makefile.cfg to match your environment.
Please note that this release is still alpha software. This mean that there exists a chance that function signatures and behavour will change in the future.
If you have suggestions, questions or feature request please feel free to contact me.
Michael Roth

------------------------- added by wangji 09/02/2007 :
./configure --with-lua-dir=/usr/local/lua-5.0
make all
make check
ldd libluasqlite3.so
/usr/local/lib/xvnkb.so (0xb7f72000)
linux-gate.so.1 => (0xffffe000)
libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0xb7efd000)
liblualib.so.5.0 => /usr/lib/liblualib.so.5.0 (0xb7eed000)
liblua.so.5.0 => /usr/lib/liblua.so.5.0 (0xb7ed8000)
libm.so.6 => /lib/libm.so.6 (0xb7eb3000)
libc.so.6 => /lib/libc.so.6 (0xb7d98000)
libX11.so.6 => /usr/lib/libX11.so.6 (0xb7cac000)
libdl.so.2 => /lib/libdl.so.2 (0xb7ca8000)
libpthread.so.0 => /lib/libpthread.so.0 (0xb7c56000)
/lib/ld-linux.so.2 (0x80000000)
libXau.so.6 => /usr/lib/libXau.so.6 (0xb7c53000)
libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0xb7c4d000)
make install
root@laixa:/usr/local/lib/lua# ls -ls
total 96
0 drwxr-xr-x 2 root root 48 2007-02-08 17:47 5.0
0 drwxr-xr-x 2 root root 80 2007-02-08 17:47 5.1
4 -rw-r--r-- 1 root root 1830 2007-02-09 10:49 libluasqlite3-loader.lua
64 -rw-r--r-- 1 root root 64681 2007-02-09 10:49 libluasqlite3.so
8 -rw-r--r-- 1 root root 5938 2005-06-02 20:43 luasql-sqlite3.lua
20 -rw-r--r-- 1 root root 19112 2005-09-15 01:22 sqlite3.lua
-------------------
for lua-5.1 do $./configure --with-lua-dir=/usr/local/lua-5.1 --with-lua-libdir=/usr/local/lua-5.1/lib
modify Makefile to suppress "-llualib" from the line containing LIBS as (liblualib non exixtent in lua-5.1)
LIBS := -lsqlite3 -llualib -llua -lm

download:
http://www.nessie.de/mroth/lua-sqlite3/lua-sqlite3-0.4.1.tar.gz

-----------------------------------

$make check
/usr/local/lua-5.1/bin/lua tests.lua
#### Test Suite with 39 Tests in 15 Test Cases loaded.
#### Running 'open_memory' (1 Tests)...
#### Running 'open' (1 Tests)...
#### Running 'Database Member Functions' (1 Tests)...
#### Running 'Statement Member Functions' (1 Tests)...
#### Running 'Basics' (4 Tests)...
#### Running 'Column Info Test' (1 Tests)...
#### Running 'Statement Tests' (13 Tests)...
#### Running 'Binding Tests' (3 Tests)...
#### Running 'Bug-Report Tests' (2 Tests)...
#### Running 'Driver Interface' (1 Tests)...
#### Running 'Connection Interface' (1 Tests)...
#### Running 'Simple connection usage' (1 Tests)...
#### Running 'Cursor Interface' (1 Tests)...
#### Running 'Simple cursor usage' (6 Tests)...
#### Running 'Transaction Tests' (2 Tests)...
#### Test Suite finished.
926 Assertions checked. All Tests passed!
--------------------------------------
$cd examples && lua order.lua
Invoice #1, Michael: 'Computer parts'
----------------------------------------
harddisc 89.90
floppy 9.99

Invoice #2, John: 'Somme food'
----------------------------------------
apples 2.79
pears 5.99
grapes 6.34
strawberries 4.12
tomatoes 6.17

Invoice #3, John: 'A new car'
----------------------------------------
Cybercar XL-1000 65000.00
A deb package is available here lua-sqlite3-0.4.1_i386.deb