[San-Diego-pm] San-Diego-pm Digest, Vol 119, Issue 2

Reuben Settergren rjs at jhu.edu
Wed Mar 19 14:18:22 PDT 2014 

I can't believe this hasn't been suggested yet!

DBD::CSV <http://search.cpan.org/~hmbrand/DBD-CSV-0.41/lib/DBD/CSV.pm> should
allow you to connect to a database implemented in .csv files and hopefully
preserve all your existing queries.

r



On Wed, Mar 19, 2014 at 11:35 AM, <san-diego-pm-request at pm.org> wrote:

> Send San-Diego-pm mailing list submissions to
>         san-diego-pm at pm.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://mail.pm.org/mailman/listinfo/san-diego-pm
> or, via email, send a message with subject or body 'help' to
>         san-diego-pm-request at pm.org
>
> You can reach the person managing the list at
>         san-diego-pm-owner at pm.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of San-Diego-pm digest..."
>
>
> Today's Topics:
>
>    1. Re: Perl & MySQL (Bob Kleemann)
>    2. Re: Perl & MySQL (Mark Schoonover)
>    3. Re: Perl & MySQL (Christopher Hahn)
>    4. Re: Perl & MySQL (Randal L. Schwartz)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 19 Mar 2014 10:05:08 -0700
> From: Bob Kleemann <rkleeman at energoncube.net>
> To: allengil at sdf.org
> Cc: San Diego Perl Mongers <san-diego-pm at pm.org>
> Subject: Re: [San-Diego-pm] Perl & MySQL
> Message-ID:
>         <
> CAO6cO5_ayM263Mufm_EYRHD8KS2vjcLx16On_-biOG0BsnBj6Q at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Allen,
>
> There are several free databases you could use.  If the SQL commands
> you've written aren't very MySQL specific, you could translate it to
> many other DBs without much difficulty.  If you've got a lot of MySQL
> specific extensions to SQL in your commands, then it might be more
> difficult.  I'd look at SQLite, and see if that supports your needs.
> If not, there are several others that could meet your needs, but it's
> hard to say without a better idea of what your applications needs.
>
> Also, I'm CC'ing the rest of the San Diego Perl Mongers list, as I'm
> sure many of them have some more experience moving from MySQL to other
> DBs.
>
>   -- Bob
>
> On Wed, Mar 19, 2014 at 6:02 AM,  <allengil at sdf.org> wrote:
> > Bob,
> >
> > I use Perl & MySQL on my company provided laptop as sort of a day
> planner.
> > It's just something I developed while working on my BSIT. Recently the IT
> > Nazis at my company detected MySQL running on it, and demanded that I
> > remove it immediately, claiming it was a security threat. I've been using
> > this for over 10 years, and having my work history in a relational
> > database has been quite helpful in recalling what I did. Do you have any
> > suggestions on alternatives that won't require a massive rewrite of my
> > code? I have a lot of SQL commands in there, and I would like to leave
> > them alone if possible.
> >
> > Thanx,
> >
> > Allen Gilson
> >
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 19 Mar 2014 10:46:54 -0700
> From: Mark Schoonover <mark.schoonover at gmail.com>
> To: Bob Kleemann <rkleeman at energoncube.net>
> Cc: San Diego Perl Mongers <san-diego-pm at pm.org>, allengil at sdf.org
> Subject: Re: [San-Diego-pm] Perl & MySQL
> Message-ID:
>         <CANhKybLYbQnRe62Pm9tA8ExziX5MAer7VrngF5yF3j3AdPL=
> dQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> If you don't need your MySQL instance available to the outside world, just
> lock it down to localhost. IIRC, there should be instructions in my.cnf on
> how to pin mysqld to localhost:3306 (assuming default port is used).
>
>
> Mark Schoonover
> Website: http://www.ka6wke.net
> Resume: http://cv.ka6wke.net
> Stack Exchange eBooks: http://se2go.ka6wke.net
>
>
>
> On Wed, Mar 19, 2014 at 10:05 AM, Bob Kleemann <rkleeman at energoncube.net
> >wrote:
>
> > Allen,
> >
> > There are several free databases you could use.  If the SQL commands
> > you've written aren't very MySQL specific, you could translate it to
> > many other DBs without much difficulty.  If you've got a lot of MySQL
> > specific extensions to SQL in your commands, then it might be more
> > difficult.  I'd look at SQLite, and see if that supports your needs.
> > If not, there are several others that could meet your needs, but it's
> > hard to say without a better idea of what your applications needs.
> >
> > Also, I'm CC'ing the rest of the San Diego Perl Mongers list, as I'm
> > sure many of them have some more experience moving from MySQL to other
> > DBs.
> >
> >   -- Bob
> >
> > On Wed, Mar 19, 2014 at 6:02 AM,  <allengil at sdf.org> wrote:
> > > Bob,
> > >
> > > I use Perl & MySQL on my company provided laptop as sort of a day
> > planner.
> > > It's just something I developed while working on my BSIT. Recently the
> IT
> > > Nazis at my company detected MySQL running on it, and demanded that I
> > > remove it immediately, claiming it was a security threat. I've been
> using
> > > this for over 10 years, and having my work history in a relational
> > > database has been quite helpful in recalling what I did. Do you have
> any
> > > suggestions on alternatives that won't require a massive rewrite of my
> > > code? I have a lot of SQL commands in there, and I would like to leave
> > > them alone if possible.
> > >
> > > Thanx,
> > >
> > > Allen Gilson
> > >
> > _______________________________________________
> > San-Diego-pm mailing list
> > San-Diego-pm at pm.org
> > http://mail.pm.org/mailman/listinfo/san-diego-pm
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://mail.pm.org/pipermail/san-diego-pm/attachments/20140319/9afa587a/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 3
> Date: Wed, 19 Mar 2014 10:50:58 -0700
> From: Christopher Hahn <xrz1138 at gmail.com>
> To: Mark Schoonover <mark.schoonover at gmail.com>
> Cc: allengil at sdf.org, San Diego Perl Mongers <san-diego-pm at pm.org>
> Subject: Re: [San-Diego-pm] Perl & MySQL
> Message-ID:
>         <
> CAP9CNRzuYz71D7tRottwGFH_WiPKRGsAajbTC+q63n6K8++5yw at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> That would beat a network monitor.
>
> I am not sure what "my company detected MySQL running" means
> though, and it could be a company-required app that, along with whatever
> else it does, scans the system for installed softwares.
>
> That would require a switch to an allowed DB.
>
> ...but I love the suggestion, and hope that the company is enlightened.
>
> Chris
>
>
> On Wed, Mar 19, 2014 at 10:46 AM, Mark Schoonover <
> mark.schoonover at gmail.com
> > wrote:
>
> > If you don't need your MySQL instance available to the outside world,
> just
> > lock it down to localhost. IIRC, there should be instructions in my.cnf
> on
> > how to pin mysqld to localhost:3306 (assuming default port is used).
> >
> >
> > Mark Schoonover
> > Website: http://www.ka6wke.net
> > Resume: http://cv.ka6wke.net
> > Stack Exchange eBooks: http://se2go.ka6wke.net
> >
> >
> >
> > On Wed, Mar 19, 2014 at 10:05 AM, Bob Kleemann <rkleeman at energoncube.net
> >wrote:
> >
> >> Allen,
> >>
> >> There are several free databases you could use.  If the SQL commands
> >> you've written aren't very MySQL specific, you could translate it to
> >> many other DBs without much difficulty.  If you've got a lot of MySQL
> >> specific extensions to SQL in your commands, then it might be more
> >> difficult.  I'd look at SQLite, and see if that supports your needs.
> >> If not, there are several others that could meet your needs, but it's
> >> hard to say without a better idea of what your applications needs.
> >>
> >> Also, I'm CC'ing the rest of the San Diego Perl Mongers list, as I'm
> >> sure many of them have some more experience moving from MySQL to other
> >> DBs.
> >>
> >>   -- Bob
> >>
> >> On Wed, Mar 19, 2014 at 6:02 AM,  <allengil at sdf.org> wrote:
> >> > Bob,
> >> >
> >> > I use Perl & MySQL on my company provided laptop as sort of a day
> >> planner.
> >> > It's just something I developed while working on my BSIT. Recently the
> >> IT
> >> > Nazis at my company detected MySQL running on it, and demanded that I
> >> > remove it immediately, claiming it was a security threat. I've been
> >> using
> >> > this for over 10 years, and having my work history in a relational
> >> > database has been quite helpful in recalling what I did. Do you have
> any
> >> > suggestions on alternatives that won't require a massive rewrite of my
> >> > code? I have a lot of SQL commands in there, and I would like to leave
> >> > them alone if possible.
> >> >
> >> > Thanx,
> >> >
> >> > Allen Gilson
> >> >
> >> _______________________________________________
> >> San-Diego-pm mailing list
> >> San-Diego-pm at pm.org
> >> http://mail.pm.org/mailman/listinfo/san-diego-pm
> >>
> >
> >
> > _______________________________________________
> > San-Diego-pm mailing list
> > San-Diego-pm at pm.org
> > http://mail.pm.org/mailman/listinfo/san-diego-pm
> >
>
>
>
> --
> Realisant mon espoir, je me lance vers la gloire.
> Christopher Hahn == xrz1138 at gmail.com
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://mail.pm.org/pipermail/san-diego-pm/attachments/20140319/7a9bcc2b/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 4
> Date: Wed, 19 Mar 2014 11:35:16 -0700
> From: merlyn at stonehenge.com (Randal L. Schwartz)
> To: Bob Kleemann <rkleeman at energoncube.net>
> Cc: San Diego Perl Mongers <san-diego-pm at pm.org>, allengil at sdf.org
> Subject: Re: [San-Diego-pm] Perl & MySQL
> Message-ID: <8638iekpej.fsf at red.stonehenge.com>
> Content-Type: text/plain
>
> >>>>> "Bob" == Bob Kleemann <rkleeman at energoncube.net> writes:
>
> >> I use Perl & MySQL on my company provided laptop as sort of a day
> planner.
> >> It's just something I developed while working on my BSIT. Recently the
> IT
> >> Nazis at my company detected MySQL running on it, and demanded that I
> >> remove it immediately, claiming it was a security threat.
>
> Until we understand more about this claim, replacing a database with
> another database might not suffice.  If the problem is one of corporate
> control, there may be no rationality involved, and in which case, no
> rational solution will overcome the impenetrable bureaucracy.
>
> --
> Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777
> 0095
> <merlyn at stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
> Perl/Unix consulting, Technical writing, Comedy, etc. etc.
> Still trying to think of something clever for the fourth line of this .sig
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> San-Diego-pm mailing list
> San-Diego-pm at pm.org
> http://mail.pm.org/mailman/listinfo/san-diego-pm
>
> ------------------------------
>
> End of San-Diego-pm Digest, Vol 119, Issue 2
> ********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/san-diego-pm/attachments/20140319/2247d704/attachment-0001.html>

More information about the San-Diego-pm mailing list