I'm developing an app to manage rental units where I can input tenant details, payments, and other related information. While I'm currently learning SQL through a course, I've just wrapped up the section on JOINs, but I'm uncertain if I'm on the right path. It seems like SQL will be crucial for management tasks later on, like filtering bills or tracking late payments, but it doesn't seem as relevant at the beginning stages of my project. I've heard that SQL operates differently from Excel, especially concerning automation and database structuring. Should I continue with the SQL course, how can I populate my tables, and is there something else I need to study to make this project a success? I'm a beginner in coding, and previously I ran a basic version of the app using command prompts in Python, but it was complicated. I would appreciate any guidance or feedback on where to steer my learning. Thanks!
3 Answers
I'd suggest you definitely continue with the SQL course! Building a solid foundation in database management is crucial for your app's success. Once you grasp how to design your database schema well, the Python coding and integration will make much more sense, allowing you to streamline data management.
You might want to consider why you're building this app instead of just using Excel, which is great for simple data tasks. But if you're serious about scaling up, learning SQL is essential. It’ll help you manage data more effectively in the long run. Just stick with your course for now and get comfortable with the basics before jumping into building a full GUI.
To get your data into tables, you'll want to use SQL INSERT queries. You can stick with Python since you have some familiarity already. For a simple GUI, you can create forms that allow for input, and if you're dealing with bulk data, you might be able to automate the inserts. Focus on figuring out how you can structure your inputs effectively, and don’t worry; it’s totally doable!
You can definitely manage derived data! Just set up your GUI to handle input for essential fields and then use your backend logic to loop through and create the necessary entries in other tables once the data is entered.
Thanks for your insights! But what about derived data? Like when I input tenant information, I also need to insert related data into other tables automatically. Can I handle multiple inputs in a GUI format without complicating things too much?