[GENERAL] PostgreSQL versus MySQL for GPS Data

2009-03-17 Thread Juan Pereira
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-, no

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

2009-03-17 Thread Juan Pereira
Craig Ringer wrote: >> You're almost always better off using a single table with a composite >> primary key like (truckid, datapointid) or whatever. If you'll be doing >> lots of queries that focus on individual vehicles and expect performance >> issues then you could partition the table by truck

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

2009-03-18 Thread Juan Pereira
John Cheng wrote: >> This is question for Juan, have you asked the MySQL mailing list? Not yet. Admitting my ignorance in databases, I'm trying to understand all the concepts discussed in this thread . Be sure today I will ask the MySQL list. Thanks 2009/3/17 John Cheng > This is question f

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

2009-03-20 Thread Juan Pereira
John Cheng wrote: >> This is question for Juan, have you asked the MySQL mailing list? I'm afraid MySQL general list isn't as dynamic as PostgreSQL general list. http://lists.mysql.com/mysql/216795 MySQL general list: 4 answers in about 48 hours PostgreSQL general list: 27 answers in about 72 h

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

2009-03-23 Thread Juan Pereira
Juan Karlos 2009/3/20 Pavel Stehule > Hello > > it isn't correct comparation. > > MySQL people use mainly web forum > > regards > Pavel Stehule > > 2009/3/20 Juan Pereira : > > John Cheng wrote: > > > >>> This is question for Juan, have