I'm a GIS developer, who specialises in the architecture of geospatial
PostGIS (a derivitive of PostGreSQL) has been developed with spatial
data in mind, and as such is primarily for this use. I have tried MySQL
with Spatial extensions, whose implementation is very good I must say,
but on doing stress and load tests PostGIS definitely comes out a
winner. If you have small spatial databases, I would recommend MySQL
though as it is definitely easier to use and implement in my experience.
I will try locate some comparison charts and find my comparison tests I
have done myself on these two DB's and mail them to you.
GIS Developer / Database Architect
GIS Global Image (Pty) Ltd.
Helping the world make informed decisions
P.O Box 15 The Innovation Hub 0087
Cell: +27 (0)72 685 4246
Tel: +27 (0)12 844 0660
Fax: +27 (0)86 619 3958
Registered Linux User No: 371874
Office L15 Enterprise Building
The Innovation Hub - Hotel Street
Lynnwood, Pretoria, 0087
"The are 10 kinds of people, those who
understand binary and those who don't"
From: parang.saraf@stripped [mailto:parang.saraf@stripped] On Behalf
Of Parang Saraf
Sent: 09 May 2006 10:06 PM
Subject: comparing postgis with mysql
I am relatively new in this field. I am designing a database to store
the events extracted from the oceans. This project later demands of
publishing data on web. I am not able to decide which database to use.
Mysql with spatial extension or the postgis one. I would prefer to use
Can someone suggest or can provide me with some links that compare the
two databases. Do you think Mysql has a better spatial elements handling
capacity in comparison to postgis.?
please reply soon.
Thanks and Regards