Re: MySQL vs. PostgresSQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

A few years ago I worked on a project that had PostgreSQL as the backend, I
found it to be a very good database to work with, liked it quite a bit
actually. A few years after that I wanted to see what all the hubbub was
with MySQL and did some research and played just a little bit. While it
seemed like a good system I found it was missing some features that
PostgreSQL had so I concluded I preferred PostgreSQL.

Today I'm working with SQL Server from Microsoft so I've sort of lost touch
with the open source products so I can't even recall what features MySQL
were missing. But if I wanted to go back I'd still go with PostgreSQL.

Just my 2 cents worth. But I also agree with Olaf, you really need to
define what you need the database to do before you can select one
appropriately.

Thanks,
Linn

"Rush Strong" <rush.strong@[DELETEME]verizon.net> wrote in message
news:%23GmfwLqFJHA.4056@xxxxxxxxxxxxxxxxxxxxxxx
My client is in the process of revamping their system, and wants to use a
Linux/SQL backend. Can anyone give me advice on MySQL vs. PostgreSQL? We
plan to use it primarily for data storage, with the business rules in VFP.

Thanks -

- Rush


.

Relevant Pages

  • Re: pro- foreign key propaganda?
    ... I had built the DB backend using postgresql. ... reasons decided to switch to MySQL and created his own tables (as well as ... They'd also never leave foreign keys out of their designs, too, I guess. ...
    (comp.databases.theory)
  • Re: Python, xml, databases, ...
    ... I think you want to be clear whether you want a database or not. ... Any machine can run a service (such as MySQL or PostgreSQL), ... both MySQL and PostgreSQL rely on the Cygwin dll. ...
    (comp.lang.python)
  • Re: Looking for a database
    ... >> The obvious choices on fedora will be MySQL and postgresql ... > If I was to chose between Postgresql and another free database it would ... > be between Postgresql and Firebird, ...
    (Fedora)
  • Moving a PostgreSQL database from one server to another
    ... I'm just moving to PostgreSQL from MySQL, ... my problem is that I set up and populated a database on my ... but of course my production website is not *on* my notebook. ...
    (Fedora)
  • Re: OT: give advice to MSAccess user
    ... On Wed, 2005-03-16 at 03:55, Duncan Lithgow wrote: ... > database - currently MSAccess. ... I don't know if there is a front end for MySQl or not. ... You may want to take a look at Postgresql as well. ...
    (Fedora)