The research article explores the evolution of photocatalytic hydrogen generation and organic synthesis over the past 40 years. Since the 1970s, there has been a significant focus on utilizing photocatalysis for the generation of hydrogen (H₂) as a green fuel using solar light. This research encompasses two main approaches: overall water splitting and selective dehydrogenation of organic compounds. Notably, the selective dehydrogenation of organic compounds presents a complex area of research due to the vast variety of organic molecules that can serve as H₂ sources. The development of a 'Database of Photocatalytic Dehydrogenation Reactions' by Prof. Oleksandr Savateev and his team provides a comprehensive summary of the progress achieved in this field. The findings of the analysis outline future directions for the field, emphasizing the need for more efficient utilization of the solar spectrum and the development of new organic reactions. The database enables researchers to rank the performance of their photocatalytic systems in dehydrogenation reactions and identify promising photocatalysts for further development. Ultimately, this research contributes to the advancement of renewable energy technologies and the synthesis of valuable organic compounds in a more sustainable and efficient manner.