Hello, SpaceCowboy. Welcome to the Monastery.

Is there a way to encrypt a Perl file containing password?

There are many ways to encrypt a file in Perl - the real question is how do you decrypt it again? That will require a password and it will need to be stored somewhere, say in a file which then needs to be encrypted, and so ad infinitum. See How can a script use a password without making the password visible? and Password encryption for discussion of some approaches to this.

can I import a million rows and transpose, rename, transform and do a bunch of joins -- is this possible in Perl?

Yes, but why would you? As you say SQL is likely the better tool for this, that's why we have databases. Your reason for avoiding the database seems vague to me. Why not try the SQL approach and if you need help re-framing the results that could be another question.

any advice on books on perl deployment practices?

I'm not aware of any books specifically about that but deployment is touched on in various other books and articles. You might find the "Managing Real Programs" chapter of Modern Perl to be useful, for example.

🦛

In reply to Re: database and deployment questions by hippo
in thread Newbie question by SpaceCowboy

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.