On Apr 5, 2004, at 9:27 AM, wchast@utilpart.com wrote:
> Ronan Heffernan wrote:
>> I have used Postgres extensively in professional projects since 1994,
>> and I have used MySQL for some websites (especially to run PostNuke),
>> so you can see where my bias might lie. MySQL is supposed to have a
>> speed advantage (in case you are doing a lot of processing on a slow
>> machine). Postgres has a definite feature advantage (ACID compliant
>> transactions, nested subqueries, etc.) I have been very frustrated
>> trying to work around some of the missing features in MySQL
>> (especially nested sub-queries like: select * from tablea where (id
>> not in (select ta_id from table b where active)); ) and would highly
>> recommend Postgres for its reliability.
>>
>
> Ahh, this sounds like the sort of thing I may have to deal with. We
> will
> have multiple mapping consoles looking at the data in the database,
> each
> console will have a geographical part of the view and will look at
> vehicles in that geo-area, but there will also be operators that will
> look at vehicles based on ID, service type (i.e. distrubution,
> transport,
> public safety etc) so these will be pulling data based on a unique id
> or other unique data.
PostgreSQL also support user-defined types and functions. Someome has
already written an add-on function for calculating earth distance
between lat/long coordinates. Stuff like that could come in handy for
what you're doing (which sounds pretty cool!).
>
> Then of course they will all be looking for vehicles which are sending
> some type of alarm code which will cause that vehicle icon to change
> color or flash or some other action that will make the icon stand out
> on the mapper screen.
>
> Under normal operation, the mappers will not see vehicles that are not
> either selected or in trouble.
>
> Chuck Hast
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:12:12 EDT