Home > Archive > PERL Beginners > February 2006 > SQLite 3
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Octavian Rasnita 2006-02-27, 6:58 pm |
| Hi,
Is there a perl module for SQLite3?
Thanks.
Teddy
| |
|
|
| Paul Lalli 2006-02-27, 6:58 pm |
| Octavian Rasnita wrote:
> Is there a perl module for SQLite3?
When you're looking for modules, http://search.cpan.org is the place to
go.
At that site, we find the DBD::SQLite module,
http://search.cpan.org/~msergeant/DBD-SQLite-1.11/
Browsing the distribution, we find the Changes file, which contains
this entry:
1.10
- Fix Unicode support (DOMQ)
- Support usleep on all Linux (inc. debian) (DOMQ)
- Upgrade to sqlite 3.2.7
- Document how to use BLOBS
So to answer your question.... Yes.
Paul Lalli
| |
| Octavian Rasnita 2006-02-27, 6:58 pm |
| From: "Tom Phoenix" <tom@stonehenge.com>
> Is there a perl module for SQLite3?
[color=darkred]
Yes I did but I have found only DBD::SQLite and DBD::SQLite2, so I thought
that there should be DBD::SQLite3, but now I have seen that DBD::SQLite can
access SQLite3 databases. (I have tried only with DBD::SQLite2)
Thank you.
Teddy
| |
| David Kaufman 2006-02-27, 6:58 pm |
| "Tom Phoenix" <tom@stonehenge.com> wrote:
>
> On 2/27/06, Octavian Rasnita <orasnita@fcc.ro> wrote:
>
> Have you looked on CPAN?
>
> http://search.cpan.org/search?query=SQLite3&mode=all
>
> Hope this helps!
Also, the SQLite DBD driver for DBI (available as
http://search.cpan.org/~msergeant/DBD-SQLite-1.11/) appears to have
supported SQLite 3 for severl versions now.
Sayeth the CHANGELOG:
http://search.cpan.org/src/MSERGEAN...te-1.11/Changes
Revision history for Perl extension DBD::SQLite.
1.11
- Make blobs work transparently (without SQLBLOB binding)
1.10
- Fix Unicode support (DOMQ)
- Support usleep on all Linux (inc. debian) (DOMQ)
- Upgrade to sqlite 3.2.7
- Document how to use BLOBS
1.09
- Support external SQLite library (rjray)
- Don't convert things that look like numbers to numbers
unless specifically requested.
- Upgrade to sqlite 3.2.2
1.08
- Support 64 bit integers (uses floating point numbers
when perl is not compiled with 64 bit int support).
This also fixes issues with using sqlite timestamps.
- Upgrade to sqlite 3.1.3
- Fix issues of not finding rows when providing a number
that perl sees as a string.
- Fixes for most current bugs in RT (see
http://rt.cpan.org/ to check if your favourite bug got
fixed).
1.07
- Fix for a memory leak (spotted by Joel Noble)
- Update to sqlite 3.0.8 (fixes bug on Solaris-sparc)
1.06
- Resolve symbol conflicts on mac os x.
- Fix define in WriteMakefile lacking space.
- Fix DBI prereq in Makefile.PL
- Update to sqlite 3.0.7
1.05
- Enabled HAVE_USLEEP where available which should
massively improve concurrent usage of DBD::SQLite
- Update to sqlite 3.0.6
1.04
- Patched to make it compile on Windows (Steve Hay)
- Fetch next row at end of DBI's fetch() so that one-row
selects don't need to call ->finish(). This restores
DBD::SQLite 0.31's behaviour (and should make popfile
work again)
- last_insert_id will only work on DBI 1.43, so enforce
that
- Use snprintf from sqlite library to improve
portability
1.03
- Update to sqlite 3.0.4
- More bug fixes
- Don't hang forever when db is BUSY
- Make trace macro work where vararg macros don't
-dave
|
|
|
|
|