Re: ANNOUNCE: DBI 1.57

On Tue, 19 Jun 2007 21:11:23 +0100, Tim Bunce <Tim.Bunce@xxxxxxxxx> wrote:

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.57.tar.gz
size: 490304 bytes
md5: fca667f59dff24058a8e0e8f09e2aad9

=head2 Changes in DBI 1.57 (svn rev 9639), 13th June 2007

Note: this release includes a change to the DBI::hash() function which will
now produce different values than before *if* your perl was built with 64-bit
'int' type (i.e. "perl -V:intsize" says intsize='4'). It's relatively rare

Huh?

32bitall:

a5:/u/usr/merijn 101 > perl -V:intsize
intsize='4';
a5:/u/usr/merijn 102 > perl -V:use64bitint
use64bitint='undef';
a5:/u/usr/merijn 103 >

64bitint:

nb09:/home/merijn 101 > perl -V:intsize
intsize='4';
nb09:/home/merijn 102 > perl -V:use64bitint
use64bitint='define';
nb09:/home/merijn 103 >

64bitall:

x1:/u/usr/merijn 101 > perl -V:intsize
intsize='4';
x1:/u/usr/merijn 102 > perl -V:use64bitall
use64bitall='define';
x1:/u/usr/merijn 103 > perl -V:use64bitint
use64bitint='define';
x1:/u/usr/merijn 104 >

So, relatively rare sounds very weird to me.

for perl to be configured that way, even on 64-bit systems.

Fixed XS versions of select*_*() methods to call execute()
fetch() etc., with inner handle instead of outer.
Fixed execute_for_fetch() to not cache errstr values
thanks to Bart Degryse.
Fixed unused var compiler warning thanks to JDHEDDEN.
Fixed t/86gofer_fail tests to be less likely to fail falsely.

Changed DBI::hash to return 'I32' type instead of 'int' so results are
portable/consistent regardless of size of the int type.

Shouldn't that be IV

Corrected timeout example in docs thanks to Egmont Koblinger.
Changed t/01basic.t to warn instead of failing when it detects
a problem with Math::BigInt (some recent versions had problems).

Added support for !Time and !Time~N to DBI::Profile Path. See docs.
Added extra trace info to connect_cached thanks to Walery Studennikov.
Added non-random (deterministic) mode to DBI_GOFER_RANDOM mechanism.
Added DBIXS_REVISION macro that drivers can use.
Added more docs for private_attribute_info() method.

DBI::Profile changes:
dbi_profile() now returns ref to relevant leaf node.
Don't profile DESTROY during global destruction.
Added as_node_path_list() and as_text() methods.
DBI::ProfileDumper changes:
Don't write file if there's no profile data.
Uses full natural precision when saving data (was using %.6f)
Optimized flush_to_disk().
Locks the data file while writing.
Enabled filename to be a code ref for dynamic names.
DBI::ProfileDumper::Apache changes:
Added Quiet=>1 to avoid write to STDERR in flush_to_disk().
Added Dir=>... to specify a writable destination directory.
Enabled DBI_PROFILE_APACHE_LOG_DIR for mod_perl 1 as well as 2.
Added parent pid to default data file name.
DBI::ProfileData changes:
Added DeleteFiles option to rename & delete files once read.
Locks the data files while reading.
Added ability to sort by Path elements.
dbiprof changes:
Added --dumpnodes and --delete options.
Added/updated docs for both DBI::ProfileDumper && ::Apache.

=cut

You can see the primary focus of my recent developments for Shopzilla
have been around profiling. Specifically using the DBI's profiling
mechanisms to implement lightweight always-on application-level profiling.

Enjoy!

Tim.

p.s. I've a new module, called DashProfiler, that provides a simple,
flexible, efficient way to add performance monitoring to an application,
especially web applications. It's trivial to track the time spent inside
specific blocks of code, or the lifespan of specific objects.

(It happens to use DBI handles internally to store profile data but is
unrelated to databases. A working version, but with almost no docs, is
on CPAN. I'll announce the documented version when I release it but I
won't be using the dbi mailing lists for DashProfiler in future.)



--
H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/)
using & porting perl 5.6.2, 5.8.x, 5.9.x on HP-UX 10.20, 11.00, 11.11,
& 11.23, SuSE 10.0 & 10.2, AIX 4.3 & 5.2, and Cygwin. http://qa.perl.org
http://mirrors.develooper.com/hpux/ http://www.test-smoke.org
http://www.goldmark.org/jeff/stupid-disclaimers/
.

Relevant Pages

  • ANNOUNCE: DBI 1.57
    ... for perl to be configured that way, ... Don't profile DESTROY during global destruction. ... Added parent pid to default data file name. ... won't be using the dbi mailing lists for DashProfiler in future.) ...
    (perl.dbi.users)
  • Re: Address book
    ... All you need are a functional mail transport and an Outlook Data File (PST ... >>I don't know what necessary components you're talking>>about or how to configure my profile. ... >>>>When I go to "View or change existing email accounts,"> it>>shows the name and type of email account>>>>When I go to "View or change existing directories and>>address books" there is nothing listed. ...
    (microsoft.public.outlook.contacts)
  • Re: nightmare trying to reinstall PST after vista crash
    ... By Profile I mean Outlook Profile, you can create a new Profile via the Mail ... Applet in the control Panel, or the Outlook Data File Management shortcut, ... Copy any pst files, on dvd to the documents folder. ...
    (microsoft.public.outlook.installation)
  • Re: Use one Contacts list with two Profiles
    ... necessary information about your configuration, ... > So we created a second profile, ... >> profile to use the same Outlook Data File. ...
    (microsoft.public.outlook.contacts)