NAME

SQLx::Lite - Modernish and friendly interface to DBI

DESCRIPTION

This module is an attempt at a friendly interface to the DBI module. While DBI is fantastic, it can be a little daunting to use if you've never used it before. SQLx::Lite attempts to make using it easy, and a little more modern.

SYNOPSIS

use SQLx::Lite;

my $dbh = SQLx::Lite->connect(
    dbi    => 'Pg:host=localhost;dbname=test',
    user   => 'username',
    pass   => 'password',
);

my $res = $dbh->resultset('users')->search([], { user => 'foo', pass => 'bar' });

if ($res->count > 0) {
    print "Found " . $res->count . " row(s)\n";
    
    while(my $row = $res->next) {
        print "Username: $row->{user}\n";
    }
}

connect

Creates the DBI instance using the hash specified. Currently only dbi is mandatory, which tells DBI which engine to use (SQLite, Pg, etc). If you're using SQLite there is no need to set user or pass.

my $dbh = SQLx::Lite->connect(
    dbi => 'SQLite:/var/db/test.db',
);

my $dbh = SQLx::Lite->connect(
    dbi  => 'Pg:host=myhost;dbname=dbname',
    user => 'username',
    pass => 'password',
);

AUTHOR

Brad Haywood <brad@geeksware.net>

LICENSE

Same license as Perl