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  
Hi,

I'm a GIS developer, who specialises in the architecture of geospatial
databases.

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.

Thanks, 


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 
Web: www.globalimage.co.za 
Web: www.mapme.co.za
Blog: http://electronucleus.blogspot.com/
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

hello,

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
 parang.saraf@stripped
Thread
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