Does CSV make sense with a large amount of data?

Question

Python

For example, there are several tens of thousands of lines, each of which has cells like 'title', 'description', 'name', 'year' and others.
Does it make sense to store this in CSV for further use of this data? They will not be processed and changed, only some columns will be read by key.
Or is it better to use a database like MySQL?

Answer 1

It makes sense, especially if it's good to zip the file
It makes sense to store it in postgres if there is an active selection, filtering, etc.

tens of thousands of lines

are not large

Answer 2

CSV is good as a data transport mechanism. For example, upload a database dump somewhere, some kind of report, etc. It is more compact than JSON for tabular data.
And it is better to store the data in a DBMS. This is a good case for using SQLite.