What is better to use: xml \ json file or SQLite for storing information (150-200 records)?

Question

Python

Good afternoon!
Software is planned with a database of organizations (name, contacts, etc), about 150-200 organizations, the software is launched locally on one PC, one user. Under Windows. Question: to shove everything into SQLite or is it really possible to shove all this into xml and not take a steam bath? requests to the "base" will be about 50 per day.

Answer 1

I do not quite understand in your case about "do not bathe." Judging by the task, the complexity and amount of code will be approximately the same for all types of storage, but I would still prefer the database, since it will be more flexible for various improvements.

Answer 2

Under your task there is not much difference.
I would take JSON - because of its flexibility. Because in reality, with a high probability, the records will be heterogeneous - some company has one contact person, and some has several; some may have different variants of the name; for some it will be necessary to store some additional information, etc.
It will be more difficult to save this in a relational database than in json.

Answer 3

JSON is not meant to store information, it's useful for passing structures.
So choose xml or sqlite.
Depends on what exactly is more convenient for you to implement.