Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-12-13 Thread Jerry B. Altzman
I know this isn't a MySQL list, but ... on 12/12/2010 7:52 AM Justin Dearing said the following: On Sun, Dec 12, 2010 at 2:12 AM, Jerry B. Altzman mailto:jba...@altzman.com>> wrote: I just encountered my first real one. It's on a MySQL on a Windows platform--someone from the MSSQL world,

Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-12-12 Thread Justin Dearing
On Sun, Dec 12, 2010 at 2:12 AM, Jerry B. Altzman wrote: > I just encountered my first real one. > It's on a MySQL on a Windows platform--someone from the MSSQL world, no > doubt. > Just got bitten hard by it, migrating from 5.0 to 5.1 has slightly > different schemata in the mysql.mysql database,

Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-12-11 Thread Jerry B. Altzman
Yes, I'm replying to my own message. on 11/10/2010 3:31 PM Jerry B. Altzman said the following: How many of you are using stored procedures (SPROCs) with any great regularity? I just encountered my first real one. It's on a MySQL on a Windows platform--someone from the MSSQL world, no doubt.

Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-11-16 Thread Gary Mort
On Wed, Nov 10, 2010 at 3:31 PM, Jerry B. Altzman wrote: > Hi all, > > Just a question for those of you out there dealing with the F/OSS RDBMS's > out there: > > How many of you are using stored procedures (SPROCs) with any great > regularity? > > I know that in the commercial database world use o

Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-11-10 Thread David Krings
On 11/10/2010 16:37, Rob Marscher wrote: On Nov 10, 2010, at 3:31 PM, Jerry B. Altzman wrote: I know that in the commercial database world use of stored procedures is The Way Things Are Pretty Much Done, but I've not seen it in my brief forays through the bulk of PHP code I've examined (and ne

Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-11-10 Thread Paul A Houle
On 11/10/2010 4:48 PM, David Wang wrote: I'll second this. The problem i've always had in the past with sprocs is that it adds another layer of abstraction to the business logic and difficult to manage changes for. I've always told my developers to move it out of the sprocs and into the code

Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-11-10 Thread David Wang
I'll second this. The problem i've always had in the past with sprocs is that it adds another layer of abstraction to the business logic and difficult to manage changes for. I've always told my developers to move it out of the sprocs and into the code so we see what's going on and can manage c

Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-11-10 Thread Rob Marscher
On Nov 10, 2010, at 3:31 PM, Jerry B. Altzman wrote: > I know that in the commercial database world use of stored procedures is The > Way Things Are Pretty Much Done, but I've not seen it in my brief forays > through the bulk of PHP code I've examined (and needless to say, written). Am > I just

Re: [nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-11-10 Thread Chris Snyder
On Wed, Nov 10, 2010 at 3:31 PM, Jerry B. Altzman wrote: > Hi all, > > Just a question for those of you out there dealing with the F/OSS RDBMS's > out there: > > How many of you are using stored procedures (SPROCs) with any great > regularity? > > I know that in the commercial database world use o

[nyphp-talk] SPROCs in the MySQL/PostgreSQL + PHP crowd

2010-11-10 Thread Jerry B. Altzman
Hi all, Just a question for those of you out there dealing with the F/OSS RDBMS's out there: How many of you are using stored procedures (SPROCs) with any great regularity? I know that in the commercial database world use of stored procedures is The Way Things Are Pretty Much Done, but I'v