Re^2: Convert script to use MySQL

Assuming always that PostgreSQL is available on your OS. Assuming that as the OP is talking about CGI that his hosting service supports it, or even allows it!

Speaking personally, I have tried three implementations of PostgreSQL on Windows. Using cygwin is a performance nightmare. The two other commercial products - both based on pretty old (like 7.2.1) PostgreSQL - are expensive (about double the price of commercially licensed MySQL) and are not yet really suitable for end-user application.

When PostgreSQL finally has native Windows support then it will be interesting. But until then it is nice to have on a *nix box, but not much use in my day to day real world. I am sure that one day it will be able to compete - but they have a little way to go yet.

jdtoronto

Comment on Re^2: Convert script to use MySQL

Replies are listed 'Best First'.
Re^3: Convert script to use MySQL by EdwardG (Vicar) on Nov 27, 2004 at 21:40 UTC
http://www.postgresql.org/docs/faqs/FAQ.html#1.4 `1.4) What non-Unix ports are available? Starting with version 8.0, PostgreSQL now runs natively on Microsoft Windows NT-based operating systems like Win2000, WinXP, and Win2003. A prepackaged installer is available at http://pgfoundry.org/projects/ +pginstaller. MSDOS-based versions of Windows (Win95, Win98, WinMe) can run PostgreSQL using Cygwin.` [download]	[reply] [d/l]
Re^4: Convert script to use MySQL by jZed (Prior) on Dec 03, 2004 at 03:54 UTC
But what about DBD::Pg? Last I checked (a month or two ago), it would not compile or install on Windows with the native windows port of PostgreSQL, it would only install using the cygwin port.	[reply]
Re^4: Convert script to use MySQL by jdtoronto (Prior) on Dec 03, 2004 at 03:45 UTC
Starting with version 8.0, PostgreSQL now runs natively on Microsoft Windows NT-based operating systems like Win2000, WinXP, and Win2003. A prepackaged installer is available at http://pgfoundry.org/projects/ +pginstaller. Yep, my point entirely. Am I going to put a beta release into a production environment? Nope! Am I going to put the first release inbto a production environment? Nope! Sure PostgreSQL is, for the first time, on our radar screens, and when it is truly production ready on Windows we will evaluate it there. It is nice on *nix, and we have ported a few things here to use it for evaluation purposes. But that is far as we can risk going right now in a princiaplly Windows shop. jdtoronto	[reply]