Success -- MySQL / MyODBC replication

[michael d hoskins]

I didn't go back through the message threads, but I don't think I said
anything like that.  If I did, sorry to be midleading, since that's not
what I meant.  No, you don't ever have to pay for Postgres -- ever.

There are support contracts, so if I said that you only pay if you want
support, then this is what's implied:  http://www.pgsql.com/support.html
This is from the "Commercial Support" link on this page:
http://www.postgresql.org/index.html

Postgres is truly free, but you can pay, if you want commercial support.
This helps give the "Pointy Haired Boss" a few warm fuzzies.

Also, note that Postgres is bundled with RedHat and other distributions.
Postgres has quite a few advantages on all other SQL databases, if
"free," "fault tolerant," and "full of features" are objectives.  (Very
good objectives, I might add.)  I guess it's also relatively fast, if
you compare to other databases that fully support transactions.

I agree, MySQL has an odd commercial license.  Because of that, it's
hard to justify its bundling with Linux distros, and makes it harder to
come up with totally free database solutions.  MySQL is ultra fast,
extremely well documented, and has tons of open source development
behind it.  Right now, those are items I prefer.  Since I'm not (yet)
developing commercial solutions, I'd personally choose MySQL.  Its
performance on little machines rocks.  It also seems that MySQL supports
more data types, especially useful ones.  Except for the license, these
are some of the reasons MySQL is far more popular.

Because of free ODBC, JDBC, and Perl DBI/DBD support, you can develop
for both databases simultaneously, as long as you don't use native
API's.  Unfortunately, PHP doesn't have this kind of support, unless you
download someone else's library, such as PHPLib, the PHP Base Library:
http://phplib.netuse.de/index.php3  In most of these, you just switch
out a line or two of code, and maybe a driver.  This way, you don't
paint yourself into a corner.

-----Original Message-----
From: bradmiller [mailto:bradmiller at dslonramp.com]
Sent: Friday, April 07, 2000 6:13 PM
To: kclug
Cc: bradmiller
Subject: Re: kclug - Re: Success -- MySQL / MyODBC replication

At 04:51 PM 4/7/00 -0500, you wrote:
>We use ColdFusion at Sprint?  Say it ainn't so! :(
>
>PS  There is no licensing fee for PostgreSQL, not even if you want
>support.  Someone mentioned there was earlier.  They are mistaken.
>
>--
>Chris

You'd be suprised at everything they use there.  I would talk to my
counter-parts at different locations and they would be using ASP with
MS-SQL.  Then there would be other flavors of this, that, and the other.
We were using Netobjects with Homesite for our design work and then
plugging in the Cold Fusion code within Netobjects.  I helped change
some
thinking with Netobjects usage and Homesite -- in the way we were doing
things with the code and that.  It's a very large company with lots of
little bits and peices here and there.  Our group was doing stuff before
the steering comittee for web (Intranet) design was going and they were
always ahead of them on what was going on.


Bradley Miller, Programmer/webmaster
AccessZone Design - www.accesszonedesign.com
Blue Springs, Missouri office
Phone: 816-228-3814 Fax: 559-663-4046