Thread: Re: MySQL or Postgres ?
Hello Ed, Thanks a lot for your response. As I'm used to work with Oracle and reading back the story os PostgreSQL and having a shallow knoledge of the engine, in general, I will choose it over MySQL. Anyway, it shoul be very nice to somehow get a comparison chart to have handy the evident diffs between the engines. Regds, F. Ed Yu wrote: > That totally depends on your application. If I want something to replace MS > Access in a small application environment, I'll use MySQL, otherwise > Postgresql (or MSSQL, DB2, Oracle). > > "Fabiàn R. Breschi" <fabian.breschi@acm.org> wrote in message > news:3D481906.F1DD94AE@acm.org... > > Hi there, > > > > If you'd have to suggest which type of database one migh use, how would > > you reflect the differences between them to show up pros and cons ? > > > > Any URL to help me to clarify this situation ? > > > > Thank you very much indeed. > > > > Fabian.
From an MySQL perspective, but still nice... http://www.mysql.com/information/crash-me.php alex Fabiàn R.Breschi wrote: >Hello Ed, > >Thanks a lot for your response. > >As I'm used to work with Oracle and reading back the story os PostgreSQL and >having a shallow knoledge of the engine, in general, I will choose it over >MySQL. > >Anyway, it shoul be very nice to somehow get a comparison chart to have handy >the evident diffs between the engines. > >Regds, > >F. > >Ed Yu wrote: > > > >>That totally depends on your application. If I want something to replace MS >>Access in a small application environment, I'll use MySQL, otherwise >>Postgresql (or MSSQL, DB2, Oracle). >> >>"Fabiàn R. Breschi" <fabian.breschi@acm.org> wrote in message >>news:3D481906.F1DD94AE@acm.org... >> >> >>>Hi there, >>> >>>If you'd have to suggest which type of database one migh use, how would >>>you reflect the differences between them to show up pros and cons ? >>> >>>Any URL to help me to clarify this situation ? >>> >>>Thank you very much indeed. >>> >>>Fabian. >>> >>> > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > > > > -- ________________________________________________________ Institut fuer Geographie und Regionalforschung Universitaet Wien Kartografie und Geoinformation Departement of Geography and Regional Research University of Vienna Cartography and GIS Universitaetstr. 7, A-1010 Wien, AUSTRIA Tel: (+43 1) 4277 48644 Fax: (+43 1) 4277 48649 E-mail: alexander.pucher@univie.ac.at FTP: ftp://ftp.gis.univie.ac.at WWW: http://www.gis.univie.ac.at/karto -------------------------------------------------------- Atlas of Eastern and Southeastern Europe: http://www.aos.ac.at -------------------------------------------------------- M$ is not the answer. M$ is the question! No is the answer -- Eric Naggum
Even from the MySQL perspective Postgres stands up pretty darn well. In fact I think it equals and/or beats MySQL on most of the points on that list, with perhaps the only thing thing it loses out on is ODBC support and maybe the number of internal functions. (Of course, since Postgres has a vastly superior support of procedural languages, that really wouldn't be the case, but this particular data doesn't present that). Actually it's even more impressive since this compares MySQL to Pg 7.1.1. Robert Treat On Wed, 2002-08-07 at 02:36, Alexander Pucher wrote: > From an MySQL perspective, but still nice... > > http://www.mysql.com/information/crash-me.php > > alex > > > > Fabiàn R.Breschi wrote: > > >Hello Ed, > > > >Thanks a lot for your response. > > > >As I'm used to work with Oracle and reading back the story os PostgreSQL and > >having a shallow knoledge of the engine, in general, I will choose it over > >MySQL. > > > >Anyway, it shoul be very nice to somehow get a comparison chart to have handy > >the evident diffs between the engines. > > > >Regds, > > > >F. > > > >Ed Yu wrote: > > > > > > > >>That totally depends on your application. If I want something to replace MS > >>Access in a small application environment, I'll use MySQL, otherwise > >>Postgresql (or MSSQL, DB2, Oracle). > >> > >>"Fabiàn R. Breschi" <fabian.breschi@acm.org> wrote in message > >>news:3D481906.F1DD94AE@acm.org... > >> > >> > >>>Hi there, > >>> > >>>If you'd have to suggest which type of database one migh use, how would > >>>you reflect the differences between them to show up pros and cons ? > >>> > >>>Any URL to help me to clarify this situation ? > >>> > >>>Thank you very much indeed. > >>> > >>>Fabian. > >>> > >>> > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 4: Don't 'kill -9' the postmaster > > > > > > > > > > > -- > ________________________________________________________ > > Institut fuer Geographie und Regionalforschung > Universitaet Wien > Kartografie und Geoinformation > > Departement of Geography and Regional Research > University of Vienna > Cartography and GIS > > Universitaetstr. 7, A-1010 Wien, AUSTRIA > > Tel: (+43 1) 4277 48644 > Fax: (+43 1) 4277 48649 > E-mail: alexander.pucher@univie.ac.at > > FTP: ftp://ftp.gis.univie.ac.at > WWW: http://www.gis.univie.ac.at/karto > -------------------------------------------------------- > Atlas of Eastern and Southeastern Europe: http://www.aos.ac.at > -------------------------------------------------------- > > M$ is not the answer. M$ is the question! > No is the answer -- Eric Naggum > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html