Date: 27 Nov 1998 20:20:16 +0100 From: Tom Ivar Helbekkmo <tih@nhh.no> To: Tom Lane <tgl@sss.pgh.pa.us> Cc: pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql Message-ID: <861zmpj633.fsf@athene.nhh.no> In-Reply-To: Tom Lane's message of "Fri, 27 Nov 1998 11:53:45 -0500" References: <1747.912185625@sss.pgh.pa.us>
next in thread | previous in thread | raw e-mail | index | archive | help
Tom Lane <tgl@sss.pgh.pa.us> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?861zmpj633.fsf>