List:General Discussion« Previous MessageNext Message »
From:Dewald Troskie Date:May 10 2006 9:11am
Subject:RE: comparing postgis with mysql
View as plain text  

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.


Dewald Troskie
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
Email: dewald@stripped 
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"

-----Original Message-----
From: parang.saraf@stripped [mailto:parang.saraf@stripped] On Behalf
Of Parang Saraf
Sent: 09 May 2006 10:06 PM
To: mysql@stripped
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
windows platform.

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
Parang Saraf
comparing postgis with mysqlParang Saraf9 May
  • Re: comparing postgis with mysqlRhino9 May
  • Re: comparing postgis with mysqlPeter Brawley10 May
RE: comparing postgis with mysqlDewald Troskie10 May