Bruce wrote:
> One of my old free sites is moving to another server. I had hoped it would
> be one of my CF servers as I will need to do some DB work for it
> very soon.
> However... they have decided to put it on a Linux box (not sure of the
> flavour yet). That's fine, as it is currently on a Unix box and I know
> enough to do what I need to. The question now arises as to how can I do DB
> stuff without using Selena's or Matt's stuff. Peter S has mentioned using
> mSQL or mySQL and Perl in the past (lost it, sorry Peter). Any pointers
> here would be good also. :)
I've been using mSQL/Perl and CF on different servers. As time goes on, I
find CF to be a little more convenient and quite a bit faster. I think the
speed gain comes from CF being a server API and doing snazzy things with
cached data. However, if you are going to use Unix, the perl msql library
has all I've needed to handle mSQL data from inside perl scripts:
http://theory.uwinnipeg.ca/CPAN/data/MsqlPerl/Msql.html
One great big difference between the two options (mSQL/Perl and ODBC/CF) is
the tools available to run adhoc queries, design complex queries and
generally organize and reorganize your database. If you're going to use mSQL
you're going to spend more time than if you use Access or another db with a
graphical interface (unless you're a rockinly accurate fast typist and have
a superb memory, or only have one or two tables and not much need for adhoc
queries).
Someone mentioned PHP/FI as another alternative for handling mSQL. PHP/FI
allows you to stick your db code inside your html page. You then give the
doc a .pthml ending and the server parse out the PHP/FI code. Sorta like CF.
I used PHP/FI for a while, but for some reason drifted from it over to Perl.
Can't give you a great reason, other than at that time PHP pages stuck extra
' marks in input type=text boxes in the AOL browser. Never did find out why,
and now most AOLers are using MSIE 3. PHP/FI:
http://mcsv.com/php-1.95/doc/php.html
One reason I can think of to go the mSQL/Perl way rather than the PHP/FI way
is that once you're in Perl you've got a s**tload of other options,
libraries, etc. You're also working in a language that is more likely to be
wanted by future employers, if that is a concern.
Jack
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
