Digital Geography

HeidiSQL vs. pgAdmin III – a small speed-test

HeidiSQL, a free database-client, now supports PostgreSQL/PostGIS in the newest nightly builds. Using HeidiSQL with MySQL was always a pleasure and I often had the feeling that the pgAdmin III client of PostgreSQL is slow and not very user-friendly in some points. Because of this I had to test the difference of performance of these two clients. I don’t want to talk about features and handling because this is on the one hand a matter of taste and on the other hand the support of PostgreSQL is very new in HeidiSQL. Instead, I want to compare some simple SQL-queries in…

ArcGIS server vs. Open Source GIS solutions

originally posted from our friends @mappinggis Which program is better suited to serve geographic data on the web? ArcGIS Server form ESRI or open source ? This question is common in mailing lists and GIS-forums. The most consistent answer is that depends on the project. But in this post we will see some numbers to determine which is the best software to develop an application for web mapping: