If you didn’t get a chance to fly down to Sydney to attend the FOSSG4 conference (I certainly didn’t!), they now have video casts up of most presentations at http://blip.tv/search?q=fosslc. One I found interesting was a great video cast of the presentation by Paul Ramsey on development progress on PostGIS at the recent FOSSG4.
A great mention as well for Manifold as one of the GIS packages supporting PostGIS in the video by Paul Ramsey, although he alleges to some FUD that Manifold the company spread regarding PostGIS ( at 13:15 in the video, although I don’t remember what particular Dimitri postings he was referring too :-)
According to Paul’s presentation, PostGreSQL (with PostGIS) certainly seems to be at least equal to other spatially enabled databases in terms of feature completeness, performance and robustness, and its free, making procurement much easier (19:00 min in video). And the new release of PostGIS seems to be all about speed improvements, which is obviously a good thing. A overview of the roadmap ahead for PostGIS promises a lot of things to come…
Now, my interest in PostGIS has only started lately, mostly because I was asked to develop a “Introduction to Spatial Databases” e-learning course. Given the need for students to be able to run the practicals on their home computers, we chose PostGIS and Quantum GIS as the software tools for the tutorials. I must say I have been impressed by the functionality of PostGIS, and it certainly hasn’t been a very steep learning curve for me, thanks mostly to my previous Spatial SQL knowledge learned from Manifold’s Spatial SQL experience. Although the syntax and some of the commands are slightly different between PostGIS SQL and Manifold Spatial SQL, knowledge of either is really helpful when trying to write queries! Wider issues of optimisation such as spatial indexes though present another level of complexity/power in PostGIS, which Manifold’s internal SQL engine doesn’t expose to the user.
Leave a Reply