Edit: Factor/To do/DB

See [[Factor/GSoC/2009/Improve database library]] ___ 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. # In a TV app, get the duration of each show that a user is subscribed to ___ Fixed: - problem with connection pooling and sqlite - compound primary keys - foreign keys - omitting certain columns from result tuples - finish advanced query stuff

Describe this revision:

Save