I really appreciate your comments. Fortunately I have a spare pc that I am not using very much right now. It has windows 98.
I have been very hesitant at putting apache or similar on it b/c of the learning curve thing. It looks like I am headed that direction though. What about "renting space" on a linux system? Wouldn't that reduce some of the work. Instead of haveing my own server, use someone elses? I do have apache on windows to test webpages on my pc without sending them to the internet which is very helpful!! Again, thanks for the comments ... I appreciate them...in fact it helps a little......before I jump off to the deep in .... :) :) --- Martin Moss <[EMAIL PROTECTED]> wrote: > My advise is run a linux machine with an Apache > webserver and use Mod_Perl. > How scalable do you want it? How scalable does it > really need to be? How > about security? > > I have worked for two different companies in the > last 5 years.the first used > HP-UX and Sun Solaris and the latter Linux. I would > go with Linux any day. I > have seen fewer Problems under Linux (which after > all is free - ish), than I > did under Other UNIX Machines (perhaps 2 years newer > version of Solaris and > HP-UX are equally as stable, but I wouldn't know). > Most people quote > reliablity and support as excuses for not using > Linux. They are usually > misinformed as to the maturity of Linux. > > It also means that whenever you upgrade or install > any software on Linux, > you don't have to reboot:-) > > I'm not sure if postgreSQL is available for Windows. > Depending on what sort > of machine you have to run as your webserver would > depend on whether I would > recommend using a seperate machine for your database > and another for your > webserver. Also it depends on how many hits your are > expecting on your > webserver. Unless you are expecting more than 2000 > hits an hour I think > you'd be ok with everything running on 1 Linux > machine which wouldn't have > to be anything more than a decent desktop PC. > > Why Varchar? Mysql Blob types (can contain any char) > are allowed to have > index's on them, so speed hasn't been an issue > there. > > My concern is if you've never used Unix (or Linux) > before then a do it > yourself learning curve can take a while, but There > are many,many,many > people out there who will help you out, and Many > people learnt Unix without > anything else but a good book and a Jump in the deep > end!!!!! Just find the > right mailing lists. (This probably is true for > Windows too though, to be > fair). > > Once you've got your website up and running, you > will then have other things > to worry about. The main one is Webserver Log Files. > These can be very large > (if you're sites famous), and Getting these files > off there can be a pain > because MS FTP Server isn't very good at handling > large downloads. If you > wish to have your hits Accreditted you will have to > reformat those log > files. Again better not done on the same machine as > your webserver. > > You also need to think about how you will publish > your website. Will you > manually create the web pages? Will you write your > own content publishing > system? Will you use a Software Package. That's up > to you, but most windows > based packages will happilly write to linux Machines > (just mount the linux > drive under windows) so you could even have 1 > desktop machine for your > personal use and web publishing, and a seperate > linux machine to process the > website. > > Hope this helps, > > Regards > > Marty > > > > > -----Original Message----- > > From: Investor [mailto:[EMAIL PROTECTED]] > > Sent: Thursday 03 January 2002 17:05 > > To: Martin Moss; > [EMAIL PROTECTED] > > Subject: RE: website db & perl || RE: OT: Re: A > website, perl > > powered...but....MS Access or Mysql ?? > > > > > > Thanks for the comments. > > > > yes I am currently on windows platform. > > > > The 255 length is for the varchar type. > > > > I guess i will have to look into PostgreSQL. > > > > I would be willing to learn another operating > system > > if it would get the job done & is stable. B/c I > am in > > the intial stages of developing a website. > > > > > > > > > > > > --- Martin Moss <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Currently I am basically set up to use perl > and an > > > > access db. But I understand that access has a > > > limited > > > > simultaneous user support. I guess a person > could > > > set > > > > up several databases with different dsns & > perl > > > > conditionals, but that would double and triple > > > space > > > > on a server. > > > > > > > > I am considering mysql b/c it supposedly is a > bit > > > more > > > > supportive for simultaneous users, and I > noticed > > > that > > > > mysql fields has a length of 1 - 255. I think > > > some of > > > > my fields will be greater than 255. Do you > guys > > > agree > > > > with the 255 length limitation? > > > > > > > I think you are misinformed. Mysql has a BLOB > type > > > which can take a much > > > larger Field Length. > > > Access and Perl don't work comfortably together > in > > > my experience. > > > > > > > Does anyone have a solution in mind? > > > > > > > > I know this may be little off subject for > perl, > > > but I > > > > am a perl scripter & will utilize perl, I am > > > having a > > > > little difficulty selecting the right db to > use > > > right > > > > now. > > > > :) :) > > > > > > > > > > You didn't specify if you are using UNIX or > Windows, > > > I assume you're using > > > Windows. Do you have a UNIX machine available to > run > > > your Database, would > > > probably relieve you of some of the headaches > you > > > would have, but unless you > > > were familliar with Unix would probably > introduce > > > more. > > > > > > Under UNIX:- > > > I have used MySQL farely extensively under > Linux, > > > But Recently I've been > > > hearing good things about PostgreSQL. I cannot > back > > > them up with evidence of > > > my own, but I'm sure others here can. I've heard > sub > > > selects are supported > > > in PostgreSQL But know they aren't available in > > > MySQL. I've also seen Large > > > MySQL Tables (MYISAM Type, of size approx 1GB) > > > become corrupted easily and > > > regularly however These have all been > recoverable > > > errors. > > > > > > Check out some Earlier posts today which are > also > === message truncated === ===== Regards, Investorclb __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com _______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
