[Dbix-class] many_to_many data access

[Patrick Meidl]

On Thu, Jul 12 2012, Frank Schwach <fs5 at sanger.ac.uk> wrote:

> I agree that it should not be on the Store for sure. However, unless
> you can get the data for lnks between cities and provinces for all
> countries somehwere out there (maybe you can), I would definitely want
> to avoid having to maintain those links myself.
[...]
> Personally, unless this is really crucial data for you (e.g. if you
> must have reports grouped by provinces and therefore normalisation is
> important), I just have the state/province as a varchar field in an
> address table without any associations at all and treat this as
> free-form data.

I agree, due to such maintenance nightmares I fell back to this approach
myself before. Normalisation is great, as long as you have a reliable
data source :)

    patrick

-- 
Patrick Meidl ........................ patrick at pantheon.at
Vienna, Austria ...................... http://gplus.to/pmeidl