[Israel.pm] SQLite issue

Gabor Szabo szabgab at gmail.com
Sun Aug 13 08:22:13 PDT 2006


Oh and after some fighting I finally understood how to fetch the
version of the sqlite engine from DBD::SQLite:

~/work/yapcom$ perl -w -MDBI -e '$dbh =
DBI->connect("dbi:SQLite:dbname=dbfile"); print
$dbh->{sqlite_version}'
3.3.5

So in my case I might be using a Perl driver that is too modern
compared to the sqlite
executable supplied by my OS.

Gabor

On 8/13/06, Gabor Szabo <szabgab at gmail.com> wrote:
> The error messages shows up like this:
>
> ~/work/yapcom$ sqlite3 db/yapc.db
> SQLite version 3.2.8
> Enter ".help" for instructions
> sqlite> .schema
> Error: unsupported file format
> sqlite> .quit
>
>
> ~/work/yapcom$ perl -MDBD::SQLite -e'print $DBD::SQLite::VERSION'
> 1.12
>
> Gabor
>



More information about the Perl mailing list