[TYPO3-dev] Request for cleanup of typo3 database schema

[R. van Twisk]

Sven Wilhelm wrote:
> Hi,
>
>   
>> No, he isn't. He wrote: "I'd like to request the start for a cleanup of
>> the typo3 database schema.". He requests something, not asks for
>> comments...
>>     
>
> make it short. the same evening I started with the task as we get problems
> with the scalability of mysql. the myisam format is bad for scaling as it
> locks complete tables, innodb "scales a little bit better" but blows up the
> required space and a mix of both formats is bad.
>
> so we have the requirements to migrate to postgres very fast.
>
> I started to cleanup all int(xx) fields to INTEGERS, most int(1|3|4) to
> BOOLEAN and all blob types to TEXT.
>
> I converted varchar fields to the 3 lenght 64/128/255.
>
> maybe some one thinks that's a bad idea to simplify it this way, I will know
> much more after the weekend.
>
> for a more advanced data management one shouldn't think in varchar or
> something else but in datatype email (varchar(64)), url (varchar(255)),
> document title (varchar(64/128/255)), name(varchar(64))
>
> this way I do the cleanup.
> will send a draft after my own tests on start of next week.
>
> kind regards
>
>
> sven
>
>
>   
Hey Sven,

nice project you have going...
What you can do for most, if not all text fields is convert them simply 
to TEXT.
Under the hood of PG TEXT and VARCHAR are the same except
that VARCHAR put a constraint to the length of the field. Whoudl that help?

Ries