emehrkay Posted October 6, 2007 Share Posted October 6, 2007 With all of the revisions? When a change is made, is the whole body saved, or just the change? If just the revision is kept, how exactly is that done? Is the current version and older versions kept in the same table or are they moved to another one? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/72134-how-does-a-wiki-database-work/ Share on other sites More sharing options...
btherl Posted October 9, 2007 Share Posted October 9, 2007 If you're thinking of wikipedia, they use the mediawiki package. Other wikis use different software, and each package represents the data in its own way. So there's no single answer to your question.. Quote Link to comment https://forums.phpfreaks.com/topic/72134-how-does-a-wiki-database-work/#findComment-365093 Share on other sites More sharing options...
phpFirstJoy Posted October 9, 2007 Share Posted October 9, 2007 I'm interested in this too. Would it be easier to simply make a "snapshot" of the original, change it, and store it? I don't know how memory intensive this would be for large chucks of text but if it's not much then it sounds like the easiest way to do it. You can even compare the changes from the most current version with the previous versions with a simple character-by-character comparison I would believe. Or maybe for each revision, the original document is only changed with dated tags around the original part. Subsequent changes to that part would result in more tags like so... Original [010120071201]1st revision to [/010120071201]original (Jan. 1, 2007 12:01am) [010120071201][010220071201:2]1[/010220071201]nd revision to [/010120071201]original (Jan. 2, 2007 12:01am with change from 1 to 2) Output: Original 1st revision to original 2nd revision to original and so forth. Then we can parse the timestamped tags and show the most recent changes (if the user requests that) or an earlier version. Well... scratch that... this looks too complicated I'm sure there's an easier way. Quote Link to comment https://forums.phpfreaks.com/topic/72134-how-does-a-wiki-database-work/#findComment-365244 Share on other sites More sharing options...
btherl Posted October 9, 2007 Share Posted October 9, 2007 Apparently mediawiki stores the entire text of each revision, in the text table here: Mediawiki db schema Quote Link to comment https://forums.phpfreaks.com/topic/72134-how-does-a-wiki-database-work/#findComment-365255 Share on other sites More sharing options...
emehrkay Posted October 9, 2007 Author Share Posted October 9, 2007 Apparently mediawiki stores the entire text of each revision, in the text table here: Mediawiki db schema Ahh thank you for the schema layout!! Quote Link to comment https://forums.phpfreaks.com/topic/72134-how-does-a-wiki-database-work/#findComment-365379 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.