./databases/p5-DBD-SQLite, Perl DBI/DBD driver for sqlite databases

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 1.29, Package name: p5-DBD-SQLite-1.29, Maintainer: pkgsrc-users

SQLite is a public domain RDBMS database engine.

Rather than ask you to install SQLite first, because SQLite is
public domain, DBD::SQLite includes the entire thing in the
distribution. So in order to get a fast transaction capable RDBMS
working for your perl project you simply have to install this module,
and nothing else.


Required to run:
[databases/p5-DBI] [lang/perl5]

Master sites: (Expand)

SHA1: 915ab4f6abcdbcf4089e1e290e92ed773092db40
RMD160: 27c940ab6e51e7c1e963ff7d95b56824dd0f4489
Filesize: 1185.02 KB

Version history: (Expand)


CVS history: (Expand)


   2010-01-16 16:08:21 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
Updating databases/p5-DBD-SQLite from 1.25 to 1.29.

pkgsrc changes:
- Correcting license to ${PERL5_LICENSE}
- Updating dependencies
- database/sqlite3 isn't used anymore - only the bundled sqlite

Upstream changes:
1.29 Fri  8 Jan 2010
    - Updated to SQLite 3.6.22 (DUNCAND)

1.28_02 Sun  3 Jan 2010
    - Now empty (or comment only) statements won't cause segv
      or "not an error" errors. Spotted by TOKUHIROM. (ISHIGAKI)
    - Resolved #52573: previous fix always turned on the AutoCommit
      flag; it goes along with the behavior of the internal library
      but broke compat. (ISHIGAKI)
    - Removed the SQLITE_CORE and SQLITE_PRT_SZ flags at the recommendation
      of the SQLite mailing list. (ADAMK)

1.28_01 Tue 22 Dec 2009
    - Updated to SQLite 3.6.21 (ISHIGAKI)
    - silence warnings on HP-UX (HMBRAND)
    - Resolved #52573: Manual Transaction handling seems to be
      broken (hopefully) (ISHIGAKI)

1.27 Mon 23 Nov 2009
    - Switching to a production version

1.26_07 Sun 15 Nov 2009
    *** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
    - Foreign keys support is once again disabled by default.
      It seems to have a greater impact than we expected and
      it actually broke things. This feature probably will be
      enabled by default by the sqlite team in the future, and
      eventually you'll need to cope with it, but right now we
      agreed with some discussion to give you more time to be
      prepared. If you use referential stuff in your schema
      (which sqlite ignores now) should do extensive testing
      to ensure that they will work when you issue "PRAGMA
      foreign_keys = ON". (ISHIGAKI)

    - Updated to SQLite 3.6.20 (DUNCAND)
    - Resolved #50935: there remained old "unicode" attribute usage
      in the pod, spotted by ASHLEY. (ISHIGAKI)

1.26_06 Wed 28 Oct 2009
    *** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
    - Removed undocumented (and most probably unused) reset method
      from a statement handle (which was only accessible via func().)
      Simply use "$sth->finish" instead. (ISHIGAKI)
    - Now DBD::SQLite supports foreign key constraints by default.
      Long-ignored foreign keys (typically written for other DB
      engines) will start working. If you don't want this feature,
      issue a pragma to disable foreign keys. (ISHIGAKI)
    - Renamed "unicode" attribute to "sqlite_unicode" for \ 
integrity.
      Old "unicode" attribute is still accessible but will be
      deprecated in the near future. (ISHIGAKI)

    - You can see file/line info while tracing even if you compile
      with a non-gcc compiler. (ISHIGAKI)
    - Major code refactoring. (ISHIGAKI)
    - Pod reorganized, and some of the missing bits (including
      pragma) are added. (ISHIGAKI)

1.26_05 Thu 15 Oct 2009
    - Updated to SQLite 3.6.19 (ISHIGAKI)

1.26_04 Tue 6 Oct 2009
    *** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
    - Resolved #49716: Fixed $dbh->column_info to work according to
      the spec in DBI and added support for attached databases. (VLYON)
    - Fixed $sth->primary_key_info to work according to the spec in DBI
      and changed the tests in t/27_metadata.t to reflect this. (VLYON)
    - Tweaked not to hide a real error by a "not an error" issued
      by another sqlite3 function between the failed sqlite3 function
      and the sqlite_error to report. Note that this change makes
      some failures issue two relevant errors at a time. (ISHIGAKI)

    - Updated to SQLite 3.6.18 (DUNCAND)
    - Resolved #48393: previous effort was not enough; BegunWork
      should also be handled properly (ISHIGAKI)
    - Replaced last DBILOGFP with DBIc_LOGPIO(imp_xxh) (ISHIGAKI)
    - Tweaked t/08_busy.t not to fail just because it is tested
      under a very, very slow (virtual) machine. (ISHIGAKI)
    - Added a code to look for a compiler from Module::Install::Can.
      (ISHIGAKI)
    - Added documentation and an 'Escape' attribute for $sth->table_info.
      (VLYON)

