Google
  Web www.spinics.net

Re: Stored Procedures, Dynamic SQL or static SQL and testing.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On 2011-03-26, at 9:00 AM, Richard Quadling <rquadling@xxxxxxxxx> wrote:

> Hi.
> 
> What preferences do you all have when using SQL. Stored Procedures or
> PHP generated dynamic SQL or parameterized static SQL.

I used both. SPs work for some of the larger reports, especially when combined with a view or two. For mist of the form interactions I tend to use regular SQL with prepared statements for simplicity and security





> 
> Whichever you use how do you test them? Do you use unit testing in
> your PHP code? If so, do you also have unit code testing for the SQL
> statements (I suppose this mainly relates to SPs).

Yes. I generally write and test the SQL before turning it into a SP




> 
> Does using a different RDBMS make a difference to the SQL coding style
> you'd use?

Generic SQL where possible. But occasionally I will use specific SQL for the RDBMS where appropriate. My current code base is not as layered as I would like to really make it a simple config switch to change the backend



> 
> This isn't for any sort of thesis, just trying to see what the general
> consensus is of those that reply.
> 
> Thanks for answering.
> 
> Richard Quadling.
> 
> -- 
> Richard Quadling
> Twitter : EE : Zend
> @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

Bastien Koert
Sent from my iPhone
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Plagiarism Notes]     [Postgresql]     [Yosemite News]

Powered by Linux