Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Database project in PERL

by Thakur (Acolyte)
on Jan 12, 2012 at 18:07 UTC ( #947594=perlquestion: print w/ replies, xml ) Need Help??
Thakur has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks, I am a graduate student and I want to do a Database project in which I can use PERL and SQL. Can you guys please suggest me some projects so that I can talk to my professor regarding those projects. Thanks

Replies are listed 'Best First'.
Re: Database project in PERL
by ww (Bishop) on Jan 12, 2012 at 18:59 UTC

      I am doing masters in computer science. I have just started learning PERL.I want to do some database projects in which I can use PERL

        One might suspect that your department (or University) might have an array of DataBases, hither and thither.

        If so, a project to catalogue those and store that info in a DB might find favor...especially when accompanied by (written-in-Perl) script(s) for naive users to search that db.

        OK, Lesson 0: there is no PERL. There is a language called Perl, and its reference implementation perl, commonly found in /usr/bin/perl, /usr/local/bin/perl, or c:\strawberry\perl\bin\perl.exe.


        Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

        What about this: Get some cheapo network enabled temperature/humidity sensors (i like to use these for server room monitoring) and put them up on various places in a building. Then go ahead and implement some data logging, statistics and maybe real-time warning.

        This is not that hard to implement, you get real-world data, plus you may save your university some real money by helping them optimize the use of the climate control (or show them the need to install one).

        This could be a multi-year project for many students, extending the system. Maybe implement a web page showing current and historical data and predictions based on that. Play "connect the dots" from your access logs and try to find out what the people are looking for.

        While this system might not have a real "wow!" effect at first, it can really be helpful. They may ask themself many question that such a system can answer: Is it cooler in the cafeteria than outside (so, should i go early and get one of the limited places inside)? How warm is the water in the swimming pool? Is the heating in the chemistry lab still broken (do i need to long johns again)?

        Of course, beeing students, there are of course the uhm, not so legalized questions that the system will also help to answer, like "Is the humidifier at our dorms pot vegetable plantation working correctly and is climate control putting out the optimum temperature?". Not that i would endorse such activity, but i know how groups of young, bored people tend to think. ;-)

        "Believe me, Mike, I calculated the odds of this succeeding against the odds I was doing something incredibly stupidů and I went ahead anyway." (Crow in "MST3K The Movie")
Re: Database project in PERL
by rspishock (Monk) on Jan 12, 2012 at 19:35 UTC

    Find a specific area of the IT/CompSci field that interests you and use that as a starting point.

    For example, if you find forensics interesting, you could work on building an asset tracking system that would be used to create a chain of evidence. The db could be sorted device type (HDD, cell phone, GPS, etc.) S/N, date received, date removed from inventory, etc.

    This is just an example of a project that I'm working on, but maybe it'll help you get started. The key is to find something that interests you, that way you'll remain motivated to finish it.

Re: Database project in PERL
by tobyink (Abbot) on Jan 12, 2012 at 19:47 UTC

    How about an implementation of R2RML in Perl? I've written a module called RDF::RDB2RDF::R2RML which does a one-way mapping as a dump, but a live two-way interface would be feasible, and probably at a suitable level of difficulty.

    Whatsmore, it's a tool that Perl currently lacks, and I know a lot of people would welcome.

Re: Database project in PERL
by Not_a_Number (Parson) on Jan 12, 2012 at 19:51 UTC


    Or your cookery recipes:

    SELECT * FROM recipes WHERE main = 'cod' AND prep_time < 15;

    Or your gardening expertise:

    SELECT * FROM flowers WHERE colour = 'red' AND height < 20 AND ...;

    Or your photos, or your facebook* stuff...

    In brief, choose one of your interests. That way, your project might possibly be of some use outside your current academic studies.

    * Disclaimer: I know nothing about facebook. I have an account, apparently, for I occasionally get requests from people I don't know (or I've forgotten that I knew) to be 'friends'. I usually refuse.

    Update: added disclaimer
Re: Database project in PERL
by marto (Bishop) on Jan 12, 2012 at 18:56 UTC

    What are you asking? How to use Perl and databases, or are you asking for ideas for some sort of graduate project you can then implement in Perl?

      I am looking for ideas for some sort of graduate project that I can implement in Perl.

        People do their best work when they are working on something that they are interested in. Are you interested in something? Something that you can do with a computer?

        To give you an idea of what I am talking about, look at BrickLink, for trading Legos. There are a ton of pieces and are cataloged by dozens of colors and they breakdown kits but the number and type of pieces in each kit. It is tedious and we are not talking about a lot of money either. This web site was written simply because the guy loved working with Legos and saw a problem he could solve.

        Looking at it, I could do a much better job than he did (of course he built it 10 years ago). On the other-hand, I would have never completed it because it was something I was not interested in.

        A computer is a tool, not an end to itself and you need to find that something that you want to spend your time with. To use that tool to make something, even when it is frustrating, because you will get it done.

        If you cannot find that thing that interests you, I would stop pursuing a graduate degree right now.

Re: Database project in PERL
by BrowserUk (Pope) on Jan 12, 2012 at 19:05 UTC

    Catalog your mp3s.

Re: Database project in PERL
by erix (Vicar) on Jan 12, 2012 at 18:32 UTC
Re: Database project in PERL
by Anonymous Monk on Jan 12, 2012 at 21:48 UTC
    I'm shocked you graduated anything, asking a quesiton like this.

      I'm shocked you graduated anything, asking a quesiton like this.

      Jealous much

        please, instead write a tool to cataolgue optical devices (cd dvd) storing info in a sqlite db, store also SHA or MD5 keys foreach file or folder at first level of the media and a checksum of the entire media.

        I want the time to do this but i have not..

        Perl is your language..
        perl is the interpreter..
        PeRl does not exist but is CaMeLcAsE..
        PERL does not exists but can be an environment variable if you want..

        there are no rules, there are no thumbs..

        I haven't graduated yet. I have just started my Master degree this Spring. My classes started hardly around 10 days back.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://947594]
Approved by davies
Front-paged by planetscape
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (7)
As of 2016-07-29 07:52 GMT
Find Nodes?
    Voting Booth?
    What is your favorite alternate name for a (specific) keyboard key?

    Results (260 votes). Check out past polls.