1.26_03 Wed 12 Aug 2009
    - Updated to SQLite 3.6.17 (ISHIGAKI)
    - Switched to use :memory: for most of the tests (ISHIGAKI)
    - Fixed a memory leak when prepare should fail (ISHIGAKI)
    - Added support for commit/rollback/update hooks (DAMI)
    - Added support for set_authorizer (DAMI)
    - Added support for collation_needed(), and reorganised driver API
      for user-defined collations (DAMI)
    - Exported constants from sqlite3.h into DBD::SQLite namespace (DAMI)
    - Added support in t/lib/Test.pm for checking both versions of
      driver-private methods ("func" / "sqlite_*") (DAMI)
    - Removed unused and obsolete "list_tables" from SQLite.xs (DAMI)
    - Added a default implementation for the REGEXP infix operator (DAMI)
    - Renamed several internal sqlite3_ functions to sqlite_
      for clarity (ISHIGAKI)
    - Accept empty filename at connect (sqlite will open a tempfile) (DAMI)
    - Documented the connect() method (DAMI)
    - Replaced imp_dbh->in_tran with sqlite3_get_autocommit(), hoping
      this would fix the annoying rollback issues, including #48393
      (ISHIGAKI)
    - META.yml requires is now generated instead of being derived from the
      (incorrect) PREREQ_PM values by ExtUtils::MakeMaker (ADAMK)

