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 unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



[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? Thanks.

 

-- 
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/-/5kKo3n8yXkAJ.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



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 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? Thanks.
 
 
 
 -- 
 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/-/5kKo3n8yXkAJ.
 To post to this group, send email to sqlalchemy@googlegroups.com.
 To unsubscribe from this group, send email to 
 sqlalchemy+unsubscr...@googlegroups.com.
 For more options, visit this group at 
 http://groups.google.com/group/sqlalchemy?hl=en.
 

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.