Re: [Postfixadmin-devel] database setup

[Christian B. <pos...@cb...>]

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 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 ;-)

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

> - i like to use mysql.

I also ;-)

> 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.)

> so i don't know the solution but something better then the current.

:-(


Regards,

Christian Boltz
-- 
Now I hope the best for my seven 1.44MB disks, oh yes, very old ...
and I feel about 8 years younger by copying files to disks.
[Thomas Porschberg in opensuse]