Personally, if this is for a single user application I would try to avoid MySQL and a "real" webserver, and go with an all-Perl setup of, say Twiggy and DBD::SQLite, that is, use a webserver written in Perl and use SQLite instead of a separate database proces.

Alas, I'm not aware of an easy way to create a setup/installation file for Perl. Maybe consider looking at PAR::Packer to create a single executable that people can copy...

Perhaps I missed something, but the OP mentioned doing this on Windows. According to its CPAN Tester Matrix, it doesn't look like there are any passes in the mswin32 column for Twiggy. It looks like it might work under Cygwin, but not everyone is going to want Cygwin installed on their Windows system.

For Windows, I think Mojolicious, Dancer or Dancer2 would probably work better than Twiggy - although I have heard a lot of good things about Twiggy.

I routinely use Dancer with a Twiggy backend engine on Windows. I think Twiggy fails its tests due to relying on Test::TCP, which usually fails its test suite on Windows due to relying on fork().

I'm pretty sure that sabnzbd and sonarr don't use mysql, they use SQLite (see DBD::SQLite). I doubt that a torrent client would use mysql either. What framework where you thinking of for the web interface?

Seems like this would interest you: https://github.com/ddmitov/perl-executing-browser.

I'd be sorely tempted to try a redistributable docker image... yeah, ok, it'd be a bit of a pain to set up docker automatically on a windows host, but once you got that done once, the features you could add - mysql/sqlite, nginx/apache, redis, beanstalk, I mean, really, you name it. And it would also work on Macs and Linux systems just by setting up docker there as well.

Yeah, I've been playing with docker a bit lately. Suddenly, it has become my hammer to all the world's nail-looking problems :)

citrusperl is a tool that is very near to your needs: but I have just tried it in the past and it is focused in Wx GUI applications, but can create a customized Perl distribution usable on windows machines.

For stand alone executable PAR is the base choice and cavapackager can be an alternative.

Let us know your achievements!

L*

For the database portion, I'd agree with what others are saying about recommending for ou to use SQLite rather relying on having a specific database software installed.

For the web server portion, you could consider using Mojolicious as your web server. Someone even has a blog posting (see here) about using Mojolicious and PAR::Packer. That might help get you started with putting a Perl based web server into an executable.

Thanks so much for all the awesome replies. I will definitely be researching and trying the recommendations mentioned here and post here when I find an elegant solution.

I simply love doing things in Perl - Always a pleasure to use.

I settled on Mojolicious but ran into a few problems. For now I have scrapped the idea of doing it with Mojolicious due to some limitations with Mojolicious as it does not fit into what I plan on doing. Still, it seems a redistributable web server might serve my purposes the best. Anybody have any recommendations for a redistributable web server that can handle Strawberry Perl?