Skip to content


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Commits on Sep 13, 2011
Commits on Sep 12, 2011
Commits on Sep 10, 2011
Commits on Sep 5, 2011
  1. @bigpresh

    Merge pull request #11 from Perlover/master

    bigpresh authored
    Check $dbh->{Active} before returning a handle, in case it has been disconnected.
  2. @Perlover
  3. @Perlover
Commits on Aug 19, 2011
  1. @bigpresh

    Preparing to release 1.42.

    bigpresh authored
    Bump version, update Changes, acknowledgement for LoonyPandora.
  2. @bigpresh

    Merge pull request #9 from LoonyPandora/patch-1

    bigpresh authored
    Don't warn that we're adding UTF-8 support if we've already set it
Commits on Jul 24, 2011
  1. @LoonyPandora

    Don't warn that we're adding UTF-8 support if we've already set it ou…

    LoonyPandora authored
    It's just annoying to see the warning on every request - even if you've manually specified mysql_enable_utf8 to be true.
  2. @ambs

    Refer SimpleCRUD

    ambs authored
  3. @ambs

    I know I didn't do much.. but

    ambs authored
  4. @ambs

    Docs, Changes, Release

    ambs authored
  5. @ambs

    support IS NULL where clause

    ambs authored
Commits on Jun 23, 2011
  1. @bigpresh

    Include description in name.

    bigpresh authored
    Thanks to gregor herrmann <> via Maximilian Gaß <>
    in RT #69051 for requesting this (so that there's a whatis entry in
Commits on Jun 1, 2011
  1. @bigpresh

    Link to watch repo on GitHub.

    bigpresh authored
    Hopefully might encourage people to watch the project.
Commits on May 31, 2011
  1. @bigpresh
  2. @bigpresh

    Include 'port' in config example.

    bigpresh authored
    Thanks to Mithaldu for pointing out that this was missing.
Commits on May 29, 2011
  1. @bigpresh

    Preparing to release 1.40.

    bigpresh authored
Commits on May 26, 2011
  1. @bigpresh
  2. @bigpresh
  3. @bigpresh

    Update Changes; add acknowledgement.

    bigpresh authored
    This will be released once I've seen some test reports ideally.
  4. @bigpresh

    Extract driver from DSN so we can still do auto utf8.

    bigpresh authored
    If we're given a pre-assembled DSN instead of a set of driver/host/database etc
    params, extract the driver from the DSN, so we don't trigger undefined var
    warnings, and more importantly, so the auto UTF-8 support can be enabled if the
    app has charset: UTF-8 set.
    Thanks for Matthew Vickers (@mvickers) for bringing this to my attention!
Commits on May 25, 2011
  1. @bigpresh
  2. @bigpresh
  3. @bigpresh

    test that handles are cached.

    bigpresh authored
    Adding a test to check that we get the same handle back each time we call
  4. @bigpresh

    Be fork/thread-safe.

    bigpresh authored
    Store handles by PID (and TID, if running under threads), so that no two
    processes/threads could receive the same handle.
    I'd previously not thought this was a problem since if Dancer is going to fork,
    it does so when a request starts, but if the database() keyword was used at
    runtime as the app starts rather than in a route handler, dragons could lie
    ahead.  Also, if running under mod_perl + mpm_worker, or on Windows, where
    forking is imitated with threads.
    Thanks to mst for hitting me with the cluebat on this one.
    Considering overhauling to use DBIx::Connector, but I think that may be overkill
    and require more effort and potential API changes than it may be worth.
    More thought on that required; comments welcome.
Commits on May 23, 2011
  1. @bigpresh
  2. @bigpresh

    Allow e.g. quick_select($table, {}) for all rows.

    bigpresh authored
    Requested by Carlos Sosa (gnusosa).
    Before, if you didn't ass anything for the where clause, it would complain, and
    if you passed an empty hashref (to signify no conditions) it would generate an
    invalid query.
    This will allow you to pass an empty hashref to mean "no where clause"
        my @all_rows = database->quick_select($table_name, {});
    ... would return you all rows in the table.
Commits on May 9, 2011
  1. @bigpresh

    Preparing to release 1.24.

    bigpresh authored
  2. @bigpresh

    Avoid warning for undef params when logging.

    bigpresh authored
    Avoid triggering a warning for use of an undefined var under use warnings if any
    of the params passed to a quick_*() method is undef.
    Thanks to Martin J Evans (mje) for pointing this out on IRC.
  3. @bigpresh

    Stash away log_queries setting correctly.

    bigpresh authored
    Seems like DBI does some magic and removes unrecognised keys; it must start
    'private_', not '_private_'.  Should have read the DBI documentation a little
    more closely.
    Thanks to Martin J Evans (mje) for reporting this on IRC and for help
    investigating also.
Commits on Apr 21, 2011
  1. @bigpresh

    Remove test app log.

    bigpresh authored
    Accidentally committed this log file, this doesn't belong here
Commits on Apr 15, 2011
  1. @bigpresh

    Only log queries if log_queries is enabled in config.

    bigpresh authored
    Previously, queries generated by quick_select(), quick_insert() etc in
    Dancer::Plugin::Database::Handle were logged (at debug level).
    This could potentially lead to users unwittingly logging sensitive information
    going to/from the database, so I've made it a configurable option, off by
    To enable logging of these queries, set the log_queries option to a true value.
    This would provide a very minor performance boost too, as without the option
    enabled, Dancer::Logger::debug() won't be called at all.
    The setting is read at connection time and stored with the database handle, so
    changing this setting during runtime but after connection to the database will
    have no effect on whether queries are logged; the value as it was when the
    connection was obtained will continue to be used.
Commits on Apr 11, 2011
  1. @bigpresh
Something went wrong with that request. Please try again.