What will be the easiest way of storing a python listing of amounts (for example [4, 7, 10, 39, 91]) to some database? I'm while using Pyramid framework with SQLAlchemy to speak to some database.
Thanks!
Well conceptually you are able to store a listing as a lot of rows inside a table utilizing a one-to-many relation, or focus regarding how to store a listing inside a particular database after sales. For instance postgres can store an assortment inside a particular cell while using sqlalchemy.dialects.postgres.ARRAY data type which could serialize a python array right into a postgres array column.
Use string(Varchar). From Zen of Python: "Simple is preferable to complex."