What goes into rolling your own wiki using c# and sql?
I agree with all the answers. Wikis normally handle every edit as a new record inside the database.
Note that the full text of each revision is stored in a
MEDIUMBLOB field in the
I just wrote a wiki in C# actually. One thing I would add to everyone else's comments is that you'll want to make sure you can compare two versions. For doing this in C# I strongly suggest the C# implementation of the diff_match_patch library from Google. It's quite fast and it's quite easy to extend if you need more in the way of pretty printing or handling of structured text like HTML.