perl scrpt from html page

nnigam1 has asked for the wisdom of the Perl Monks concerning the following question:

O wise and wonderful Monks, I have an issue on which I seek your wisdom I used to code in perl extensively a few years back. Then my company moved to Oracle forms. But I loved perl and all the things that I could do with it so I am trying to work with perl again. I have created my script from which I can extract data from an Oracle database and create an html file that I can open in the browser. However this is too static. I would like to call this script from a web page to add dynamic capabilities to it. I have read the posts about this saying that I have to install a web server. However, I am pretty sure that I did this before without one. Please let me know that I am wrong or provide assistance in how to do this. This will be for two-three users only, so I would like to avoid having to add another server to the mix. If a web server is necessary, any recommendations for a minimum web server that could do the task with limited resources. I love apache and had used it a lot but that offered a lot more capabilities than I need now. This will be running on a windows 10 laptop with an SSD drive, Oracle 12c, and several development tools on it so I would like to minimize the resource footprint if possible. My previous postings were under nnigam, but I have no longer have that email and have forgotten the password.

Comment on perl scrpt from html page

Replies are listed 'Best First'.
Re: perl scrpt from html page by LanX (Saint) on Oct 07, 2018 at 00:26 UTC
You can have a Perl process acting as web server and listening to a dedicated port on localhost. I recommend using the mojolicious framework its lightweight and comes with a built in server and scales well if you decided to need more features. See https://mojolicious.org/perldoc/Mojolicious/Guides/Tutorial#Hello-World fur a start. Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery FootballPerl is like chess, only without the dice}	[reply]
Re^2: perl scrpt from html page by nnigam1 (Novice) on Oct 07, 2018 at 02:14 UTC
Thank you o wise monk. I will follow your suggestion. I may come back with additional questions.	[reply]
Re: perl scrpt from html page (retrieving password) by LanX (Saint) on Oct 07, 2018 at 11:37 UTC
> My previous postings were under nnigam, but I have no longer have that email and have forgotten the password. Please see Retrieving a forgotten username or password if you have "verifiable proof that you really are the owner of the account in question". Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery FootballPerl is like chess, only without the dice}	[reply]
Re: perl scrpt from html page by Anonymous Monk on Oct 07, 2018 at 02:36 UTC
You could expand the script to scrape the database and make many html pages linked together as a static website but if you need to interact: `#!/usr/bin/env perl use Mojolicious::Lite; use Data::Dumper; # or DBD::Oracle get '/' => sub { my $c = shift; my $data = Dumper(\%ENV); # or your DB $c->render(text => $data, format => 'txt'); }; app->start;` [download]	[reply] [d/l]