The MySQL thing was just general advice. MySQL and MariaDB are far behind other DBs in features at this point, with a few exceptions. There are probably too many concurrency issues to effectively use SQLite for a website of this nature, but it works great for home projects and personal wikis. They recommend using a different RDBMS for over 100K website requests a day, which, given there are nearly 200K pages of content, would rule it out.
Anyway, I was discussing this with a friend, who reminded me that all wiki software sucks. With that in mind, I decided to make a list of features that I felt were absolutely necessary, and those with lower priority. Please tell me if there's anything that I missed, or feel free to quibble about the ranking:
Must have:
* No ads: no excuses.
* Spoiler markup
* Folder Control: make a way to hide a div on a click.
* Image uploads.
* Indexes: ability to tag/categorize pages
* Subpages: at least 2 level pages.
* Talk pages: Discussion Pages
* LinksHere: backlinks aka related pages
* Logins
* Unicode support
Should probably have:
* A context element that lists all of a page's subpages.
* A comments bar (form): to replicate YTTKW; also good for user (talk) pages.
Nice things:
* Index Trace: navigation through indeces ()
* Subpages: at least 3 level pages, preferably arbitrary.
* Custom page titles OR unicode pagename support (e.g. Ranma ½)
* Includes
* Full page histories
Low priority:
* Tables: I never see tabular data in the tropes
* Colored text markup
* Floating boxes: markup like [[floatboxright:] isn't all that necessary
* Page templates
Iffy:
* GUI Editor: Nice, but maybe too nice -- possibly attracts the wrong kind of user.
Should not have:
* Integrated forums. If they're absolutely necessary, they can be done separately. Trope repair can be handled through the talk pages. Removing forums avoids community split, and there are countless sites on the web to discuss your favorite shows.
-- ∇×V
Anyway, I was discussing this with a friend, who reminded me that all wiki software sucks. With that in mind, I decided to make a list of features that I felt were absolutely necessary, and those with lower priority. Please tell me if there's anything that I missed, or feel free to quibble about the ranking:
Must have:
* No ads: no excuses.
* Spoiler markup
* Folder Control: make a way to hide a div on a click.
* Image uploads.
* Indexes: ability to tag/categorize pages
* Subpages: at least 2 level pages.
* Talk pages: Discussion Pages
* LinksHere: backlinks aka related pages
* Logins
* Unicode support
Should probably have:
* A context element that lists all of a page's subpages.
* A comments bar (form): to replicate YTTKW; also good for user (talk) pages.
Nice things:
* Index Trace: navigation through indeces ()
* Subpages: at least 3 level pages, preferably arbitrary.
* Custom page titles OR unicode pagename support (e.g. Ranma ½)
* Includes
* Full page histories
Low priority:
* Tables: I never see tabular data in the tropes
* Colored text markup
* Floating boxes: markup like [[floatboxright:] isn't all that necessary
* Page templates
Iffy:
* GUI Editor: Nice, but maybe too nice -- possibly attracts the wrong kind of user.
Should not have:
* Integrated forums. If they're absolutely necessary, they can be done separately. Trope repair can be handled through the talk pages. Removing forums avoids community split, and there are countless sites on the web to discuss your favorite shows.
-- ∇×V