A Point on Using PostgreSQL

Starting my web development I chose a very wise combination of Linux, Apache, MySQL and PHP (aka the LAMP stack), and has served me well… One consideration early on was to use PostgreSQL, which is a free SQL implementation. At the time I was having too much frustration with the lack of documentation for it. Now things are different, event ISP support has greatly improved.

One of the things that was really compelling about Postgres is better support for GIS (Geographic Information Systems) data and queries. Here is a link to a slide set, does a good job of introducing spacial data and GIS concepts http://www.slideshare.net/dersteppenwolf/building-a-spatial-database-in-postgresql

Eventually I plan to transition to Postgres. The main issues besides time to do it are are initial configuration (which is the case with everything different) and then secondly is MySQL is a tad more lenient on adhering to the SQL standard then Postgres, so there would need to be some updates to Queries.

~~LINKBACK~~ ~~DISCUSSION~~