Re: [Postfixadmin-devel] database setup

[Farkas L. <lf...@bp...>]

Christian Boltz wrote:
> Hello,
> 
> Am Donnerstag, 11. Oktober 2007 schrieb Farkas Levente:
>> i wouldn't like to go into the detailed discussion of database. just
>> a few of my thoughts:
>> - i would like to keep all of my database utf-8. otherwise always
>> happened something wrong.
> 
> Can you define "something wrong happened", please?
> I agree we need to use utf8 on fields like "description" which can 
> contain text in any language.
> 
> However, fields like "domain" and "email" should be latin1 to avoid the 
> utf8 overhead. Or do you really use utf8 in domain names and mail 
> adresses? (I even doubt it is allowed.)

i agree with that IF the database is utf-8 and those char field which
are not needed to be utf-8 are latin1, but i prefer this way and not the
opposite when the database it latin1 and some field are utf-8!

>> - i don't like innodb since it creates a never ending growing files.
> 
> I never tested innodb in detail, but if this really happens, I would 
> consider it worth a bugreport against MySQL (unless it is expected 
> behaviour or a known bug ;-)

it's well know imho you can find it after some google:-(

> BTW: The reason why InnoDB is used is the foreign key with automatic 
> cleanup (DELETE CASCADE). Maybe we could do it manually instead.

i understand the reasons i just tell my preferences.

>> probably the best choice would be falcon, but the it'll be released
>> only next year. 
> 
> That's too late - and we want to have the least-possible requirements.
> (In other words: we'll wait a year or two after release until we use 
> falcon.)

or we can define an alternative/testing database setup for falcon.

-- 
  Levente                               "Si vis pacem para bellum!"