<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1435350206913_4031" dir="ltr">Perl Folks,<br>I just want to keep you in the loop on my PSGI experimentation.</div><div id="yui_3_16_0_1_1435350206913_4076" dir="ltr"> </div><div id="yui_3_16_0_1_1435350206913_3946" dir="ltr">So, I think I've settled on Fast CGI under Apache. For me it's best as I can simply reuse our APR authentication session layer and not have to worry about authentication in the application layer.</div><div id="yui_3_16_0_1_1435350206913_3968" dir="ltr"> </div><div id="yui_3_16_0_1_1435350206913_3969" dir="ltr">So, I did examples connecting to our databases in Plack, Dancer, Catalyst, and Mojolicious::Lite. I like Mojolicious::Lite the best so far as it is designed the way I "think". I like Dancer but its not RPMs friendly so, it's just too much to build all of the RPMs to get to a deployment ready solution.</div><div id="yui_3_16_0_1_1435350206913_3984" dir="ltr"> </div><div id="yui_3_16_0_1_1435350206913_4032" dir="ltr">Mojolicious is RPM ready, however, deployment with Mojolicious::Lite is biting me as I have not figured out how to add a prefix yet. Development with Starman URLs are like /this/:id but under Apache Fast CGI they are /path/this/:id. </div><div id="yui_3_16_0_1_1435350206913_4033" dir="ltr"> </div><div id="yui_3_16_0_1_1435350206913_4034" dir="ltr">I use DBIx::Array::Connect for all of our databases (100s of them) and Mojolicious::Lite will let me just do it without hassle.</div><div id="yui_3_16_0_1_1435350206913_4042" dir="ltr"> </div><div id="yui_3_16_0_1_1435350206913_4084" dir="ltr">So, issues that I'm still facing:</div><div id="yui_3_16_0_1_1435350206913_4085" dir="ltr"> </div><div id="yui_3_16_0_1_1435350206913_4134" dir="ltr">Mojolicious::Lite</div><div id="yui_3_16_0_1_1435350206913_4086" dir="ltr"> - Deployment path is different than development path and I need to figure out how to handle that.</div><div id="yui_3_16_0_1_1435350206913_4087" dir="ltr"> - How to handle database stale connections and connection timeouts (I assume that I'll have to move to DBIx::Connection wrappers for all database connections.)</div><div id="yui_3_16_0_1_1435350206913_4131" dir="ltr"> - die() sends HTML I need it to send JSON... There has got to be an easy way.</div><div id="yui_3_16_0_1_1435350206913_4098" dir="ltr"> </div><div id="yui_3_16_0_1_1435350206913_4132" dir="ltr">PSGI/FCGI is very interesting with a *lot* of performance advantages over CGI. Persistent memory (e.g. database connections) is the hardest part to get used to.</div><div id="yui_3_16_0_1_1435350206913_4239" dir="ltr">Thanks,</div><div id="yui_3_16_0_1_1435350206913_4169" dir="ltr">Mike</div><div id="yui_3_16_0_1_1435350206913_4198" dir="ltr"> </div><div id="yui_3_16_0_1_1435350206913_4206" dir="ltr">mrdvt92</div></div></body></html>