Factor/To do/DB
- omitting certain columns from result tuples
- finish advanced query stuff
i want these operations to be performed with a constant number of queries:
- get the most recent 20 posts, by date. Get the number of comments in each post.
- get the number of posts per month, in the last 12 months.
- delete all posts with uid=$1, delete all comments whose parent post has uid=$1, delete all comments with uid=$1
- delete all annotations with parent paste=$1, delete paste with id=$1.
Fixed:
- compound primary keys
- foreign keys
This revision created on Tue, 30 Sep 2008 05:14:15 by erg