MySQL

Open Source Geonews: Esri Diving into Open Source, India Launches Open Data Portal, Open Transit, MySQL vs PostGIS, and more

Still catching up my August holidays, here's the recent geospatial open source and open data geonews.

In general news:

In software news:

Cross Comparison of SQL Server, MySQL and PostgreSQL

[this is old news from July and sharing it with our users to make sure they're aware of it] Spatially Adjusted linked in July to a BostonGIS article named "Cross Compare SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3-1.4, MySQL 5-6". Previous such comparison is over 1.5 years old, see also related stories below.

From the associated blog entry: "A few people have been asking us what are the pros and cons of using SQL Server 2008 Spatial and PostGIS and as a Windows user, why would you still consider using PostGIS. Rather than simply providing some hand-waving saying "well if you just care about displaying data, then use whatever you feel comfortable with, but if you want to do real intensive sophisticated spatial analysis and geometric processing without having to purchase a bunch of expensive software, then PostGIS is probably better for you. Hell why must you think in either or propositions - just use both using the strengths of each.", we have tried really hard to quantify the similarities and differences between the 2 and to boot - we have also added in MySQL."Story imported from the previous Slashgeo.org Slashcode site, user comments have not been migrated. For more information, please read Welcome to the new Slashgeo.org!. Thank you for your understanding.

[this is old news from July and sharing it with our users to make sure they're aware of it] Spatially Adjusted linked in July to a BostonGIS article named "Cross Compare SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3-1.4, MySQL 5-6". Previous such comparison is over 1.5 years old, see also related stories below.

From the associated blog entry: "A few people have been asking us what are the pros and cons of using SQL Server 2008 Spatial and PostGIS and as a Windows user, why would you still consider using PostGIS. Rather than simply providing some hand-waving saying "well if you just care about displaying data, then use whatever you feel comfortable with, but if you want to do real intensive sophisticated spatial analysis and geometric processing without having to purchase a bunch of expensive software, then PostGIS is probably better for you. Hell why must you think in either or propositions - just use both using the strengths of each.", we have tried really hard to quantify the similarities and differences between the 2 and to boot - we have also added in MySQL."

Syndicate content