[wp-hackers] store all revisions of user metadata in wordpress - possible?

Jamie Currie jamie at wunderdojo.com
Fri Aug 9 22:06:31 UTC 2013


I've wondered before why the meta tables don't timestamp -- would make a 
world of things easier if they did and seems like it has a ton of 
practical application.

Jamie Currie
Founder / CEO
wunderdojo
wunderdojo.com <http://www.wunderdojo.com> | twitter.com/wunderdojo 
<http://twitter.com/#!/wunderdojo>
tel: 949-734-0758
23 Corporate Plaza Drive, Suite 100
Newport Beach, CA 92660
Master web & app developers




------ Original Message ------
From: "Nicholas Ciske" <nl at thoughtrefinery.com>
To: wp-hackers at lists.automattic.com
Sent: 8/9/2013 3:05:13 PM
Subject: Re: [wp-hackers] store all revisions of user metadata in 
wordpress - possible?
>Yes, my approach would only really work if you already knew the user id 
>(or were looping through users) and just wanted to display history. 
>Finding a user whose email used to be X would be difficult and hacky.
>
>I was going for simple ;-)
>
>A separate table would be far more flexible, but a lot more overhead 
>code wise.
>
>_________________________
>Nick Ciske
>http://thoughtrefinery.com/
>@nciske
>
>On Aug 9, 2013, at 5:00 PM, Jamie Currie wrote:
>
>>  Interesting approach, wouldn't have thought to do it that way. 
>>Wouldn't it make it challenging to do any kind of searching / 
>>filtering on the metadata though?
>>
>>  Jamie Currie
>>  Founder / CEO
>>  wunderdojo
>>  wunderdojo.com <http://www.wunderdojo.com> | twitter.com/wunderdojo 
>><http://twitter.com/#!/wunderdojo>
>>  tel: 949-734-0758
>>  23 Corporate Plaza Drive, Suite 100
>>  Newport Beach, CA 92660
>>  Master web & app developers
>>
>>
>>
>>
>>  ------ Original Message ------
>>  From: "Nicholas Ciske" <nl at thoughtrefinery.com>
>>  To: wp-hackers at lists.automattic.com
>>  Sent: 8/9/2013 2:40:15 PM
>>  Subject: Re: [wp-hackers] store all revisions of user metadata in 
>>wordpress - possible?
>>>  Try storing all meta data for that user in a serialized array -- add 
>>>entries indexed by meta key & timestamp whenever something changes, 
>>>then query the history array to display change history for all or one 
>>>item.
>>>
>>>  Make sure you avoid recursion and don't track the history of the 
>>>history meta data (or store it in an option with the user_id in the 
>>>key name).
>>>
>>>  _________________________
>>>  Nick Ciske
>>>  http://thoughtrefinery.com/
>>>  @nciske
>
>_______________________________________________
>wp-hackers mailing list
>wp-hackers at lists.automattic.com
>http://lists.automattic.com/mailman/listinfo/wp-hackers



More information about the wp-hackers mailing list