From owner-freebsd-isp Mon Nov 10 10:29:22 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id KAA17648 for isp-outgoing; Mon, 10 Nov 1997 10:29:22 -0800 (PST) (envelope-from owner-freebsd-isp) Received: from news1.gtn.com (news1.gtn.com [192.109.159.3]) by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id KAA17627 for ; Mon, 10 Nov 1997 10:29:11 -0800 (PST) (envelope-from andreas@klemm.gtn.com) Received: (from uucp@localhost) by news1.gtn.com (8.8.6/8.8.6) with UUCP id TAA10622; Mon, 10 Nov 1997 19:15:18 +0100 (MET) Received: (from andreas@localhost) by klemm.gtn.com (8.8.7/8.8.7) id SAA10605; Mon, 10 Nov 1997 18:11:37 +0100 (CET) (envelope-from andreas) Message-ID: <19971110181136.45756@klemm.gtn.com> Date: Mon, 10 Nov 1997 18:11:36 +0100 From: Andreas Klemm To: "Amjad R. Alsharif" Cc: isp@FreeBSD.ORG Subject: Re: PostgreSQL for Yellow Pages implementation References: <199711071458.JAA15692@doleh.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.84 In-Reply-To: ; from Amjad R. Alsharif on Mon, Nov 10, 1997 at 12:40:13PM +0200 X-Disclaimer: A free society is one where it is safe to be unpopular X-Operating-System: FreeBSD 3.0-CURRENT SMP Sender: owner-freebsd-isp@FreeBSD.ORG X-Loop: FreeBSD.org Precedence: bulk On Mon, Nov 10, 1997 at 12:40:13PM +0200, Amjad R. Alsharif wrote: > > Dear Sir / Madam, > > Please do bear withme since I do not know the best approach to present > you with my immediate need to implement PostgreSQL. > > I need to establish an Online "Yellow Pages" to serve the business > communite within Jerusalem area so I have been looking into different databases > listed under "www.freebsd.org/ports/databases.html" and I think Postgres95 > "www.postgresql.org" is the answer to this issue. But the problem is > that I can not see how it all would fit together. Postgresql is a really nice database ... > Thus, if I was to implement it, I need to know: > > 1. What Models do go best with PostgreSql which would gurantee me > not only WEB interface but also embeding search query within HTNL. You can compile the php module into apache Web server and do database queries ... > 2. Are there any Guideline for creating "Yellow Pages" on the Internet? Dunno ... > 3. Do you think that PostgreSQL is the right product for such a project? Yes I think so. -- Andreas Klemm powered by ,,symmetric multiprocessor FreeBSD''