So for Wiki Pages and ticket comments it stores each change as a whole,
but for tickets it uses a diff?
Thanks for your help.
The idea of storing the same information for every revision at first
seems to be a waste of space, however going back to my earlier concerns
of data corrupting, redundancy could be useful. Not to mention storing
and loading the whole page instead of building from diff data would most
likely be faster.
Steffen Hoffmann wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 31.01.2013 19:20, Mike Doroshenko II wrote:
Finally, when I save a page is the entire page contents stored in the
database again or just the changes. So having "1" then editing to "12"
would store "1" then "12" opposed to storing "1" then saying something
like "add 2 to the contents of the page". Then editing to just "2" would
store "1" then "12" then "2" opposed to storing "1" saying "add 2" then
"remove 1." I hope that makes sense...
At least this is easy for me: Trac stores the whole content per
version/revision for wiki pages. Tickets have the current values plus a
separate table for all changes - old and new value per field, pretty
much like your idea about storing "diff" data.
Ticket comments are editable (since 0.12 IIRC) and these revisions are
stored with the full wiki text again, like for wiki page.
Steffen Hoffmann
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAlEK3+8ACgkQ31DJeiZFuHc5HwCfVj211raxIv7WvwaTRXSNvhhM
M7IAoIQ5yvGbDUQImLYphjY2ZKo+zxBi
=h+Dd
-----END PGP SIGNATURE-----
--
Mike Doroshenko, Junior Sys Admin
TecKnoQuest Inc.
mi...@tecknoquest.com
www.tecknoquest.com
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to trac-users+unsubscr...@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at http://groups.google.com/group/trac-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
