perl.dbi.dev...Re: Memory leak in DBI by Philippe Bruhat- May 19, 2008 On Thu, Apr 10, 2008 at 05:00:57PM +0200, Philippe Bruhat (BooK) wrote:> On Thu, Apr 10, 2008 at 03:40:55PM +0100, Tim Bunce wrote:> > I trust the script is destroying the results and, where appropriate,> > the $sth before calling Devel::Leak::CheckSV.> > Yes.> > The command is run in a block, with lexicals (except the $dbh).> To avoid counting information that is retained by the DBI, the command> is run twice, and the leak count is done on the second run...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5364.html Re: Sort hash keys in C... by Tim Bunce- May 19, 2008 On Fri, May 16, 2008 at 01:45:51AM +0100, Rudolf Lippan wrote:> On Thu, 15 May 2008 13:21:34 +0100, Tim Bunce <Tim.Buncepobox.com> wrote:> > I&39;m sorry for the delay in responding Rudy.> > > > On Wed, May 07, 2008 at 02:34:43AM -0400, Rudy Lippan wrote:> > >> use Scalar::Util qw(looks_like_number);> >> sub _get_sorted_hash_keys > >> my ($hash_ref, $sort_type) = _;> >> my $sort_guess = 1;> >> $sort_guess = ..http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5363.html proposal for DBD::Oracle documentation by Gerhard Lausser- May 17, 2008 Hi,i wrote a script which uses the connection method you describe like this:To connect to a local database with a user which has been set-up toauthenticate via the OS ("ALTER USER username IDENTIFIED EXTERNALLY"):$dbh = DBI->connect(&39;dbi:Oracle:&39;,&39;&39;,&39;&39;);Note the lack of a connection name (use the ORACLE_SID environmentvariable). My tnsnames.ora looks like:BBA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dhcp-144.int.consol.de)(PORT =...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5362.html Re: Sort hash keys in C... by Rudolf Lippan- May 15, 2008 On Thu, 15 May 2008 13:21:34 +0100, Tim Bunce <Tim.Buncepobox.com> wrote:> I&39;m sorry for the delay in responding Rudy.> > On Wed, May 07, 2008 at 02:34:43AM -0400, Rudy Lippan wrote:> >> use Scalar::Util qw(looks_like_number);>> sub _get_sorted_hash_keys >> my ($hash_ref, $sort_type) = _;>> my $sort_guess = 1;>> $sort_guess = 1!=looks_like_number($_) 0:$sort_guess for keys> %$hash_ref;>> $sort_type = $sort_guess...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5361.html Re: Sort hash keys in C... by Tim Bunce- May 15, 2008 I&39;m sorry for the delay in responding Rudy.On Wed, May 07, 2008 at 02:34:43AM -0400, Rudy Lippan wrote:>>>> I think it would be better to keep appending to an sv rather than try to>>>> pre-guess the size. That would avoid the need for the mallocreallocfree.>>> Well it would avoid my having to do it; Perl still does....>>>>>>> Probably slightly more expensive, but not by much if you pre-grow the sv.>>> Mallocrealloc:>> .http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5360.html Re: Function Calling Methods by Darren Duncan- May 14, 2008 I want to throw my support behind this idea in principle, that principle being that it is important to be able to invoke database stored routines efficiently and easily. In my case, considering that a dominant paradigm of Muldis D is to put all database access code in database stored routines, so having less indirection for implementing the language over existing DBMSs should only be helpful. Also as commented, the solution should support inputing or returning arbitrary configurations of...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5359.html Re: Function Calling Methods by Martin Evans- May 14, 2008 David E. Wheeler wrote:> Howdy dbi-devers,> > More and more lately, I&39;m writing database functions in PLpgSQL (in > PostgreSQL) or SQL (in MySQL and others) to do the heavy lifting of > interacting with database tables. I&39;ve been thinking that I&39;d really > love a DBI method to call these functions without having to do the usual > prepare execute fetch drill. Even using do() or fetchrow_array() > seems a bit silly in this context:> > my ($source_id) =.http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5358.html Function Calling Methods by David E. Wheeler- May 14, 2008 Howdy dbi-devers,More and more lately, I&39;m writing database functions in PLpgSQL (in PostgreSQL) or SQL (in MySQL and others) to do the heavy lifting of interacting with database tables. I&39;ve been thinking that I&39;d really love a DBI method to call these functions without having to do the usual prepare execute fetch drill. Even using do() or fetchrow_array() seems a bit silly in this context: my ($source_id) = $dbh->fetchrow_array( &39;SELECT get_source_id()&39;, .http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5357.html DBD::ODBC 1.16 uploaded to CPAN by Martin Evans- May 14, 2008 Hi,I have just uploaded DBD::ODBC 1.16 to CPAN. This release contains the following changes:=head1 CHANGES=head2 Changes in DBD::ODBC 1.16 May 13, 2008=head3 Test ChangesSmall change to the last test in 10handler.t to cope with the preparefailing instead of the execute failing - spotted by Andrei Kovalevskiwith the ODBCng Postgres driver.Changed the 20SqlServer.t test to specifically disable MARS for thetest to check multiple active statements and added a new test to checkthat when...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5356.html Re: bind_param for named parameters - clarification sought by Greg Sabino Mullane- May 14, 2008 -----BEGIN PGP SIGNED MESSAGE-----Hash: RIPEMD160>> I believe, but am prepared to be put right, other non-perl database drivers>> also drop the &39;:&39; when binding.> Any other driver authorsusers care to commentFWIW, DBD::Pg requires a leading colon, but strongly encourages the use of "$1"placeholders, with "" being an inefficient but acceptable alternative. I likethe leading colon because it visually enforces that you are using named parameters,and is...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5355.html |