pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgreSQL 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