On Sunday 02 July 2006 18:21, Michael Bayer wrote: > On Jul 2, 2006, at 5:32 AM, Tzahi Fadida wrote: > > Hi, > > Sorry for the mass questions, i tried to concentrate these so as > > not to flood > > the mailing list :) : > > *How do i add a column to an existing table and > > yah SQLAlchemy has no role in schema management; youd have to issue > ALTER TABLE statements manually.
Can i mix SQLObject to do the schema management and SQLAlchemy without them stepping on each other toes? Are there other packages to do schema management to consider (aside from, hopefully, very usefull SQLAlchemy based migration project like in ruby on rails). Basically i could use Ruby on Rails migration scripts but that means the target server will also have to install ruby :). I am planning to make a lot of schema namespaces in the database and i am counting on automation to manage them. > > *Using ORM, are there any security problems in serializing (pickling) > > a User() object (of users_table) and sending it to a client from > > the server? > > if youre sending a cleartext password over the wire, sure. pickling > is not an encrypted format. Well, i meant if there was any residual information non-related to the table. I.e. passwords of the database, etc... Basically i only want to pickle and send the information from the row of the table and not things like magically added functions or non related objects. 10x. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
