Re: [SLUG] A question of databases

From: Frank Roberts - SOTL (sotl155360@earthlink.net)
Date: Sat Apr 03 2004 - 13:24:56 EST


Barnes & Nobel in Clearwater US 19 has an amply supply of books on MySQL.
I have no idea of what books they have on PostGRES.

Frank

On Saturday 03 April 2004 08:06, Travis R. Birt wrote:
> Either should work just fine. Currently, Mysql is the more popular in
> most circles. It
> would normally have to do with which you are more familiar with. If you
> are not familiar
> with either, I would look at the library and see which you can more
> easily get a book on.
> I would think to set up a DB correctly and efficiently that you will
> need a book on
> either of the databases. :) Good luck!
>
> wchast@utilpart.com wrote:
> >This is really new territory for me (I am a radio guy) I am going to
> >do some AVL work, I need to capture data into a database, that data
> >will be read into mapping machines in order to track the vehicles.
> >
> >I see that I have available two database products on my RedHat machines,
> >MySQL and PostGRES.
> >
> >What of these or what other db should I use for this sort of activty.
> >At present there will be the following data fields in the db.
> >ID, Lat, Lon, gps_time, time_received, status, additional data
> >
> >gps_time is the time that the record was generated in the vehicle
> >received_time is the time it is entered into the database
> >status is a code that would change if some event (panic button,
> >inertia switch, open door, etc) is activated, and additional data is
> >other data the remote end can send to the database.
> >
> >
> >Chuck Hast
> >------------------------------------------------------------------------
> >Telecomms Consultant, Utility Partners.
> >WEB www.utilpart.com
> >Office number: 813.282.8828 x 1175
> >C-phone number: 813.765.6743
> >E-mail: wchast@utilpart.com
> >SMS < 150 characters: 8137656743@mobile.att.net
> >ARS KP4DJT
> >
> >To paraphrase my flight instructor;
> >"the only dumb question is the one you DID NOT ask resulting in my going
> >out and having to identify your bits and pieces in the midst of torn
> >and twisted metal."
> >
> >
> >
> >*****************************************************************
> >This e-mail and any files transmitted with it are confidential and are
> >intended solely for the use of the individual or entity to whom it is
> >addressed. If you have received this transmission in error, please notify
> >the sender immediately and destroy any hard copies you may have printed
> > and remove all copies of the e-mail from your hard drive. Opinions,
> > conclusions and other information in this message that do not relate to
> > the official business of Utility Partners, Inc shall be understood as
> > neither given nor endorsed by it.
> >
> >Visit us on the web at http://www.utilpart.com
> >*****************************************************************
> >
> >
> >-----------------------------------------------------------------------
> >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 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 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:10:16 EDT