updated pubdate view. start work on DB.