[svlug] mySQL vs Postgres
paul at opencountry.org
Mon Mar 25 14:55:29 PST 2002
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.
Open Country, Inc.
408-472-1112 (Cell) 408-248-8530 (Office)
More information about the svlug