1.26_02 Fri 19 Jun 2009
    *** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
    - Resolved #46831: table_info schema is incorrect and doesn't
      work with attached databases (VLYON/ISHIGAKI)

    - Updated to SQLite 3.6.15 (DUNCAND)
    - Resolved #44882: Use of $h->func() should be deprecated and
      replaced with calls to driver-private 'installed methods'
      (ISHIGAKI)
    - Added access to Online Backup functionality. (TJC)
    - Added enable_load_extension pod (ISHIGAKI)
    - Now private methods/functions return true after successful
      calls (#44871) (ISHIGAKI)
    - Removed all of the "croak"s (#44871) (ISHIGAKI)

1.26_01 Tue  5 May 2009
    - Added ORDINAL_POSITION support for $dbh->column_info (ADAMK)
    - Applied several fixes from GFUJI to clean up code (#45578)
      (ISHIGAKI)
    - Skipped some of the unicode path tests under cygwin (#45166)
      (JDHEDDEN)
    - Added some explanation and workarounds for a SQL that
      compares a return value of a function with a numeric bind
      value (ISHIGAKI)
   2009-04-24 09:31:39 by Jens Rehsack | Files touched by this commit (2)
Log message:
PkgSrc changes:
  - Updating package for p5 module DBD::SQLite to 1.25 from 1.13

Upstream changes:
.25 Thu 23 Apr 2009
    - Amalgamation conversion turned out to be quicker than expected.
    - Changing to a production release.  (ADAMK)

1.24_02 Wed 22 Apr 2009
    - Merging various externally-contributed annotations from
      annocpan.org (ADAMK)
    - Created the beginnings of a DBD::SQLite::Cookbook (ADAMK)

1.24_01 Wed 22 Apr 2009
    - Moved getsqlite.pl into util (ADAMK)
    - Switching to the RT queue instead of the RT report page that
      does nothing and just refers you to email (ADAMK)
    - Now DBD::SQLite also uses amalgamated source recommended at sqlite.org \ 
(ISHIGAKI)
    - Resolved #45166: better unicode path handling under cygwin (ISHIGAKI)
    - Resolved #45171: test failure on CentOS 4.6 (ISHIGAKI)
   2009-04-23 08:55:03 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
PkgSrc changes:
  - Updating package for p5 module DBD::SQLite to 1.23
  - Setting license to artistic-2.0

Upstream changes:
1.23 Sun 19 Apr 2009
    - No changes from 1.22_08, just switched to production release (ADAMK)

1.22_08 Fri 17 Apr 2009
    - Completed the migration of all tests and deleted lib.pl (ADAMK)
    - Prevented a double "commit is innefective" warning (ADAMK)
    - Adding a version for the Win32.pm dependency (ADAMK)

1.22_07 Thu 16 Apr 2009
    - Improved non-latin unicode filename support/test
      on Windows (SZABGAB/ISHIGAKI)
    - Removed the table name generator from t/lib.pl,
      getting us closer to removing t/lib.pl entirely (ADAMK)
    - Increased use of Test::NoWarnings (ADAMK)
    - Converted half the remaining lib.pl tests to t::lib::Test (ADAMK)
    - Require Win32.pm on Windows (CHORNY)

1.22_06 Wed 15 Apr 2009
    - Simplifying various miscellaneous code (ADAMK)
    - Adding support for non-latin unicode filenames on Windows (ADAMK)

1.22_05 Wed 15 Apr 2009
    - Hopefully the last dev release before the next production release.
    - Updated to SQLite 3.6.13 (DUNCAND)
    - Setting svn:eol-style to native to prevent EOL issues (ADAMK)
    - Resolved #44861: tweaked Makefile.PL to support older HP-UX (ISHIGAKI)

1.22_04 Sat 11 Apr 2009
    - Adding support parsing attributes out of the DSN (ADAMK)
    - Inserted pTHX_/aTHX_ for better efficiency (suggested in #44884 by TIMB) \ 
(ISHIGAKI)
    - Dropping support for uncode before 5.8.5 to simplify support and
      to prevent people hurting themselves on platforms that don't
      properly support Unicode anyway (ADAMK)
    - Stopped guessing if a bind param looks like a number or not
      (suggested by GUIDO). This reopens #29058 and #29629, but
      there are two workarounds for them. 1) Use "bind_param"
      explicitly (rather than plain "execute", as you do for BLOB).
      2) Add "+0" to the appropriate part(s) of your SQL to let
      sqlite convert them into a number. (ISHIGAKI)

1.22_03 Thu 10 Apr 2009
    - Resolved #44876: Patch to fix includes in the SQLITE_LOCATION case by \ 
janus (ISHIGAKI)
    - Added PERL_NO_GET_CONTEXT for efficiency (suggested in #44884 by TIMB) \ 
(ISHIGAKI)
    - Refactored error handling (suggested in #44884, #44871 by TIMB) (ISHIGAKI)

1.22_02 Wed  9 Apr 2009
    - Added missing documentation bits for 'create_collation'
      and 'progress_handler' (DAMI)
    - Resolved RT#25924 (Arguments to user-defined functions do not
      respect unicode setting) (DAMI)
    - Added comments on the return values on error, and fixed another
      wrong return value in execute (ISHIGAKI)
    - Added SQL_NULLABLE_UNKNOWN; still wonders if the error above
      should be ignored or not (ISHIGAKI)

1.22_01 Wed  9 Apr 2009
    - Resolved #25371: Calls sv_utf8_upgrade on strings going into
       the database to make sure latin-1 strings are not saved as
       Malformed UTF-8 character in the SQLite TEXT column (MIYAGAWA)
   2009-04-11 23:25:38 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
PkgSrc changes:
  - Update to 1.21

Upstream changes:
1.21 Wed  9 Apr 2009
    - Fixed the issue that execute on inactive handles returned
      0 instead of undef, which made a DBIC test broken (ISHIGAKI)

1.20 Mon  7 Apr 2009
    - Moving to the first production release of the new era.
    - Check DBI version in Makefile.PL (CHORNY)
    - Bundling Test::NoWarings into /inc to remove a dependency (ADAMK)
    - Correcting use 5.00503 to 5.006 in SQLite.pm (ADAMK)

1.19_10 Mon  6 Apr 2009
    - A few more tests moved to Test::More (ADAMK)
    - We need DBIXS_REVISION, which appeared in DBI 1.57.
      Bumping up our dependency to match it and confirmed myself
      that DBD::SQLite actually builds against 1.57 (ADAMK)
    - Resolved #40594: $sth->{NULLABLE} implementation (ISHIGAKI)
    - Resolved #29629: sqlite where length issue (actually this has
      been fixed before) (ISHIGAKI)
    - Applied an enable_load_extension patch from RT #32998 (ISHIGAKI)
    - Resolved #42940: DBD-SQLite make test faild (ADAMK)
    - Resolved #26460: Sorting numeric values in aggregate functions (ADAMK)
    - Resolved #32889: prepare_cached does not work correctly (ADAMK)
    - Resolved #34828: Please add support for user-defined collations (ADAMK)
    - Made Test::NoWarnings an optional module (CORION)

1.19_09 Sun  5 Apr 2009
    - Require perl 5.6 because dependencies require it
    - Updated ppport.h to the most recent release 3.17 (ADAMK)
    - Adding $DBI::VERSION diag to help diagnose FAIL reports (ADAMK)
    - #29519 was only resolved on Win32. Applied a more comprehensive
      patch (JHEDDEN)
    - Rewrote 28_schemachange.t in Test::More style (ADAMK)
    - Bug fix in 28_schemachange.t rewrite re fork/connect (DUNCAND)
    - Resolved #44779: [t/03insert.t] last_insert_id returns undef where 4
      is expected (DUNCAND, CHORNY; that is, DUNCAND debugged and solved
      the ticket based on _08, which was a flaw in the Makefile.PL
      involving an always-applied -Dno_last_insert_id, but it turns out
      CHORNY had inadvertantly applied the fix in the name of DBI cleaning)
    - Starting to use Test::NoWarnings in the test scripts (ADAMK)
    - Added link to MailingList resource (ADAMK)
    - Squelch warnings inless PrintWarn is set in line with guidance from
      the DBI documentation (ADAMK)
    - Resolved #29058: don't quote a bind param (as a text) if it
      looks like a number (ISHIGAKI)
    - Resolved #27553: prepare_cached and analyze issue (actually
      this has been fixed before) (ISHIGAKI)

1.19_08 Sat  4 Apr 2009
    - Bumped minimum DBI dependency to 1.43 so last_insert_id is supported
      in DBI (ADAMK)
    - Resolved #30558: INSERT After PK Failure Also Fails Using
      Prepared (ADAMK)
    - Resolved #42567: Core dump in t/07busy.t after test 4 (mutex and/or
      memory corruption) (ADAMK)
    - Resolved #32100: t/06error.t fails using SQLite 3.5.4 (ADAMK)
    - Resolved #35904: Test failure: Bus error t/08create_function
      test (ADAMK)
    - Resolved #9792: Crashes upon re-executing a statement (ADAMK)
    - Resolved #21472: Spurious "not an error" and "bind or \ 
column index
      out of range" errors (MSERGEANT)
    - Resolved #32723: last_insert_rowid should handle sqlite_int64,
      not int (ADAMK)
    - Resolved #37215: memory leaks in sqlite_db_disconnect (ADAMK)
    - Resolved #33441: unlimited memory accumulation (ADAMK)
    - Resolved #31324: Incorrect Implementation of column names within
      sqlite_st_FETCH_attrib (ADAMK)
    - Resolved #32570: segmentation fault during tests 07 & 08 (ADAMK)
    - Resolved #41631: Dot doesn't work in quoted column aliases (ADAMK)
    - Resolved #403: test failure on "Testing select speed (large table) (ADAMK)
    - Resolved #35769: dbimp.c uses uninitialized variables. (ADAMK)
    - Resolved #27701 and #27702: (unnamed) (ADAMK)
    - Resolved #31239: prepare_cached...statement handle
      DBIx::ContextualFetch::st=HASH still Active (ADAMK)
    - Resolved #41047: Re: Bug#506157: libdbd-sqlite3-perl: unsufficient
      error message while opening database for writing (ADAMK)
    - Resolved #25196 (bug in prepare?) (ADAMK)\
    - Resolved #36651: Bug involving "closing dbh with active
      statement handles" (ADAMK)
    - Resolved #34408: Primary key name wrong with newline in
      CREATE TABLE (ADAMK)
    - Resolved #34600: t/06_error.t stalling (ADAMK)
    - Resolved #22688: DBD::SQLITE Error Report (ADAMK)

1.19_07 Sat  4 Apr 2009
    - Starting to work the RT queue now the basics are settled.
      Many of the items marked as resolved by my just indicate that I have
      confirmed someone else applied the fix. (ADAMK)
    - Re-enable and fix t/70schemachange.t, as per RT #43448 (CORION)
    - Added a canary test to probe for RT #36863
      (segfault on OSX 10.5.2) (CORION)
    - Added resources links to META.yml (ADAMK)
    - Resolved #30502: t\70schemachange.t fails on Windows (ADAMK)
    - Resolved #30167: Specify configuration depenencies with
      "configure_requires" (ADAMK)
    - Resolved #17623: make test fails when DBI_DSN is not
      DBD::SQLite (ADAMK)
    - Resolved #13631: wish: column_info support() (CORION)
    - Resolved #39938: Read-access to development repository (ADAMK)
    - Resolved #18617: Build error under win32 (ADAMK)
    - Resolved #35838: support for DBI::column_info call (CORION)
    - Resolved #29497: POD content bug (ADAMK)
    - Resolved #29520: 1.14 fails in test 6 (ADAMK)
    - Resolved #44647: Makefile.PL syntax error (ADAMK)
    - Resolved #29519: t/70schemachange.t failure (ADAMK)
    - Resolved #20286: DBD::SQLite leaks file descriptors (ADAMK)
    - Resolved #21406: DBD-SQLite 1.13 broke Class-DBI (ADAMK)
    - Resolved #4591: Test suite (t/t50*.t) is order dependent / bug in
      t/lib.pl? (ADAMK)
    - Resolved #36467: Name "DBD::SQLite::sqlite_version" used
      only once (ADAMK)
    - Resolved #7753: DBD::SQLite error shouldn't include extraneous
      info (ADAMK)

1.19_06 Sat  4 Apr 2009
    - Fixed a segv with an error function under x86 linux
      (and hopefully Mac OSX). (TOKUHIROM)
    - Fixed yet another segv while testing DBIC reconnection (DMAKI)
    - Switched from Test.pm to Test::More (though there're still
      some tests that don't use Test::More) (ISHIGAKI)
    - Added "use strict" to some. (ISHIGAKI)
    - Added a cleanup block to each test to allow it run clean and
      separately. (ISHIGAKI)
    - Adding an explicit minimum Perl version to the Makefile.PL (ADAMK)
    - Setting configure_requires dependencies for File::Spec
    - Splitting the LICENSE key into it's own MakeMaker
      version-dependency conditional (ADAMK)
    - All tests run under the same Perl environment
      (autoflush on, and warnings enabled via $^W = 1) (ADAMK)
    - Refactored away a ton of needless complexity from the
      older-style tests inherited from the CSV driver (ADAMK)

1.19_05 Thu  2 Apr 2009
    - DBD::SQLite::Amalgamation 3.6.1.2 and DBD::SQLite 1.19
      should be feature identical now.
    - Added collations from DBD::SQLite::Amalgamation (CORION)
    - Removed statement handle activation after "execute" if
      there's no row to fetch. I hope this silences the
      Class::DBI's warnings. (ISHIGAKI)

1.19_04 Tue 31 Mar 2009
    - Updated to SQLite 3.6.12 (ISHIGAKI)

1.19_03 Tue 31 Mar 2009
    - Added ->column_info() (CORION)

1.19_02 Sun 29 Mar 2009
    - Updated to SQLite 3.6.11 (ISHIGAKI)
    - Added/updated several prototypes (ISHIGAKI)
    - Moved TODO into the POD (ADAMK)

1.19_01 Fri 27 Mar 2009
    - Updated to SQLite 3.6.10, and bumped up the version
      requirement for installed sqlite3 to 3.6.0 as 3.6.x
      has backward incompatiblity (ISHIGAKI)
    - Fixed "closing dbh with active statement handles" issue
      with a patch by TOKUHIROM. (ISHIGAKI)
    - Skip 70schemachange test for Windows users. (ISHIGAKI)
    - Applied RT patches including #29497, #32723, #30558,
      #34408, #36467, #37215, #41047. (ISHIGAKI)
    - Added TODO to show which issues are to be fixed. (ISHIGAKI)
    - License and configure_requires in Makefile.PL and META.yml (Alexandr Ciornii)
    - Spelling check for SQLite.pm (Alexandr Ciornii)
    - Adding arbitrary Perl 5.00503 minimum

1.16 abandoned

1.15 abandoned
   2008-10-19 21:19:25 by Havard Eidnes | Files touched by this commit (1179)
Log message:
Bump the PKGREVISION for all packages which depend directly on perl,
to trigger/signal a rebuild for the transition 5.8.8 -> 5.10.0.

The list of packages is computed by finding all packages which end
up having either of PERL5_USE_PACKLIST, BUILDLINK_API_DEPENDS.perl,
or PERL5_PACKLIST defined in their make setup (tested via
"make show-vars VARNAMES=...").
   2007-10-29 22:53:25 by Adrian Portelli | Files touched by this commit (2) | Package updated
Log message:
1.14
- Updated to SQLite 3.4.2
- Switch to sqlite3_prepare_v2 which fixes a number of bugs with re-using statements
- Fix bug with overflowing integers in user defined functions
- Fix bug when building under no-threads perl
   2007-10-25 18:59:59 by Johnny C. Lam | Files touched by this commit (980)
Log message:
Remove empty PLISTs from pkgsrc since revision 1.33 of plist/plist.mk
can handle packages having no PLIST files.
   2007-05-20 02:25:41 by Klaus Heinz | Files touched by this commit (1)
Log message:
Adapted MASTER_SITES to the usual CPAN scheme.
The Package supports installation to DESTDIR and needs a C compiler.