What is the best way to store large lists in SQLite?

Question

SQLite

Tell me, how is it better to store a long list of lines of 10-20 characters in a SQLite database (some reach a length of about 1500 such lines) as a BLOB object, or is it better to create a second table in the database and systematize it inside it by linking both tables?

Answer 1

Depends on how you are going to work with this data.
If they are always stupidly read as a whole, then it is possible in blobs.
If they participate in WHERE, or sometimes it is necessary to pull out only a part, then it is better to a new table