Обсуждение: Re: [sql] mysql vs. postgresql

It really depends on the platform and interface you will be using.  I am
just finishing a WEB application developed in NT and transfered to Unix.  I
used HTML and Perl for displaying the data.  I could not find a perl module
for postgresql for NT.  With MySQL, the Perl CGI scripts transfered
directly from NT to Linux and Solaris.

You will also find the support from MySQL excellent.  There is a large,
knowledgeable user base.

>This message posted by: "Raymond Hall H." <kovalski@ife.org.mx>
>
>Hello,
>
>Upon working on a huge database project (managing 332 electoral districts 
>in Mexico) our team is facing the decision between MySQL and Postgresql.
>I'd really appreciate info (or pointers to) about comparisions & 
>benchmarks between such programs.
>tnx & regards,
>Raymond
>
>sql.
>To unsubscribe from this list, send the message "unsubscribe sql" to the
address majordomo@chalmers.com.au
>
>
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@interlog.com

On Fri, 14 May 1999, Christopher R. Jones wrote:
> It really depends on the platform and interface you will be using.  I am
> just finishing a WEB application developed in NT and transfered to Unix.  I
> used HTML and Perl for displaying the data.  I could not find a perl module
> for postgresql for NT.  With MySQL, the Perl CGI scripts transfered
> directly from NT to Linux and Solaris.

If you are using perl, you should be using DBI.  DBI has database drivers
for most popular databases, including postgresql and mysql.
It's a database independent module.  With DBI you can switch database and
not have to modify your code(assuming the SQL is supported on both).
http://www.symbolstone.org/technology/perl/DBI/index.html

For NT, you could use the DBD-ODBC(driver for DBI) with postgres' odbc
driver.

> You will also find the support from MySQL excellent.  There is a large,
> knowledgeable user base.

I think postgres' userbase is both big and knowledgeable, and the
developers are very helpful as well.

Both databases have their good points.  It's the same with everything,
choose the right tool for the job.  MySQL for light jobs(or not so light)
where reliability is not so much a consern and postgres where reliability
is paramount, while speed isn't.

Ole Gjerde