Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Database in Perl

by JavaFan (Canon)
on Jun 08, 2009 at 13:02 UTC ( #769519=note: print w/ replies, xml ) Need Help??


in reply to Database in Perl

Perl is not very well suited to write databases in. Luckely, it's very easy to connect to all major databases from within a Perl program.


Comment on Re: Database in Perl
Re^2: Database in Perl
by biohisham (Priest) on Jun 08, 2009 at 13:26 UTC
    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?
      Yes, and yes.
        The way he used "database development language" suggests he means SQL CREATE DATABASE Statement/create table... not create RDBMS
      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.
      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://769519]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (5)
As of 2014-09-20 11:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (158 votes), past polls