[Typo3-dev] RFC: TYPO3, Kickstarter and M-M database relations

[Andreas Schwarzkopf]

Hi Peter,

Peter Niederlag schrieb:

> 'commalist of values' makes some operations truely difficult or
> expensive. For example "give me all users that belong to usergroup 234"
> can only be done by some expensive and error-prone "LIKE ..."
> SQL-construct or PHP-operation on the Result-Set.

FIND_IN_SET('needle',field) works pretty good though it is not standard 
compliant and can be not used with the DBAL - therefore also not a 
stable solution

> 
> Also M-M-relations as 'commalist of values' does prevent the usage of
> Object-Relational-Toolkits such as Propel (PHP-based,
> http://propel.phpdb.org/trac/) or Hibernate (Java-based) from being a
> choice for data-handling or at least make it very, very difficult.
> 
> ---------------------
> My suggestions:
> ---------------------
> 
>  * Switch to a true M-M-relation by default in the Kickstarter as soon
> as possible, leaving 'commalist of values a user-choice with an
> explanatory "warning"

+1

>  * Use true M-M relations for any new stuff possibly introduced in the
> TYPO3-core

+1

>  * Cleaning up of any 'commalist of values' in TYPO3-core for Version 5.0
+1 (IMHO not in earlier versions)

grtx

Andreas