Pete Freitag Pete Freitag

Want additional DB or OS support in ColdFusion?

Published on September 19, 2005
By Pete Freitag

Are you burnin' for built-in PostgreSQL support in Macromedia ColdFusion (BlueDragon already has this)? How about FreeBSD? Debian Linux Support? Fedora Support? Additional J2EE servers? 64-Bit Operating systems?

Then go and take the ColdFusion vendor support survey.


Want additional DB or OS support in ColdFusion? was first published on September 19, 2005.

FuseGuard Web App Firewall for ColdFusion

The FuseGuard Web Application Firewall for ColdFusion & CFML is a high performance, customizable engine that blocks various attacks against your ColdFusion applications.

The weekly newsletter for the CFML Community


That's weird I'm using firefox myself... I am looking into this.
by Pete Freitag on 09/19/2005 at 11:50:44 AM UTC
Evert - a few questions - are you using any firefox plugins that might change the way things are displayed? Ad blocking, custom style sheets?
by Pete Freitag on 09/19/2005 at 12:19:07 PM UTC
Ah, thanks I'll give it a try in FF 1.5
by Pete Freitag on 09/19/2005 at 1:20:19 PM UTC
Can you give us a couple bullet points (and/or links) on why you prefer PostgreSQL over mySQL? Do you have performance reasons, or just a preference?
by Mark Holton on 09/19/2005 at 4:08:11 PM UTC
Hi Pete,

I'm building a new website builder that uses MySQL instead of MS SQL primarily on the basis that:

(a) MySQL is well documented whereas as PostgreSQL seems to be less

(b) The fact there is a book called High Performance MySQL which finally answers what I needed to know about scalable MySQL. There doesn't seem to be an equivalently awesome resource for PostgreSQL.

(c) easy and powerful replication/scalability bits.

Do you have any comments on which database you prefer under a scenario where the database should ultimately be able to scale to 10 million websites which means, obviously, many times more records than 10 million? Would you prefer PostgreSQL under this scenario?

I am using a home brewed horizontal partitioning system. The data would actually reside among multiple databases with a master database that would tell the application which database the individual website data resides in.


[master table]

| | |

[table 1] [table 2] [table 3]

Where individual site data resides in table 1,2,3 and the mappings appear in master.
by Sunny on 09/19/2005 at 5:14:09 PM UTC
Mark and Sunny I'm preparing a blog post to answer your questions.
by Pete Freitag on 09/19/2005 at 5:29:48 PM UTC
Looking forward to the blog post, Pete, many thanks!
by Mark Holton on 09/22/2005 at 6:25:21 PM UTC
Hi Pete,
I'm eager to see the comparison blog post you have planned for PostgreSQL and mySQL. Just wanted to send a friendly reminder.
Many thanks for your website -- it's a great resource.
by Mark Holton on 10/10/2005 at 3:09:56 PM UTC