[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#724036: ITP: libdancer2-plugin-database-perl -- module for easy database connections for Dancer2 applications

Package: wnpp
Owner: gregor herrmann <gregoa@debian.org>
Severity: wishlist
X-Debbugs-CC: debian-devel@lists.debian.org,debian-perl@lists.debian.org

* Package name    : libdancer2-plugin-database-perl
  Version         : 2.10
  Upstream Author : David Precious <davidp@preshweb.co.uk>
* URL             : https://metacpan.org/release/Dancer2-Plugin-Database
* License         : Artistic or GPL-1+
  Programming Lang: Perl
  Description     : module for easy database connections for Dancer2 applications

Dancer2::Plugin::Database Provides an easy way to obtain a connected DBI
database handle by simply calling the database keyword within your Dancer2

The module returns a Dancer::Plugin::Database::Core::Handle object, which is
a subclass of DBI's `DBI::db' connection handle object, so it does everything
you'd expect to do with DBI, but also adds a few convenience methods.

It takes care of ensuring that the database handle is still connected and
valid. If the handle was last asked for more than
`connection_check_threshold' seconds ago, it will check that the connection
is still alive, using either the `$dbh->ping' method if the DBD driver
supports it, or performing a simple no-op query against the database if not.
If the connection has gone away, a new connection will be obtained and
returned. This avoids any problems for a long-running script where the
connection to the database might go away.

Care is taken that handles are not shared across processes/threads, so this
should be thread-safe with no issues with transactions etc.

Reply to: