Re^6: Moving from SQL to flat-files

Actually, I don't mind bigger that much. I just wanted to confirm if I was doing something wrong, and if there was any other way of getting a count of all the records.

Once I know all the "gotchas" I can make a decision.

Many thanks,

--

when small people start casting long shadows, it is time to go to bed

Comment on Re^6: Moving from SQL to flat-files

Replies are listed 'Best First'.
Re^7: Moving from SQL to flat-files by dragonchild (Archbishop) on May 11, 2006 at 18:42 UTC
I don't think I was as clear as I needed to be. Try the following code with a hash tied against the various DBMs. `use Data::Dumper; # %x is the tied hash. $x{foo} = [ 1 .. 3, { a => { b => 'c' } } ]; print Dumper \%x;` [download] Using DBM::Deep, the following will be printed: `$VAR1 = { 'foo' => bless( [ '1', '2', '3', bless( { 'a' => bless( { 'b' => 'c' }, 'DBM::Deep::Hash +' ) }, 'DBM::Deep::Hash' ) ], 'DBM::Deep::Array' ) };` [download] Ignoring the random blessings, the entire data structure as Perl would see it is encoded. Using BerkeleyDB, you see `$VAR1 = { 'foo' => 'ARRAY(0x18014f4)' };` [download] Note: this is as designed for BDB - it isn't meant to handle anything as the value other than a simple binary string. DBM::Deep is. My criteria for good software: Does it work? Can someone else come in, make a change, and be reasonably certain no bugs were introduced?	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^7: Moving from SQL to flat-files
by dragonchild (Archbishop) on May 11, 2006 at 18:42 UTC

use Data::Dumper;

# %x is the tied hash.
$x{foo} = [ 1 .. 3, { a => { b => 'c' } } ];
print Dumper \%x;
[download]

DBM::Deep

$VAR1 = {
          'foo' => bless( [
                            '1',
                            '2',
                            '3',
                            bless( {
                                     'a' => bless( {
                                                     'b' => 'c'
                                                   }, 'DBM::Deep::Hash
+' )
                                   }, 'DBM::Deep::Hash' )
                          ], 'DBM::Deep::Array' )
        };
[download]

BerkeleyDB

$VAR1 = {
          'foo' => 'ARRAY(0x18014f4)'
        };
[download]

Note: this is as designed for BDB - it isn't meant to handle anything as the value other than a simple binary string. DBM::Deep is.

My criteria for good software:

Does it work?
Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

[reply]
[d/l]
[select]