On Apache
Under GNU General Public License
2025-11-29 20:04 @216.73.216.105 CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
DBD::Mem(3pm) User Contributed Perl Documentation DBD::Mem(3pm)
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 AT 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 AT 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 AT 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.
perl v5.34.0 2022-02-06 DBD::Mem(3pm)
Generated by $Id: phpMan.php,v 4.55 2007/09/05 04:42:51 chedong Exp $ Author: Che Dong
On Apache
Under GNU General Public License
2025-11-29 20:04 @216.73.216.105 CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)