perl DBI & SQLite

[spx2]

im totally confused about SQLite.
i mean on windows i downloaded this small
exe and i could work with it and it stored,
files for every db i used.
on linux i just used cpan and made
"install DBI"
and
"install DBD::SQLite"
as root(seems otherwise i could not)
and now im trying to figgure out where does
SQLite store my data ?
for example lets take a certain module
ive tried
its just an honest question i cannot answer
also id like to read somewhere some tutorial
or guide on using DBI(wich ive read that should
be an universal interface to all databases,
including SQLite.
does SQLite have any daemon or server ?
because the usual first step in trying to do anything
would be to connect to the database like so
$dbh = DBI->connect("DBI:mysql:db_name:dbserver:2134",
"dbuser", "dbpass");
and i imagine there has to be some kind of
daemon application to provide login possibilities.
on windows i cant see how that could have been
possible as i have downloaded only 1 .exe and that
was all SQLite.
also there's like allot of modules on cpan on SQLite,
i dont know wich one to use?
DBI,DBI::SQLite,DBD::SQLite,App::Info::RDBMS::SQLite,
Rose::DB::SQLite,Rose:DB::SQLite,SQLite::DB.
so what im asking where do i start
to understand sqlite and where do i learn to
program sqlite with perl.
id appreciate if any of you monks who already
used sqlite with perl would give me some advice.
ok,i guess ive posed too much weird questions for one
day.

[Corion]

From http://sqlite.org:

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.

So SQLite does not have any server component. It stores the complete database in a file.

To use SQLite from Perl, you only need to install DBI and DBD::SQLite. All other modules are fancy stuff that provides mappings from objects to database rows or other fluff that is of little interest to you if you're just starting out with databases and Perl.

[shmem]

use DBI;
my $dbfile = 'database.db';      # your database file
my $dbh = DBI->connect(          # connect to your database, create if
+ needed
    "dbi:SQLite:dbname=$dbfile", # DSN: dbi, driver, database file
    "",                          # no user
    "",                          # no password
    { RaiseError => 1 },         # complain if something goes wrong
) or die $DBI::errstr;

my $table = 'test';
my @rows  = qw(id time data);
$dbh->do("create table $table (".join(',',@rows).')')
  or die $DBI::errstr;

Read the documentation of DBD::SQLite. It helps.

[bart]

now im trying to figgure out where does SQLite store my data ?

In a file. You name it (best using the absolute path) when you connect to the database, in the DBI->connect statement. If a file of that name doesn't exist in that location, it'll be created.

does SQLite have any daemon or server ?

The "server" is embedded in the DBD driver. In other words: the DBD module directly accesses/manipulates the data in that file.

also there's like allot of modules on cpan on SQLite, i dont know wich one to use?

Just plain DBD::SQLite. On Windows, if you're using ActivePerl and you don't have a compatible C compiler (it'll work with MinGW too), use PPM to install it.

Oh, I also wholeheartedly recommend getting and using SQLite browser, a free GUI app on SourceForge.

HTH. HAND.

[derby]

Check out the sqlite tutorial. The perl specific part is small and near the end but well done.

[Anonymous Monk]

Hello monks, I'm a newbie to Perl and I've been trying to write a script that will import a data file (XXX.out) into a table (XXX) in a SQLite databse, and
I would be very appreciative if someone could enlighten me please!
Everything was going great until I used

$db->do(".import XXX.out XXX);

which gave me this error:

DBD::SQLite::db do failed: near ".": syntax error(1) at dbdimp.c line 271 at ./new.pl line 13.

I tried using single quotes too, and backslashing the period, but nothing worked. The

$db->do("create table XXX (@colnames)");

line earlier in the code worked just fine. It also worked when rather than
using the .import function I instead used the INSERT function to just insert a few lines.
But somehow the .import function won't seem to work. (In fact
the .separator function also gave me the same problem, but I changed the data file so that I wouldn't have to use .separator). In fact, when I just go to sqlite myself and try .import XXX.out XXX it imports the XXX.out file into the XXX table just fine!
So the problem can't be with the XXX.out data file or the XXX table. But
somehow I just can't get it to work in my Perl script.
Can someone please shed some light on this? Thank you!

[perrin]

Please post this as a top-level question, not as a response to a really old question.

[Anonymous Monk]

OK. Sorry and thanks!