K nearest neighbor: Only PostGIS supports KNN. This is propĪggregate functions: to the best of my knowledge MySQL offers no spatial aggregates functions SRID in calculations, give your points a different SRID and you'll get different values back.Here is a list of things PostGIS supports that are totally absent in MySQL and MariaDB. You should be able to pick up enough to make the switch in a couple of weeks time, and if you set up a development database you can probably be well versed in routine tasks within a month, and confident you know where to look in the manual for the not-so-routine ones. The initial learning curve may be a bit steep and you may need to tweak your database and any stored procedures (if you've written them for MySQL already), but it is not an insurmountable task. In terms of making the switch from MySQL, the documentation behind Postgres is first-rate, and there's also a section of the Oostgres Wiki about switching from MySQL to Postgres. It can certainly handle everything else you would normally do in a relational database as well. If GIS-related queries are at the heart of what you're doing my suggestion would be to go with Postgres. The avationDB site is also built on top of Postgres (8.0). I can't speak to advantages/disadvantages vis-a-vis MySQL, but the PostGIS code is pretty widely regarded as one of the best (in terms of speed/functionality) and most mature (in terms of testing/real-world exposure) available.īy way of example, there was a talk at PGEast 2010 by some folks from the FAA on their converting their airport database (used by AeroNav and others to compile charts) to Postgres/PostGIS from Oracle.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |