Apache2::DBI

thcsoft has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Apache2::DBI by Thilosophy (Curate) on Apr 19, 2005 at 05:11 UTC
From the Apache::DBI docs: Apache::DBI version 0.90_02 and later might work under mod_perl 2.0. See the Changes file for more information. Beware that it has only been tested very lightly. And Changes says 0.93 January 10, 2004 - Change $r->connection->user to $r->user to make AuthDBI work with mod_perl 2.0 (thanks to Neil MacGregor and Brian McCauley ) 0.90_02 January 10, 2003 - Changes to make Apache::DBI load and function under mod_perl 2.0. A few important notes: connect_on_init does not work yet and there's no automatic RollBack cleanup handler when autocommit is turned off. So, it seems like Apache::DBI will (and probably already does) support mod_perl 2 as well.	[reply]
Re^2: Apache2::DBI by jbrugger (Parson) on Apr 19, 2005 at 05:20 UTC
I looked at it as well, and came to the same conclusion, but now i'm begining to wonder if this is stable enough to use on reallife servers, or should we advice to stick to apache1 if there is a need for apache::dbi?. For freebsd seems to be a patch or something... Read more... (2 kB) "We all agree on the necessity of compromise. We just can't agree on when it's necessary to compromise." - Larry Wall.	[reply] [d/l]
Re^3: Apache2::DBI by Thilosophy (Curate) on Apr 19, 2005 at 05:46 UTC
I looked at it as well, and came to the same conclusion, but now i'm begining to wonder if this is stable enough to use on reallife servers I have heard many people wondering the same thing about mod_perl 2 itself... Are those people just overly cautious or are there still any real issues with mod_perl 2?	[reply]
Re^4: Apache2::DBI by jbrugger (Parson) on Apr 19, 2005 at 05:56 UTC
Re: Apache2::DBI by dragonchild (Archbishop) on Apr 19, 2005 at 12:45 UTC
I put AP2/MP2 into production use at the end of 2003, using Apache::DBI. The site's been running without a problem since then. It's not Amazon, but it's not a blog, either. My wife's blog	[reply]
Re: Apache2::DBI by perrin (Chancellor) on Apr 20, 2005 at 00:47 UTC
If you are just using MySQL without transactions, you don't need Apache::DBI, you can use DBI->connect_cached() in place of connect() and just not call close(). However, Apache::DBI does work for mod_perl 2 with some patches. If you look at the mod_perl mailing list archive you'll see that this was just being discussed today.	[reply]