1DBD::Mem(3)           User Contributed Perl Documentation          DBD::Mem(3)
2
3
4

NAME

6       DBD::Mem - a DBI driver for Mem & MLMem files
7

SYNOPSIS

9        use DBI;
10        $dbh = DBI->connect('dbi:Mem:', undef, undef, {});
11        $dbh = DBI->connect('dbi:Mem:', undef, undef, {RaiseError => 1});
12
13        # or
14        $dbh = DBI->connect('dbi:Mem:');
15        $dbh = DBI->connect('DBI:Mem(RaiseError=1):');
16
17       and other variations on connect() as shown in the DBI docs and
18       <DBI::DBD::SqlEngine metadata|DBI::DBD::SqlEngine/Metadata>.
19
20       Use standard DBI prepare, execute, fetch, placeholders, etc., see
21       "QUICK START" for an example.
22

DESCRIPTION

24       DBD::Mem is a database management system that works right out of the
25       box.  If you have a standard installation of Perl and DBI you can begin
26       creating, accessing, and modifying simple database tables without any
27       further modules.  You can add other modules (e.g., SQL::Statement) for
28       improved functionality.
29
30       DBD::Mem doesn't store any data persistently - all data has the
31       lifetime of the instantiated $dbh. The main reason to use DBD::Mem is
32       to use extended features of SQL::Statement where temporary tables are
33       required. One can use DBD::Mem to simulate "VIEWS" or sub-queries.
34
35       Bundling "DBD::Mem" with DBI will allow us further compatibility checks
36       of DBI::DBD::SqlEngine beyond the capabilities of DBD::File and
37       DBD::DBM. This will ensure DBI provided basis for drivers like
38       DBD::AnyData2 or DBD::Amazon are better prepared and tested for not-
39       file based backends.
40
41   Metadata
42       There're no new meta data introduced by "DBD::Mem". See "Metadata" in
43       DBI::DBD::SqlEngine for full description.
44

GETTING HELP, MAKING SUGGESTIONS, AND REPORTING BUGS

46       If you need help installing or using DBD::Mem, please write to the DBI
47       users mailing list at <mailto:dbi-users@perl.org> or to the
48       comp.lang.perl.modules newsgroup on usenet.  I cannot always answer
49       every question quickly but there are many on the mailing list or in the
50       newsgroup who can.
51
52       DBD developers for DBD's which rely on DBI::DBD::SqlEngine or DBD::Mem
53       or use one of them as an example are suggested to join the DBI
54       developers mailing list at <mailto:dbi-dev@perl.org> and strongly
55       encouraged to join our IRC channel at <irc://irc.perl.org/dbi>.
56
57       If you have suggestions, ideas for improvements, or bugs to report,
58       please report a bug as described in DBI. Do not mail any of the authors
59       directly, you might not get an answer.
60
61       When reporting bugs, please send the output of
62       "$dbh->mem_versions($table)" for a table that exhibits the bug and as
63       small a sample as you can make of the code that produces the bug.  And
64       of course, patches are welcome, too :-).
65
66       If you need enhancements quickly, you can get commercial support as
67       described at <http://dbi.perl.org/support/> or you can contact Jens
68       Rehsack at rehsack@cpan.org for commercial support.
69
71       This module is written by Jens Rehsack < rehsack AT cpan.org >.
72
73        Copyright (c) 2016- by Jens Rehsack, all rights reserved.
74
75       You may freely distribute and/or modify this module under the terms of
76       either the GNU General Public License (GPL) or the Artistic License, as
77       specified in the Perl README file.
78

SEE ALSO

80       DBI for the Database interface of the Perl Programming Language.
81
82       SQL::Statement and DBI::SQL::Nano for the available SQL engines.
83
84       SQL::Statement::RAM where the implementation is shamelessly stolen from
85       to allow DBI bundled Pure-Perl drivers increase the test coverage.
86
87       DBD::SQLite using "dbname=:memory:" for an incredible fast in-memory
88       database engine.
89
90
91
92perl v5.36.0                      2023-01-20                       DBD::Mem(3)
Impressum