Compact and hypercomplete categories