"BV" == Brion Vibber brion@pobox.com writes:
BV> Comments? Ideas? Complaints?
Well, my first feeling is that this looks very, very sweet and I think it is probably a big step in the right direction.
My second feeling is that maybe we should brainstorm a bit about some common features of the software, and make sure that we know how they're going to work with this new schema. Some things off the top of my head:
* Given a title, display a page * When displaying a page, show broken links * Display an old version of a page * Display the history of a page * Display the diffs between two version * Save a new page * Save a new version of an existing page * RecentChanges * Newpages * Show user contributions * Full-text search * Go button * Long pages, short pages * Stub detection * Redirecting * What links here
As I'm going through this list, nothing here sticks out at me as being particularly awkward in the design you gave. Which is probably good.
Oh, OK, so, I have one more feeling, which is: these are pretty major tables, so this would be a pretty sweeping change. It'll destabilize the software for a while, with only some marginal benefit to end-users (better performance, probably, and probably some more robust query features).
Anyways, my $0.02.
~ESP