pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [sql] mysql vs. postgresql
3+ messages / 3 participants
[nested] [flat]
* Re: [sql] mysql vs. postgresql
@ 1999-05-14 18:39 Christopher R. Jones <cj@interlog.com>
0 siblings, 1 reply; 3+ messages in thread
From: Christopher R. Jones @ 1999-05-14 18:39 UTC (permalink / raw)
To: sql@chalmers.com.au; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: [INTERFACES] Re: [sql] mysql vs. postgresql
@ 1999-05-14 20:26 Jackson, DeJuan <djackson@cpsgroup.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jackson, DeJuan @ 1999-05-14 20:26 UTC (permalink / raw)
To: Christopher R. Jones <cj@interlog.com>; sql@chalmers.com.au; +Cc: pgsql-interfaces
I use PHP myself, but if I'm not mistaken there is a PostgreSQL Perl DBI
module (check CPAN).
And libpq can be compiled for Windows (not to mention all the other
platforms), so the Postgres.pm should work just fine.
I also think the PostgreSQL's user base is sufficient.
I'd say the discussion comes down to
I need a fast reliable database, but I don't need transactions then
MySQL
else PostgreSQL
PostgreSQL has its problem as does MySQL. PostgreSQL sacrifices some speed
for features that MySQL doesn't give.
And remember you get the code so you can fix it.
> 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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Re: [sql] mysql vs. postgresql
@ 1999-05-16 05:50 Ole Gjerde <gjerde@icebox.org>
parent: Christopher R. Jones <cj@interlog.com>
0 siblings, 0 replies; 3+ messages in thread
From: Ole Gjerde @ 1999-05-16 05:50 UTC (permalink / raw)
To: Christopher R. Jones <cj@interlog.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-05-16 05:50 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-14 18:39 Re: [sql] mysql vs. postgresql Christopher R. Jones <cj@interlog.com>
1999-05-16 05:50 ` Ole Gjerde <gjerde@icebox.org>
1999-05-14 20:26 RE: [INTERFACES] Re: [sql] mysql vs. postgresql Jackson, DeJuan <djackson@cpsgroup.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox