We currently have some intentional denormalization in our database e.g.:
  • counts such as: user reputation, article issue and follower counts, issue comment and follower counts
  • nested sets
These dernormalizations are not ideal, but they make things a bit easier, and some of them are almost certainly faster.
To keep things slightly saner, the web/bin/normalize script can be used to view, check and update dernormalized data.


  1. OurBigBook Web database
  2. OurBigBook Web deployment
  3. OurBigBook Web development
  4. OurBigBook Web
  5. OurBigBook Project