June 25, 2025
I created a Python CLI app using mysql.connector
to track books I’ve read. This is my first time using SQL with Python, and I learned about creating tables, inserting and querying data. One challenge was parsing optional user input for ratings and ensuring NULL values worked properly. I also learned about GROUP BY
and AVG()
to generate stats. In the future, I want to add user authentication and maybe a GUI.
A command-line reading log built with Python and MySQL that allows users to track books, manage a wishlist, and view reading statistics.
This was widely regarded as a great move by everyone.