MySQL Forums
Forum List  »  PostgreSQL

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


I'm currently developing a program for centralizing the vehicle fleet GPS information -, 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

Written By
MySQL versus PostgreSQL for GPS Data
March 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.