I don't think it really matters, doesn't look like you'll need any
features which are only available in one or the other!
The main issue you will have is supporting the application and the RDBMS
so go for the one you are most comfortable with and can support/configure
> 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
> longitude, time, speed. etc-, none of them is a text field.
> - The database also should create a table for every truck -around 100
> - 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.
> This email has been scanned by Netintelligence