From owner-freebsd-database Fri Nov 27 11:20:30 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id LAA17985 for freebsd-database-outgoing; Fri, 27 Nov 1998 11:20:30 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from hesiod.nhh.no (hesiod.nhh.no [158.37.96.15]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id LAA17977 for ; Fri, 27 Nov 1998 11:20:28 -0800 (PST) (envelope-from tih@athene.nhh.no) Received: from athene.nhh.no (athene.nhh.no [158.37.96.16]) by hesiod.nhh.no (8.8.8/8.8.8) with ESMTP id UAA21041; Fri, 27 Nov 1998 20:20:17 +0100 (CET) Received: (from tih@localhost) by athene.nhh.no (8.8.8/8.8.8) id UAA15125; Fri, 27 Nov 1998 20:20:17 +0100 (CET) To: Tom Lane Cc: pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql References: <1747.912185625@sss.pgh.pa.us> From: Tom Ivar Helbekkmo Date: 27 Nov 1998 20:20:16 +0100 In-Reply-To: Tom Lane's message of "Fri, 27 Nov 1998 11:53:45 -0500" Message-ID: <861zmpj633.fsf@athene.nhh.no> Lines: 24 X-Mailer: Gnus v5.6.44/Emacs 19.34 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Tom Lane writes: > I don't currently have any databases that could benefit from full-text > indexes. But I can think of applications where it'd be important, > particularly after we get rid of the limit on tuple sizes so that it > becomes reasonable to put fair-size chunks of text into database > entries. For example: would it be useful to put my email archive into > a Postgres database, one message per tuple? Maybe ... but if I can't > glimpse it afterwards, forgetaboutit. Another very important application is the keeping of structured documents in a database system. Advanced SGML environments do this, and Philip Greenspun of MIT, the author of the excellent book "Database Backed Web Sites" (see http://photo.net/ for information) recommends doing it for HTML and other data for web publishing. The web server AOLserver is just one example of an application that can do this -- and if I'm not mistaken, AOLserver can even use PostgreSQL. Anyway, once the data is in the database, and much of it is text, it becomes very interesting to be able to efficiently index and search. -tih -- Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier" To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message