[RFC] Post log/record

Note: We are moving the topics of this forum and it will be deleted at some point

Publish your own request for comments/change or patches for the next version of phpBB. Discuss the contributions and proposals of others. Upcoming releases are 3.2/Rhea and 3.3.
User avatar
EXreaction
Registered User
Posts: 1555
Joined: Sat Sep 10, 2005 2:15 am

[RFC] Post log/record

Post by EXreaction » Sat Mar 20, 2010 9:40 pm

Much like Wikipedia or some other forum software keeps records of old posts when they are edited I believe that's probably something that should be done for 4.0. Along with better logs kept for who did what this would greatly increase accountability.

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 1731
Joined: Thu Mar 02, 2006 4:29 pm
Location: Earth
Contact:

Re: [RFC] Post log/record

Post by DavidIQ » Sat Mar 20, 2010 11:27 pm

Not sure that I agree with logging EVERY single action a user makes. That would dramatically increase database size. I guess maybe having this on som sort of switch would be fine.
Image

User avatar
EXreaction
Registered User
Posts: 1555
Joined: Sat Sep 10, 2005 2:15 am

Re: [RFC] Post log/record

Post by EXreaction » Sun Mar 21, 2010 1:48 am

I am talking about recording the changes made when editing posts. Like how revisions of wiki articles are with mediawiki.

Oleg
Posts: 1150
Joined: Tue Feb 23, 2010 2:38 am
Contact:

Re: [RFC] Post log/record

Post by Oleg » Sun Mar 21, 2010 1:56 am

At many sites posts table is the largest one already. Making it even larger by storing old post revisions will make just about everything slower and increase db size. A site I used to admin wanted to remove old posts due to perceived performance impact of having so many. I suspect there is going to be demand to make this feature optional, at least once people understand how it works.

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 1731
Joined: Thu Mar 02, 2006 4:29 pm
Location: Earth
Contact:

Re: [RFC] Post log/record

Post by DavidIQ » Sun Mar 21, 2010 2:47 am

nn- wrote:At many sites posts table is the largest one already. Making it even larger by storing old post revisions will make just about everything slower and increase db size. A site I used to admin wanted to remove old posts due to perceived performance impact of having so many. I suspect there is going to be demand to make this feature optional, at least once people understand how it works.
That is exactly what I'm talking about :)
Image

Oleg
Posts: 1150
Joined: Tue Feb 23, 2010 2:38 am
Contact:

Re: [RFC] Post log/record

Post by Oleg » Sun Mar 21, 2010 3:17 am

On which note, if this feature does get implemented the old versions should probably be stored in a table other than posts (e.g. post_versions). This is how some other versioning software works (I don't know about Wikipedia).

User avatar
naderman
Product Manager
Product Manager
Posts: 1727
Joined: Sun Jan 11, 2004 2:11 am
Location: Karlsruhe, Germany
Contact:

Re: [RFC] Post log/record

Post by naderman » Sun Mar 21, 2010 6:26 am

I think this would be a very useful feature. As mentioned it should be configurable, at least an on/off switch, but I could imagine pruning options for edits/group based settings etc. And yes the data should be stored in a separate table so it does not impact query performance for regular reads.

Exreaction: Please either bring this RFC into the proper format (add it to the wiki, preferably add some more details), or move this topic to the discussion forum.

User avatar
MichaelC
Development Team
Development Team
Posts: 889
Joined: Thu Jan 28, 2010 6:29 pm

Re: [RFC] Post log/record

Post by MichaelC » Sun Mar 21, 2010 10:52 am

This would be a good feature but there should be an on/off switch, a field saying maximum disk space for old posts, leave blank for unlimited (so it limit how much db space it would use and prune old ones), a button to prune from before a selected date or prune all.
Formerly known as Unknown Bliss
psoTFX wrote: I went with Olympus because as I said to the teams ... "It's been one hell of a hill to climb"
No unsolicited PMs please except for quotes.

Rotsblok
Registered User
Posts: 325
Joined: Mon Nov 14, 2005 12:21 pm
Location: x= y+1

Re: [RFC] Post log/record

Post by Rotsblok » Sun Mar 21, 2010 2:00 pm

Unknown Bliss wrote:This would be a good feature but there should be an on/off switch, a field saying maximum disk space for old posts, leave blank for unlimited (so it limit how much db space it would use and prune old ones), a button to prune from before a selected date or prune all.
I would not limit the db space that it can use.. I would limit the number of revisions that are store. eg. 0 for unlimeted 1 for 1 revision and so on.. Because I doubt that all post are the same amount of db space
ø = 1.618033988749895...
Everything has ø in it

User avatar
imkingdavid
Registered User
Posts: 1050
Joined: Thu Jul 30, 2009 12:06 pm

Re: [RFC] Post log/record

Post by imkingdavid » Sun Mar 21, 2010 5:09 pm

Rotsblok wrote:
Unknown Bliss wrote:This would be a good feature but there should be an on/off switch, a field saying maximum disk space for old posts, leave blank for unlimited (so it limit how much db space it would use and prune old ones), a button to prune from before a selected date or prune all.
I would not limit the db space that it can use.. I would limit the number of revisions that are store. eg. 0 for unlimeted 1 for 1 revision and so on.. Because I doubt that all post are the same amount of db space
Agreed. You could have a max limit of, say... 5 revisions per post. Or even just 2 or something.

I think to add to this would be to give the moderator the ability to not only compare past revisions, but also to restore the post to an older revision (or a newer one, if it's already at an older revision). It could be helpful in some situations. :P
I do custom MODs. PM for a quote!
View My: MODs | Portfolio
Please do NOT contact for support via PM or email.
Remember, the enemy's gate is down.

Post Reply