http://www.perlmonks.org?node_id=132514


in reply to Database normalization the easier way

I would not use standalone namespace for module which basically does just one thing. IMHO your module belongs to DBIx::

It would be cool if it were not used MySQL specific code. There exist some modules which allow to do database schema operations in more portable way: Alzabo, DBIx::DBSchema.

Anyway idea is very intersting. It is sad I have no votes left :(.

--
Ilya Martynov (http://martynov.org/)

  • Comment on Re: Database normalization the easier way

Replies are listed 'Best First'.
Re: Re: Database normalization the easier way
by gmax (Abbot) on Dec 18, 2001 at 18:54 UTC
    My initial idea was to ask for a DBI:: namespace, but yesterday I found out that such namespace is restricted. Then DBIx:: is a good candidate (Or it should be as soon as I get an answer from CPAN. Being in a monastery, I should become used to being patient {grin}).
    DBIx::DBSchema was a good hint. I checked it and it seems to provide enough information to replace the direct calls I am using so far.
    I would need to rewrite the two subs that are dealing with column information (so many greps and maps wasted!) but this is a good chance to make the module portable across databases.
    Thanks.
    gmax