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]
