Re: [sqlalchemy] How to use BLOB datatype in alembic tool to support Postgresql?

2012-10-31 Thread junepeach
Thanks. Yes it works fine now. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/-Cx--STwfO4J. To post to this group, send email to sqlalchemy@googlegroups.com. To

[sqlalchemy] How to use BLOB datatype in alembic tool to support Postgresql?

2012-10-30 Thread junepeach
We want to support as many databases as we can. Right now we have BLOB data type defined in our database schemas, both sqlite3 and mysql work fine with Alembic migration tool on that data type, however it failed on Postgresql. How should we handle that if we really want to use BLOB datatype?

Re: [sqlalchemy] How to use BLOB datatype in alembic tool to support Postgresql?

2012-10-30 Thread Mike Bayer
take a look at LargeBinary: http://docs.sqlalchemy.org/en/rel_0_7/core/types.html#sqlalchemy.types.LargeBinary On Oct 30, 2012, at 2:27 PM, junepeach wrote: We want to support as many databases as we can. Right now we have BLOB data type defined in our database schemas, both sqlite3 and