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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Parang Saraf Sent: 09 May 2006 10:06 PM To: mysql@lists.mysql.com 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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]