http://qs321.pair.com?node_id=169071


in reply to Re: XML for databases?!?! Is it just me or is the rest of the world nutz?
in thread XML for databases?!?! Is it just me or is the rest of the world nutz?

Normally, had their contents been deliberately encrypted we understand you could have used the latest quantum computing techniques to crack the code. But, since Dr. Shrum chose to use a data format that had been lost in the winds of time, decipherment proved impossible

Hmm... Let's see...

# cd /var/lib/postgres/data/pg_xlog # strings 0000000000000011 | more Serial 026324 Serial 5699K11353 cn 29L02 Roof fans Mfg Greenheck Roof fan serial OOC23697 ...
Looks like postgres (and, in my experience, most other databases) stores its data internally as plain text unless deliberately encrypted or compressed. Yeah, I'll give you that strings isn't likely to tell you the structure of the data, but getting at the content without going through the database engine is trivial.

Replies are listed 'Best First'.
Re: Re: Re: XML for databases?!?! Is it just me or is the rest of the world nutz?
by mojotoad (Monsignor) on May 24, 2002 at 14:52 UTC
    Yes, you squarely nailed the weak spot in my parable. I winced when I wrote that bit, but then shrugged in favor of artistic license. The idea that a lost data format could somehow be more incomprehensible than deliberately encrypted data is of course ludicrous. Matt