Good of One vs. Good of Many

--- Derek Neighbors <derek@gnue.org> wrote:
> Alex LeDonne said:
> > If you want something that looks like a table for each day, you can
> > create views. When I have to look at schema design, I now take as a
> > general rule that anything resembling a "table with data in the
> table
> > name" should really be created as a view.
>
> Alex I agree with your assessment, but to my knowledge MySQL is still
> a
> very feature poor RDBMS and at this time still lacks an
> implementation of
> "views". I could be wrong, but that was the case last time I reviewed
> its
> feature sets.
>
> I agree with the recommendation to use views, but I think they are
> not
> available for MySQL users. :)
>
> -Derek

Derek, you are correct, of course; as I mentioned, my MySQL is a bit
rusty. So I suppose I should follow up by adding, "and if you really
need views in a free RDBMS, look at PostgreSQL."

-Alex

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/