Updated DDL for SQL backend

Derek Atkins warlord at MIT.EDU
Fri Oct 27 00:06:43 EDT 2006


Quoting Benoit Gregoire <bock at step.polymtl.ca>:

>> > Fair enough, it's fixed length.  But it will make for really ugly SQL for
>> > JOINS, with the only benefit of saving four bytes.  I think using a
>> > varbinary is much preferable (and just as portable).
>>
>> Or a varchar(32) and the hexstring...  Just as portable and actually
>> human-readable (and human-enterable).   Not that I'm biased or anything
>> ;)
>
> I just didn't dare suggest it ;)

Eh, it's okay..   That's why I did.   Another benefit of using the
hexstring instead of four integers -- it makes it easy for a human
to compare the DB contents to an XML file.   And honestly, I can't
imagine the performance is going to be SO BAD that it'll be an issue.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available



More information about the gnucash-devel mailing list