Rob Dixon wrote: > Hi all. > > This really belongs in the perl.beginners.cgi group, but I'm comfortable > here so I shall stay for a while. > > I've written a lot of CGI code in Perl, and now have to create and use > a database which will provide the data for another CGI application. My > only constraint is that I shall be working on Linux under Apache - there > is no existing database and I can install what I want within reason, with > cost being one of the major criteria. I know a lot of Perl and SQL, but > I don't know of any standing conventions for this sort of stuff. Could > somebody suggest what the most commonly accepted components > would be in this type of application? I'm thinking mainly of which Perl > modules and SQL engine I should use. > > Forgive me if there isn't a proper answer to this very general question. > But be assured that, "There isn't a proper answer," is a proper answer > and you won't lose any marks if you submit something like that :-) > > Thanks, > > Rob
Hi Rob, Are you in a hurry on this project? If not, I would strongly recommend trying a few different DBs. MySQL and Postgres-SQL seem to be the top picks among open source DBs. You might also want to try out Oracle to see if it is worth the difference in cost. You can download their Enterprise version from their web site, and use it free of charge for development purposes only. License requirements take effect when you put it into production. [Note it is a bit hefty. The download set is two and a half CDs worth--1.5+ GB] If you are not terribly attached to the following features: Sub-selects Stored procedures Triggers then you would probably be best off with MySQL. Although it does not include these features, it does present some alternatives that are functionally equivalent. I recommend it because it is straightforward and approachable. It was built to be simple, sleek and powerful. There is another bonus to MySQL. Although they recommend installing from the binary, the C source is worth dowloading also, just for pleasure reading. I dove in awhile back, starting with mysql.h and mysql.c, and it is truly an experience to bask in. So clean, so transparent, it reads like a book. 8-o) Joseph -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
