[wp-hackers] Data recovery

David House dmhouse at gmail.com
Sun Feb 12 23:49:03 GMT 2006

On 12/02/06, Mark Jaquith <mark.wordpress at txfx.net> wrote:
> +1 to using flags instead of another table

What exactly are the arguments against this?

> -1 to using a "trash" flag.  That would add another check to the
> WHERE clause of every posts query.  In addition to checking WHERE
> post_status="publish" we would have to check WHERE trash <> '1' or
> some such thing.  The meta approach allows us to store any additional
> information about the post (we could store when it was deleted and by
> whom) without bulking up our normal queries.  It's a bit more work
> when we restore, but that's a rare event, so that's good place to put
> the burden.

How do you intend to store the trashed items if not in a seperate
table nor in their original table? (the only way to keep them in their
original table would be to set a flag)

-David House, dmhouse at gmail.com, http://xmouse.ithium.net

More information about the wp-hackers mailing list