Friday, April 23, 2010

Getting started with #firebird and #lua on #ubuntu

I needed lua for a work related project and for database persistence i use firebird

So on ubuntu lucid lynx i have installed this way the Firebird Lua client

sudo apt-get install luarocks
sudo luarocks install fbclient

Tested with my local django db , Here is my test script for firebird connection



Then i wanted to insert some values
for that i have used exec_imediate and the interesting fact you must use double quote for insert statement otherwise you wil get Column unknown JACK if you try to put the name in single quote



The complete example would be with insert and read like this

No comments: