What’s the Best Way to Build a Personal Reading Tracker App Using SQL?

0
6
Asked By BookNerd42 On

Hey everyone! I'm starting a personal project that I'm really excited about. I want to create a database to track my books—the details like purchase date, when I read them, and ratings out of 10. I'm a data analyst familiar with SQL Server and have dabbled in Python and R. I've already set up a database, but I'm feeling a bit lost on what to do next. I have a messy SQL script for adding data, but I'd love to have a user interface to make inputting this information easier. Down the line, I'm hoping to include stats or a bookshelf display. However, I'm overwhelmed with all the programming languages and frameworks I could use. Initially, I thought about a desktop app, but maybe a web app would be better? I also have a Codecademy subscription to improve my Python skills. Any advice on how to take this project forward would be greatly appreciated!

3 Answers

Answered By TechWhiz21 On

I think a web app might be the way to go! It’s generally easier for these types of projects, plus you can access it from anywhere. Since you know Python, using a web framework like Flask or Django could be a fun way to learn by doing. Also, you can implement stats and graphs more easily in that format later on. Just a thought!

Answered By CreativeCoder47 On

Good luck with this! It’s such a fun project concept. Focusing on a web app could be a smoother route than a desktop one, especially since you’ll have access to more resources online. Plus, lots of people looking to build similar things have gone this route. You’ve got this!

Answered By ReaderGuru98 On

This sounds like an amazing project! Since you’re already into Python, I’d recommend checking out CustomTkinter for creating a GUI. It’s modern-looking and beginner-friendly. They have a great tutorial to get you started. For managing your SQL database, using an ORM like Peewee could simplify things a lot. It’s user-friendly and just right for beginners. Good luck, I can’t wait to see what you create!

Related Questions

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.