E
E
EnderToy2021-08-08 12:28:26
Python
EnderToy, 2021-08-08 12:28:26

What is the best way to do this?

Hello. I want to write a Python program for easy data monitoring.
There is, say, a database in this form (the main database):
610fa177868d7804793169.png
And there will be a form with an ID and chapter input. Sending updates will look something like this:
610fa1e2f2fa6137113712.png
Updates must change values ​​in the main database.
I wanted to write data in json, but it seems like a bad idea

. Now the questions are:
1) I want to use TKinter to mark up the application. Is it worth it?
2) Do I need to use a database in this situation? If so, I'd prefer SQLite. Is it worth it?
2.1) For what I want it will be necessary to create two tables in the database?
3) What else do you need to know/use?
3.1) For example, to automatically update the data in the window?
3.2) What is the best way to work with date if there is no date value in the table?

PS The program has a list with the name of, say, a comic, the chapter of the comic, and the publication date of the last chapter of the comic. Separately, you need to make changes, for example, to update a comic with ID=1, you need two ID fields and a new chapter number. The date is calculated by automatically adding 5 days to the date of the last publication, if it is not less than today.
Later, I want to add actions when today's date coincides with the date of a certain chapter of the comic.

Thank you for your attention.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question