On Tue, Mar 8, 2011 at 6:33 AM, Dave Howorth <[email protected]> wrote: > I have to connect to a database that is basically stable but where one > particular ENUM column might have a different set of values when I > connect to it each time. (I know this is not ideal). I'm looking for the > least evil way to do this.
> Or perhaps there's a simpler way to do the whole thing? Oh lord yes. If you can, make yourself a lookup table and ditch the enums. There's a certain glittery appeal to enums when you start a project ... over time, as your data grow, they become a massive headache. (I can tell a story about a 500M row table, MySQL 4, and an enum change that, once all was said and done, involved a binary edit of the format file.) On the other hand, if you can't tweak your schema, I hope someone has a reasonable answer for you, I'm afraid I don't. k. -- kevin montuori _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
