python - Is using a string instead of a list to store multiple values going to work?

Question

I'm using sqlalchemy currently but I can't store multiple values in a column. The only values I can put in a db are strings, int, etc. but not lists. I was thinking what if I wanted a list of integers and I just made it a string in this format: "1|10|91" and then split it afterwards. Would that work or would I run out of memory or something?

Answer 1

It should work, in case you take care of the length of the column string in the database. So, for this case, it's better to use Text type column which has extended size in most of the database servers.

class model_name(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    integer_values = db.Column(db.Text)