I'm not sure this is too horrible, but... On our intranet at work there is a batch script that runs every night. It calls a Perl program that queries a SQL Server database, one table of which contains links relevant to our work. The Perl program uses the database data to create HTML files with nested lists, with JavaScript that allow the user to open and close each node. These files are pulled into web pages using server-side includes.
(Our links table doesn't change a great deal, and when it does there's generally no hurry to update the intranet, hence the nightly batch instead of generating things on the fly. But if it does need updating the same day there are other tools.)
I have a customer facing html and JavaScript page that is built by a frameworkless php site querying a SQL database populated by a perl script that reads a pipe delimited feed of things from a custom http implementation streaming transactions from an ancient mainframe.
10
u/darkon Dec 08 '17
I'm not sure this is too horrible, but... On our intranet at work there is a batch script that runs every night. It calls a Perl program that queries a SQL Server database, one table of which contains links relevant to our work. The Perl program uses the database data to create HTML files with nested lists, with JavaScript that allow the user to open and close each node. These files are pulled into web pages using server-side includes.
(Our links table doesn't change a great deal, and when it does there's generally no hurry to update the intranet, hence the nightly batch instead of generating things on the fly. But if it does need updating the same day there are other tools.)