Re: SQLite best library to use

["M. Edward (Ed) Borasky" <znmeb@...>]

Is the file compressed?

On Wed, Sep 26, 2012 at 12:15 PM, g.lister <g.lister@nodeunit.com> wrote:
> 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
>



-- 
Twitter: http://twitter.com/znmeb; Computational Journalism Publishers
Workbench: http://j.mp/QCsXOr

How the Hell can the lion sleep with all those people singing "A weem
oh way!" at the top of their lungs?