On Fri, 17 Aug 2001, Frank Hilliard wrote:
> I'm finding 4.5 runs better on Linux than on NT, particularly in
> handling mail.
Haven't ever tried using CF on NT and the mail features much, but I can
attest that mail on Linux is rather unreliable. The worst thing is if
mail is bounced back to the CF server there's no way for CF to capture the
bounce or to even alert you of it that I've seen.
> Special considerations are that you're going to have to
> use SQL queries for inserting and updating,
Versus database's on NT? I'm confused here.
> files and field names are
> case sensitive,
Files, yes, but the field names depend on your DB entirely. Here, 'SELECT
* from canDIDatES' works juat as well as 'SELECT * from candidates' on PG
7.1.
> permissions have to be set properly (including the
> database password when you create your data source in Administrator),
Versus NT ... where you don't have to secure the system? <boggle>
> and the placement of timestamp fields is critical in SELECT statements
> to avoid locking up the Server CPU.
I've never seen this occur except in your installation. I can select a
timestamp with that field being that last one in the query w/out problems.
> There are also issues with
> PostgreSQL regarding empty and NULL values in timestamp, numerical and
> boolean fields.
Such as...? To me it treats NULLs just like a DB should.
> Beyond that, databases on Linux can't simply be copied
> over as they can on NT, so the methodology of working with data is
> different.
createdb db2
pg_dump db1 | psql db2
Plus with PG and Mysql's ability to drop the whole DB to one sql filled
flatfile has always been a handy way for me to archive the schema and
re-load it into a different box for testing w/out data.
> I'd recommend getting VNC loaded on the server so you can see
> everything in real time with a GUI. You'll need SSH access. Also make
> sure Perl and PHP are installed because phpPgAdmin is going to be a huge
> help.
Aside from SSH I've never needed either or the other tools to maintain the
system. I wouldn't recommend installing either VNC or phpPgAdmin on a
production system either. The more stuff you introduce the more likely it
is that you'll forget a security update or two and a hole will be left
behind.
Justin Buist
Trident Technology, Inc.
4700 60th St. SW, Suite 102
Grand Rapids, MI 49512
Ph. 616.554.2700
Fx. 616.554.3331
Mo. 616.291.2612
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
