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.

In reply to perl DBI & SQLite by spx2

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.