NYCPHP Meetup

[Tim Gales]

On 07:56 AM Kenneth Downs wrote:
> It is not so much implementing views as giving users a way to specify
> views.  Since a view is just a stored query, it is just as well to
> generate the query at run-time if doing so gives more flexibility to 
> the user.  
 > A view on the other hand must be defined by an administrator
> and so is outside normal user activity. 

Creating views is not outside user activity:
Create_view_priv has been available since MySQL 5.0.1.

Originally Allen asked am I just reinventing
the wheel.

I would say he is not *just* reinventing views --
this approach could be quite valuable to
people with a dbms that doesn't implement views.

The tree he described is reminiscent of a syntax tree.

So, taking a look at:
http://www.dbs.ethz.ch/education/isk/WS_97/syntax_diagramme/sld004.html

might spark some ideas.

-- 

T. Gales & Associates
'Helping People Connect with Technology'

http://www.tgaconnect.com