Photosynthetic microorganisms achieve long-lasting and renewable chemical production