# DBD::Mem - phpMan

## NAME
    [DBD::Mem] - a DBI driver for Mem & MLMem files

## SYNOPSIS
     use DBI;
     $dbh = DBI->connect('dbi:Mem:', undef, undef, {});
     $dbh = DBI->connect('dbi:Mem:', undef, undef, {RaiseError => 1});

     # or
     $dbh = DBI->connect('dbi:Mem:');
     $dbh = DBI->connect('DBI:Mem(RaiseError=1):');

    and other variations on connect() as shown in the DBI docs and
    <[DBI::DBD::SqlEngine] metadata|[DBI::DBD::SqlEngine]/Metadata>.

    Use standard DBI prepare, execute, fetch, placeholders, etc., see "QUICK
    START" for an example.

## DESCRIPTION
    [DBD::Mem] is a database management system that works right out of the
    box. If you have a standard installation of Perl and DBI you can begin
    creating, accessing, and modifying simple database tables without any
    further modules. You can add other modules (e.g., [SQL::Statement]) for
    improved functionality.

    [DBD::Mem] doesn't store any data persistently - all data has the lifetime
    of the instantiated $dbh. The main reason to use [DBD::Mem] is to use
    extended features of [SQL::Statement] where temporary tables are required.
    One can use [DBD::Mem] to simulate "VIEWS" or sub-queries.

    Bundling "[DBD::Mem]" with DBI will allow us further compatibility checks
    of [DBI::DBD::SqlEngine] beyond the capabilities of [DBD::File] and
    [DBD::DBM]. This will ensure DBI provided basis for drivers like
    [DBD::AnyData2] or [DBD::Amazon] are better prepared and tested for not-file
    based backends.

  Metadata
    There're no new meta data introduced by "[DBD::Mem]". See "Metadata" in
    [DBI::DBD::SqlEngine] for full description.

GETTING HELP, MAKING SUGGESTIONS, AND REPORTING BUGS
    If you need help installing or using [DBD::Mem], please write to the DBI
    users mailing list at <mailto:<dbi-users@perl.org>> or to the
    comp.lang.perl.modules newsgroup on usenet. I cannot always answer every
    question quickly but there are many on the mailing list or in the
    newsgroup who can.

    DBD developers for DBD's which rely on [DBI::DBD::SqlEngine] or [DBD::Mem]
    or use one of them as an example are suggested to join the DBI
    developers mailing list at <mailto:<dbi-dev@perl.org>> and strongly
    encouraged to join our IRC channel at <irc://irc.perl.org/dbi>.

    If you have suggestions, ideas for improvements, or bugs to report,
    please report a bug as described in DBI. Do not mail any of the authors
    directly, you might not get an answer.

    When reporting bugs, please send the output of
    "$dbh->mem_versions($table)" for a table that exhibits the bug and as
    small a sample as you can make of the code that produces the bug. And of
    course, patches are welcome, too :-).

    If you need enhancements quickly, you can get commercial support as
    described at <<http://dbi.perl.org/support/>> or you can contact Jens
    Rehsack at <rehsack@cpan.org> for commercial support.

## AUTHOR AND COPYRIGHT
    This module is written by Jens Rehsack < rehsack AT cpan.org >.

     Copyright (c) 2016- by Jens Rehsack, all rights reserved.

    You may freely distribute and/or modify this module under the terms of
    either the GNU General Public License (GPL) or the Artistic License, as
    specified in the Perl README file.

## SEE ALSO
    DBI for the Database interface of the Perl Programming Language.

    [SQL::Statement] and [DBI::SQL::Nano] for the available SQL engines.

    [SQL::Statement::RAM] where the implementation is shamelessly stolen from
    to allow DBI bundled Pure-Perl drivers increase the test coverage.

    [DBD::SQLite] using "dbname=:memory:" for an incredible fast in-memory
    database engine.