SQLite best library to use

["g.lister" <g.lister@...>]

Hi guys,

I would like to know what is the best library to use with Lua for SQLite 
3. I have installed LuaSQL on my Ubuntu 12.10 and I am having some issues:

ua: system.lua:56: LuaSQL: file is encrypted or is not a database
stack traceback:
	[C]: in function 'assert'
	system.lua:56: in main chunk
	[C]: ?

from this:

assert(conn:execute("select * from users"))

when I check the version:

gs@flipper:~/Lua/mystuff$ file test.db
test.db: SQLite 2.x database

I am thinking it is something really simple since I am a newbie, like 
the version of the db is different from the one in LuaSQL but cannot dig 
it out in the docs: http://www.keplerproject.org/luasql/ What version is 
supported by the driver I mean.

Also I'm a bit confused as to what version is actually used on my system 
as I think the CLI client has it is own version:

gs@flipper:~/Lua/mystuff$ sqlite -version
2.8.17

But the package manager thingy reports 3.

Is the lua-sqlite3 library the preferred way? or is it in fact the same 
as the front end in the docs mentions that such an interface is provided 
in addition to the full functions SQLite specific one.

What do you guys use?
TIA
George