Re: OOP to run sequential SQL queries?

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

 



Hi,

We were thinking to implement the solution as "Stored Procedures"
> instead of a PHP solution that runs SQL queries, but an article in
> Coding Horro recommendeds to avoid SP for good reasons:


The article shows only one thing. that common practice should be to 'do
everything where it belongs'

If you implement this practice within your application, it becomes more
maintainable, more performant and easier to develop.

Also, to determine the styles used to write your code, is almost entirely
dependent on a few things:
* Programmer's preference
* The problem you are solving
* The standards that are commonly used in the environment you are in

Is there any benefit to use OOP in these situations?

Benefits of OOP are that it becomes easier to implement a more standardized
code structure, better match with reality, clearer code, more structure,
re-usability, and a modular design.
These can all be done in procedural code as well, the difference being you
need a different mind- and skillset.

HTH

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table


2013/2/17 Marco Behnke <marco@xxxxxxxxxx>

> Am 17.02.13 17:00, schrieb AmirBehzad Eslami:
> > Dear list,
> >
> > We have a bunch of SQL-queries, they should be executed in
> > a sequential order, with a defensive programming style in mind.
> I don't understand what you want?
> Queries are executed sequentially or do you plan to create a
> multi-process PHP application?
> >
> > We were thinking to implement the solution as "Stored Procedures"
> > instead of a PHP solution that runs SQL queries, but an article in
> > Coding Horro recommendeds to avoid SP for good reasons:
> >
> >
> http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html
> >
> > Now we're going to carry on in PHP, and my experience says that
> > we should write the solution in a procedural-style, instead of OOP.
> >
> > Is there any benefit to use OOP in these situations?
> >
> > Please share your thoughts.
> >
> > Thanks,
> > -behzad
> >
>
>
> --
> Marco Behnke
> Dipl. Informatiker (FH), SAE Audio Engineer Diploma
> Zend Certified Engineer PHP 5.3
>
> Tel.: 0174 / 9722336
> e-Mail: marco@xxxxxxxxxx
>
> Softwaretechnik Behnke
> Heinrich-Heine-Str. 7D
> 21218 Seevetal
>
> http://www.behnke.biz
>
>
>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux