Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re: changing the printing order of a db

by jsprat (Curate)
on Jul 19, 2003 at 02:13 UTC ( #275804=note: print w/replies, xml ) Need Help??

in reply to changing the printing order of a db

The default order of $DB_BTREE is lexical. If you use a date/time stamp for the key, keys will return the keys in sorted order automatically and you won't need a custom sort order - ie:

$tied_hash{20030718190355} = $value;

Another approach using $DB_RECNO can be found at Re: Re: Re: Re: Re: Re: DB_File, not saving.


Replies are listed 'Best First'.
Re: Re: changing the printing order of a db
by Anonymous Monk on Jul 19, 2003 at 03:54 UTC
    Ok, I tried your idea and am using $hash{localtime()} = $info but it prints data in a miscellaneus order. Any other possibilities?
      localtime in scalar context returns a string something like "Fri Jul 18 23:35:45 2003" which won't sort cleanly. Build the key like "YYYYMMDDHHMMSS" and the keys will be sorted on disk.

      #!/usr/bin/perl use strict; use warnings; use DB_File; unlink 'db'; # to prevent dupes if this is run more than once tie my %hash, 'DB_File', 'db', O_CREAT|O_RDWR, 0644, $DB_BTREE; print "Building \%hash...\n"; $|++; for my $count (1 .. 50) { my @time = localtime; my $key = $time[5] + 1900; $key .= sprintf "%02d", $time[$_] for reverse 0 .. 4; print "$count... " if $count % 10 == 0; $hash{$key} = "Message number $count"; sleep 1; } print "Output:\n"; print "$_: $hash{$_}\n" for keys %hash;

      Check the output, you'll see what I mean. The keys come out lexically sorted - the messages go from Message #1 to #50.

      Remember that you can have duplicate keys with $DB_BTREE. If two values are inserted with the same time stamp, there's no guarantee which way they will be retrieved (which is why I suggested $DB_RECNO).


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://275804]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (3)
As of 2018-03-19 16:45 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (244 votes). Check out past polls.