Skip navigation links

MySQL Forums :: PostgreSQL :: MySQL versus PostgreSQL for GPS Data


Advanced Search

MySQL versus PostgreSQL for GPS Data
Posted by: juan carlos ()
Date: March 20, 2009 07:57AM

Hello,

I'm currently developing a program for centralizing the vehicle fleet GPS information -http://openggd.sourceforge.net-, written in C++.

The database should have these requirements:

- The schema for this kind of data consists of several arguments -latitude, longitude, time, speed. etc-, none of them is a text field.
- The database also should create a table for every truck -around 100 trucks-.
- There won't be more than 86400 * 365 rows per table -one GPS position every second along one year-.
- There won't be more than 10 simultaneously read-only queries.

The question is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL?


Thanks in advance

Juan Karlos

Options: ReplyQuote


Subject Views Written By Posted
MySQL versus PostgreSQL for GPS Data 8413 juan carlos 03/20/2009 07:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.