Flight numbers data

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Flight numbers data
Date: 2006-03-29 08:17:33
Message-ID: Pine.LNX.4.44.0603291103080.4731-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Hi, i am in the process of writing an application about
tickets, flights, etc, and i am thinking of getting the primitive
data ready at the begining and doing it the right way,
(e.g. the user will just select a flight number and doesnt
have to enter the airports, airport coordinates, countries,
airline name, airline code, departure/arrival times, etc...)

I found some sources on the web about airlines (codes, names, countries,
etc...), also i found about airports, but nothing about flight numbers!

This application will be for enterprise (internal) company use,
covering the flights of emploees around the world.

I was just wondering how internet ticket agents manage to do it.

Has anyone from the postgresql camp ever solved such a problem?

One point for me, is that my company is doing shipping,
and we are not in the travel agents business (IATA, standards etc..) at
all, so its hard for me to find the path to follow, and in addition,
going the full Travel Agent path would be an overkill, since what we need
is just an application for the tickets.

It is just that i wanna do it right, maybe play a little bit with AJAX
also who knows :)

Thanx for any hints.

--
-Achilleus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Hamill 2006-03-29 08:24:16 Re: More AIX 5.3 fun - out of memory ?
Previous Message SunWuKung 2006-03-29 08:08:54 updategram in pg

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2006-03-29 13:40:27 Ugly group by problem
Previous Message Owen Jacobson 2006-03-28 21:59:41 Re: Bitfields always atomic? Other way to store attributes?