News for hackers. Stuff that matters.
Re:WordPress testing official SQLite Support by c0nsumer on Friday December 16, 2022 @05:26PM (#34021433)
This'd be great. I'm curious about performance, of course, but for personal blogs without comments, coupled with a caching module... This could be great.

One thing I'm still trying to suss out is how to have Apache host Wordpress and stuff via HTTP/2. Wordpress which needs PHP which requires mpm_prefork, which precludes mod_http2. Guess I should just proxy WP to another instance of Apache or some other httpd...?

Re:WordPress testing official SQLite Support by jcoby on Friday December 16, 2022 @05:35PM (#34021552)
Take a look at php-fpm. It works with all the major servers and let’s them do what they do best and offloads the php requests to php when needed. It also has better caching and overall performance than mod_php since it’s a long running daemon.
Re:WordPress testing official SQLite Support by Ayesh on Friday December 16, 2022 @07:08PM (#34022469)
WordPress does not require mpm_prefork. It works just as well with mpm_event (with php-fpm). Arguably, mpm_event is the most widely used one nowadays.
Re:WordPress testing official SQLite Support by c0nsumer on Saturday December 17, 2022 @09:14AM (#34027894)
Yeah, I guess I should move back to php-fpm... I did years ago, but then consolidated to a very simple server where I just wanted Apache with mod_php doing its thing.

Guess I should take some time this winter to restructure things...

Re:WordPress testing official SQLite Support by ilyt on Friday December 16, 2022 @07:11PM (#34022494)
I just put everything behind haproxy and handle most of "which domain goes to where" there. It's designed to be reverse proxy from the scratch, it's light and very good at it

> Wordpress which needs PHP which requires mpm_prefork, which precludes mod_http2. Guess I should just proxy WP to another instance of Apache or some other httpd...?

php-fpm have been de facto method you should host PHP for a decade+. It also allows to have different permissions for web server and PHP app which can make it more secure