NAME

       DBIx::Simple::Comparison - DBIx::Simple in DBI jargon

DESCRIPTION

       This is just a simple and inaccurate overview of what DBI things the DBIx::Simple things
       represent, or the other way around.

       This document can be useful to find the foo equivalent of bar.

       "?" means that DBI doesn't have an equivalent or that I couldn't find one.

       "=" means that DBIx::Simple provides a direct wrapper to the DBI function.

       "~" means that DBIx::Simple's method does more or less the same, but usually in a more
       high level way: context sensitive, combining things, automatically taking care of
       something.

       Note that DBIx::Simple is a wrapper around DBI. It is not "better" than DBI. In fact,
       DBIx::Simple cannot work without DBI.

       Using DBI directly is always faster than using DBIx::Simple's equivalents. (For the
       computer, that is. For you, DBIx::Simple is supposed to be faster.)

   Classes, common names
        use DBI       ~  use DBIx::Simple

        $DBI::errstr  =  DBIx::Simple->error

        DBI::db       ~  DBIx::Simple
        $dbh          ~  $db
        $dbh->errstr  =  $db->error

        connect       ~  connect
        connect       ~  new

        DBI::st       ~  DBIx::Simple::Result
        <undef>       ~  DBIx::Simple::Dummy
        $sth          ~  $result

   Queries
       DBI

        my $sth = $dbh->prepare_cached($query);
        $sth->execute(@values);

       ~ DBIx::Simple

        my $result = $db->query($query, $values);

   Results
        DBI                          DBIx::Simple

        bind_columns              ~  bind

        fetchrow_arrayref/fetch   =  fetch
        fetchrow_array            ~  list
        *1                        ~  flat
        [@{fetchrow_arrayref}]    =  array
        fetchall_arrayref         ~  arrays
        fetchrow_hashref() *2*3   =  hash
        fetchall_arrayref({}) *4  ~  hashes

        fetchall_hashref *2       =  map_hashes
        ?                         ?  map_arrays
        fetchall_hashref(1) *2    =  map

        $sth->{NAME_lc/NAME}      =  $result->columns

       *1 There's no fetch variant, but you can do "{ @{ $dbh->selectcol_arrayref('SELECT ...', {
       Slice => [] }) } }".

       *2 To receive the keys (column names) lowercased, use "$db->{FetchHashKeyName} =
       'NAME_lc'". DBIx::Simple lower cases them by default.

       *3 Or supply an argument, 'NAME_lc'.

       *4 No, arrayref isn't a typo. When supplied an empty hash reference, DBI's
       fetchall_arrayref actually returns hashrefs. This DBI method does not support lower casing
       of keys, DBIx::Simple does.

   Direct access
        DBI                 DBIx::Simple

        $dbh             =  $db->dbh
        $sth->{$foo}     =  $result->attr($foo)

        func             =  func

        begin_work       =  begin_work
        commit           =  commit
        rollback         =  rollback
        last_insert_id   =  last_insert_id
        rows             =  rows

        disconnect       ~  disconnect
        finish           ~  finish

   DBIx::Simple specific (?)
        keep_statements
        lc_columns
        iquery (via SQL::Interp)
        select, insert, update, delete (via SQL::Abstract)
        abstract (via SQL::Abstract)
        flat
        hashes
        map_arrays
        map

AUTHOR

       Juerd Waalboer <juerd@cpan.org> <http://juerd.nl/>

SEE ALSO

       DBI, DBIx::Simple