3

i'm working on a web-platform which analyzes GPX-Tracks and draws some profiles, speed stuff, etc. Currently i just calculate the statistics once (like distance, avg speed, duration, height gain/loose) and keep the GPX-File. The Profile is drawn once and stored on disk.

But currently i want to update this to a Javascript based Graph-Library to choose what kind of graph you want to plot. For this to work i need to access the trkpt's of the GPX-File over and over again and started to think abut putting the points into the Database to access them easier.

The question i'm asking myself now is, does it make sense to me to switch over to PostgreSQL and use postgis or will i just stay at mysql and join the stuff in as i was teached in the normalization-class? ;)

Are there any other benefits of postgis beside calculating distances and stuff? Because the only situation i calculate the distances between lon/lat-Points is once someone uploads a new file. Afterwards i only want to access the points (coordinates, times, speeds and elevations) on a easy way?

Thanks, Sven

Sven Eppler
  • 1,646
  • 1
  • 15
  • 26

2 Answers2

3

Bostonongis has an overview of MySQL 5.1 and PostgreSQL 8.3/PostGIS 1.3. PostGIS is much more mature, but it all depends on your requirements if you benefit from this. Just give it a try and see if you feel happy with it.

Have fun!

Frank Heikens
  • 117,544
  • 24
  • 142
  • 135
0

The BostonGIS cross compare is really a a good place to have an idea of the benefits you can have.

I've been using PostgreSQL/PostGIS for a while now, and I'm quite happy with it. Back on my researcher days at the university one of my reseach topics was migrating a deductive database system, to PostgreSQL and then to PostgGIS manly because of the limitations that MySQL presented when using geometric data.

So it's a matter of looking at your needs and looking a bit into a the future and check if it would be worth it.

rmcc
  • 743
  • 1
  • 6
  • 14