Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^2: Database in Perl

by biohisham (Priest)
on Jun 08, 2009 at 13:26 UTC ( #769530=note: print w/ replies, xml ) Need Help??


in reply to Re: Database in Perl
in thread Database in Perl

so I can assume it is not a good idea to come with Perl as a database develoment language? but I could use it as an interface to an existing database right?


Comment on Re^2: Database in Perl
Re^3: Database in Perl
by JavaFan (Canon) on Jun 08, 2009 at 13:45 UTC
    Yes, and yes.
      The way he used "database development language" suggests he means SQL CREATE DATABASE Statement/create table... not create RDBMS
        The way he used "database development language" suggests he means SQL CREATE DATABASE Statement/create table... not create RDBMS
        Given that in the post that starts this thread, (s)he writes:
        I am considering doing a project on a database that is a standalone,
        I do think his/her intention was to write a database engine.
Re^3: Database in Perl
by cdarke (Prior) on Jun 08, 2009 at 13:48 UTC
    There are so many free, good quality, general purpose database products around I have to wonder why you would want to write another - unless you have some ground breaking search or index algorithim. Most database engines are written in C, for performance reasons, and may even have assembler in some performance critcal areas.

    Perl is used as an interface because most database engines have a C interface, and a wrapper can be written using the Perl-C API (that is XS). Many other languages use C wrappers in this way, not just Perl.
Re^3: Database in Perl
by dorko (Parson) on Jun 08, 2009 at 14:01 UTC
    Well, my $.02 on the subject-- I wouldn't use Perl to create an MS SQL database. I also wouldn't use Java to do that. (Although I'm sure both Perl and Java could construct databases of many different flavors from scratch.)

    If I needed a database, I wouldn't use programming languages to build it. I'd use the database tools to create and manage the database.

    Then I'd use programming languages to connect to the databases to do interesting things with the data; including add, delete and update information in the database.

    In my mind, it's a question of using the best tool for the job. To sum it up, the tools that come with the databases are best for me for creating databases, and program languages are the best tools for doing things with databases. Different tools for different jobs. (You can use a hammer and screw driver to fix just about anything. But sometimes a saw just works better.)

    Cheers,

    Brent

    -- Yeah, I'm a Delt.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://769530]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (9)
As of 2014-12-17 20:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (33 votes), past polls