Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

2009-02-18 Thread Charlie Clark
Am 18.02.2009, 00:58 Uhr, schrieb jpe...@ykksnap-america.com: Using external methods will be more work for the zope writer. I don't know enough to comment seriously on security issues, but I think that using procedures, like using bind variables, will make SQL Injection much harder. The

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

2009-02-18 Thread Remy Pinsonnault
Thanks for your help! Rémy On Wed, Feb 18, 2009 at 3:53 AM, Charlie Clark char...@egenix.com wrote: Am 18.02.2009, 00:58 Uhr, schrieb jpe...@ykksnap-america.com: Using external methods will be more work for the zope writer. I don't know enough to comment seriously on security issues, but

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

2009-02-18 Thread Charlie Clark
Am 18.02.2009, 20:24 Uhr, schrieb Allen Schmidt Sr. aschm...@fredericksburg.com: Hey Charlie, What timing. I am having my server guys drop the trial egenix zope da in place as I write this. Seeing too many errors and oddities with the ancient MySQLDA we use now. Planning on converting

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

2009-02-18 Thread Allen Schmidt Sr.
I understand. Thanks. Did not realize there was a new version of the python/zmysqlda available. Thanks for that info. Would really like to use the mx connectors but at this point if I can use an updated free one and it works, then I need to do that. And no, all our stuff is in the ZODB as

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

2009-02-18 Thread Charlie Clark
Am 18.02.2009, 21:36 Uhr, schrieb Allen Schmidt Sr. aschm...@fredericksburg.com: I understand. Thanks. Did not realize there was a new version of the python/zmysqlda available. Thanks for that info. Would really like to use the mx connectors but at this point if I can use an updated

[Zope] Stored Procedures Versus ZSQL Methods

2009-02-17 Thread Remy Pinsonnault
Hello, We have a Zope application with thousands of Z SQL methods connected to an Oracle Database. Our DBA want us to develop our new applications using stored procedures called through external methods, instead of using directly Z SQL methods, for performance issues and memory usage. Do stored

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

2009-02-17 Thread JPenny
] Stored Procedures Versus ZSQL Methods Hello, We have a Zope application with thousands of Z SQL methods connected to an Oracle Database. Our DBA want us to develop our new applications using stored procedures called through external methods, instead of using directly Z SQL methods

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

2009-02-17 Thread JPenny
...@caltech.edu 02/17/2009 06:44 PM To jpe...@ykksnap-america.com cc Remy Pinsonnault remypinsonna...@gmail.com, zope-db@zope.org Subject Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods Quoting jpe...@ykksnap-america.com jpe...@ykksnap-america.com: Yes, with a stored procedure the DB does