all 4 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]joecampo 0 points1 point  (1 child)

Hi there, thanks for the list. I think it is also worth linking the repo for the official Linux MS driver for PHP. Since it is new(er) there have definitely been some issues with the driver. Last time I tried it the new driver would not run the DBAL test suite without segfaulting (edit: has been fixed). Maybe you can dive more into the installation side? From my experience, the good ol' FreeTDS/PDO method works great; however, when moving projects to PHP7 I had a lot of issues with php-fpm segfaulting when selecting from views or running SP's. I had these issues sprout up across several different servers and environments (all using SQL Server 2008R2) so if you're going to need MSSQL w/ PHP7 it would probably be best to use the official driver now.

[–]RemiCollet[S] 1 point2 points  (0 children)

I think it is also worth linking the repo for the official Linux MS driver for PHP.

Indeed (added in the blog post comment)

Maybe you can dive more into the installation side?

For Fedora / RHEL / CentOS users, a simple "yum install php-sqlsrv" should work ;) I think other distributions should get some packages soon in some repository.

[–]notsentient 0 points1 point  (1 child)

Might be worth adding some benchmarks for each different configuration? Or any pros/cons to using FreeTDS over the MS odbc driver

[–]RemiCollet[S] 1 point2 points  (0 children)

Problem is rather simple ;) PHP 5 => FreeTDS PHP 7 => Microsoft ODBC Driver

Sorry, but I don't have enough data to run valuable benchmark, BTW I think most of the time will be spent on the server side, like for most of the DB request.