pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgreSQL vs mySQL
3+ messages / 3 participants
[nested] [flat]
* postgreSQL vs mySQL
@ 2000-03-07 15:16 Antonio W. Lagnada <alagnada@lsil.com>
2000-03-07 16:38 ` Re: [SQL] postgreSQL vs mySQL Mitch Vincent <mitch@venux.net>
0 siblings, 1 reply; 3+ messages in thread
From: Antonio W. Lagnada @ 2000-03-07 15:16 UTC (permalink / raw)
To: pgsql-sql
Hello,
Can anyone tell me what the difference is between mySQL and postgreSQL
(performance wise, etc...) and other opinions are welcome.
--
Antonio W. Lagnada
952.921.8533
alagnada@lsil.com_NOSPAM
Remove the _NOSPAM for
the actual email address
Attachments:
alagnada.vcf (text/x-vcard, 412B) download
begin:vcard
n:Lagnada;Antonio W.
tel;pager:612-414-9149
tel;cell:612-414-9149
tel;fax:612-921-8843
tel;home:651-501-2587
tel;work:612-921-8533
x-mozilla-html:TRUE
url:http://www.lsil.com
org:LSI Logic Corporation;Silicon Optimization
version:2.1
email;internet:alagnada@lsil.com
title:Design Engineer
adr;quoted-printable:;;8300 Norman Center=0D=0ASuite 730;Bloomington;MN;55437;
fn:Antonio W. Lagnada
end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] postgreSQL vs mySQL
2000-03-07 15:16 postgreSQL vs mySQL Antonio W. Lagnada <alagnada@lsil.com>
@ 2000-03-07 16:38 ` Mitch Vincent <mitch@venux.net>
2000-03-09 01:04 ` Re: [SQL] postgreSQL vs mySQL Mathijs Brands <mathijs@ilse.nl>
0 siblings, 1 reply; 3+ messages in thread
From: Mitch Vincent @ 2000-03-07 16:38 UTC (permalink / raw)
To: Antonio W. Lagnada <alagnada@lsil.com>; pgsql-sql
IMHO MySQL is faster but much less feature rich. I do development for both
and they both have their uses. I use MySQL when I just "plug and pull"
meaning that it's just a quick way to store random information. For real
applications though I like to use PostgreSQL because it supports lots of
very nice features like transactions!
And , of course, MySQL isn't free -- PostgreSQL is.
I think that in 7.0 some of the speed issues of Postgre will be greatly
improved (which is it's only real weak point and it's just slow in
comparision with much less feature rich backends)..
- Mitch
----- Original Message -----
From: Antonio W. Lagnada <alagnada@lsil.com>
To: Pgsql-sql <pgsql-sql@postgreSQL.org>
Sent: Tuesday, March 07, 2000 10:16 AM
Subject: [SQL] postgreSQL vs mySQL
> Hello,
>
> Can anyone tell me what the difference is between mySQL and postgreSQL
> (performance wise, etc...) and other opinions are welcome.
>
> --
> Antonio W. Lagnada
>
> 952.921.8533
> alagnada@lsil.com_NOSPAM
> Remove the _NOSPAM for
> the actual email address
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] postgreSQL vs mySQL
2000-03-07 15:16 postgreSQL vs mySQL Antonio W. Lagnada <alagnada@lsil.com>
2000-03-07 16:38 ` Re: [SQL] postgreSQL vs mySQL Mitch Vincent <mitch@venux.net>
@ 2000-03-09 01:04 ` Mathijs Brands <mathijs@ilse.nl>
0 siblings, 0 replies; 3+ messages in thread
From: Mathijs Brands @ 2000-03-09 01:04 UTC (permalink / raw)
To: Mitch Vincent <mitch@venux.net>; +Cc: Antonio W. Lagnada <alagnada@lsil.com>; pgsql-sql
On Tue, Mar 07, 2000 at 11:38:17AM -0500, Mitch Vincent allegedly wrote:
> IMHO MySQL is faster but much less feature rich. I do development for both
> and they both have their uses. I use MySQL when I just "plug and pull"
> meaning that it's just a quick way to store random information. For real
> applications though I like to use PostgreSQL because it supports lots of
> very nice features like transactions!
>
> And , of course, MySQL isn't free -- PostgreSQL is.
Yes it is. You only need a license for the Windows version and there are
good reasons for that. It is true that the company developing MySQL really
appreciates people buying licenses, just as the PostgreSQL teams appreciates
donations.
> I think that in 7.0 some of the speed issues of Postgre will be greatly
> improved (which is it's only real weak point and it's just slow in
> comparision with much less feature rich backends)..
PostgreSQL 6.3 was rather unstable (IMHO), but I haven't had stability
problems with 6.5 yet.
PostgreSQL and MySQL both have their uses (and these overlap for a large
part), but you do reach a point where both don't cut it anymore and you
need to 'upgrade' to something like DB2 or Oracle. And that's when you
really start longing for a database that lets you do what you want to do,
without all that overhead. ;)
One of the reasons I really like PostgreSQL and MySQL is the fact that
distance between the developers and users is really small. Also, reading
the mailinglists (especially the PostgreSQL list) you discover that the
developers aren't super-human after all. Also, discussions impacting the
future of PostgreSQL are done on the list, so you can have a lot of
influence on the development of PostgreSQL.
Personally I like PostgreSQL better than MySQL, but MySQL scales better
and is easier to use in a threaded environment. However, when it comes
to features, MySQL is no match for PostgreSQL...
Enough BS,
Mathijs
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-03-09 01:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-03-07 15:16 postgreSQL vs mySQL Antonio W. Lagnada <alagnada@lsil.com>
2000-03-07 16:38 ` Mitch Vincent <mitch@venux.net>
2000-03-09 01:04 ` Mathijs Brands <mathijs@ilse.nl>
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