Oh wise monks...

I have a web app lovingly crafted in Perl using Catalyst. It is linked to an SQLite database on my development machine. Now it's time to deploy. I have a web server to host the front end. And a db server to host the back end. My institution requires this, and it seems like good practice. Only I have no idea how to pass queries from the web server to the db server, and how to pass fetched data back from the db server to the web server. Various advice has included, "Oh, that's easy, just wrap it all in JSON" -- but I have not been able to find more specific recipes despite a grand tour of google and CPAN.

I'm sure someone here has solved this in their sleep many a time...Any advice on at least where to begin? I am quite capable of figuring most things out from at least a starting point...

Grateful thanks.

In reply to Passing queries and data from a web server to a db server and back again... by Shuraski

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.