[svlug] mySQL vs Postgres

[paul]

We were making a decision on this some years back and a Google search turned up 10X 
the hits for MySQL over Postgres (120,000 vs 12,000).  Now it's  about 7X (4,500,00 
vs. 672,000).  That indicates that either one has all the support you need.

The real issue is what kind of data are you working with/on?  Relational theory works 
very well on most businees/organizational databases.  If you are doing some business 
app. then go with MYSQL.  If you are doing research and have complex data with 
complex structures then you want either a networked database or an object database. 
Postgres fills the bill for an object database.  The PickOS has a kind of network 
database but I don't know of any in open source.

BTW, in 1985, the number one software company in the world was Cullinet with the IDMS 
networked database.  It disappeared into software hell at Computer Associates in 1989 
along with many other database.  Ingres lives on there as Jasmine(?)

J C Lawrence wrote:

> On Mon, 25 Mar 2002 11:14:55 -0800 
> Karen Shaeffer <shaeffer at neuralscape.com> wrote:
> 
> 
>>Which platform (mySQL or Postgres) has the larger developer and user
>>bases?  Ultimately the feature trajectory of a platform is quite
>>important in considering which is best to commit to working with?
>>
> 
> PostgresQL has the more active mailing lists AFAICT.  MySQL has done
> more substantive changes to their code base in less time recently.
> PostgresQL has been concentrating on stability, bug fixes and
> scalability almost to exclusion for a little over a year now, so that
> may explain the difference.
> 
> 


-- 
Paul Cubbage
Open Country, Inc.
408-472-1112 (Cell) 408-248-8530 (Office)