[wp-trac] [WordPress Trac] #15332: dbDelta($query) - do not create view

[WordPress Trac]

#15332: dbDelta($query) - do not create view
----------------------------------------------+----------------------
 Reporter:  christian_gnoth                   |       Owner:
     Type:  feature request                   |      Status:  closed
 Priority:  normal                            |   Milestone:
Component:  Database                          |     Version:  3.0.1
 Severity:  normal                            |  Resolution:  wontfix
 Keywords:  reporter-feedback, needs-usecase  |
----------------------------------------------+----------------------
Changes (by dd32):

 * status:  reopened => closed
 * resolution:   => wontfix
 * milestone:  Awaiting Review =>


Comment:

 After reviewing http://dev.mysql.com/doc/refman/5.0/en/alter-view.html
 i've come to the conclusion that, whilst views are nice, As core doesn't
 currently use them, and it falls outside of the scope of the original
 intention of dbDelta(), that really, supporting views seems like a wasted
 effort, Given that the few plugins that require them, can do so with very
 simple code already.

 In the event that using views becomes more common amongst plugins, or core
 requires them, then that's when we should support them IMO.

 As it is, I try to discourage people from using custom tables if the data
 can somehow be sloted into WordPress's API, in your case, it probably
 can't be, but until it's a common problem..

 Someone can re-open this in a few years if the times change, or it's no
 longer feasible to continue the manual way.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/15332#comment:10>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software