SQLAlchemy: JSON vs. PickleType vs. raw string for serialised data

Greg Ewing greg.ewing at canterbury.ac.nz
Mon Feb 28 17:16:32 EST 2022


On 1/03/22 6:13 am, Albert-Jan Roskam wrote:
>     I think you need a
>     BLOB. https://docs.sqlalchemy.org/en/14/core/type_basics.html#sqlalchemy.types.LargeBinary

That won't help on its own, since you still need to choose a
serialisation format to store in the blob.

I'd be inclined to use JSON if the data is something that can
be easily represented that way.

-- 
Greg



More information about the Python-list mailing list