[TYPO3-dev] RFC: Change roadmap for 4.5 and 5.0

[Johannes Reichardt]

Hi,

Thanks for the Info on that topic. Would speed things up i guess.
I´d even propose to think about merging the BE and the FE to make things 
less complicated. What you think?

- Johannes
> Johannes Reichardt wrote:
>
>   
>> Hi Thomas,
>>  
>>
>>     
>>> I have to add a wish for the next version.
>>> Please think about the database structure. The TYPO3 DB is not even in the first 
>>> normal form! I know that this will end up in an incredible amount of tables in 
>>> the database but it would be much more elegant in many cases!
>>>  
>>>    
>>>
>>>       
>> Just interested since i have not many DB knowledge in theory - what 
>> exactly do you mean?
>>  
>>
>>     
> Correct if I'm wrong, but Thomas means that there are several columns in 
> Typo3 database that are used to store multiple values, while the 
> correct, normalized representation would be to turn the column into a 
> separate table and link the two using foreign keys.
>
> An example is the usergroup field in the be_users table. It stores all 
> groups the user belongs to in a single column like this: 
> "22,6,9,10,7,20,14,8". For this table to be in 1st normal form, you 
> would need to create another table, called, say "usergroups" and store 
> these rows (assuming the user above has uid=1):
>
> User_uid | Group_uid
> 1 | 22
> 1 | 6
> 1 | 9
> 1 | 10
> 1 | 7
> 1 | 20
> 1 | 14
> 1 | 8
>
> Google for more information on this. Use these keywords: database 
> normalization, normal forms, 1NF. Here are some examples:
> http://databases.about.com/od/specificproducts/a/normalization.htm
> http://databases.about.com/od/specificproducts/l/aa1nf.htm
>
>   
>> - Johannes
>>
>>
>>  
>>
>>     
>>> Greets,
>>> Thomas
>>>
>>>
>>> --
>>> typo3-unleashed.net
>>> _______________________________________________
>>> TYPO3-dev mailing list
>>> TYPO3-dev at lists.netfielders.de
>>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>>>
>>>  
>>>    
>>>
>>>       
>> _______________________________________________
>> TYPO3-dev mailing list
>> TYPO3-dev at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>>
>>  
>>
>>     
>
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>
>