agora inbox for pgsql-sql@postgresql.orghelp / color / mirror / Atom feed
best strategy for searching large text fields 2+ messages / 2 participants [nested] [flat]
* best strategy for searching large text fields @ 2014-10-31 14:59 Campbell, Lance <lance@illinois.edu> 0 siblings, 1 reply; 2+ messages in thread From: Campbell, Lance @ 2014-10-31 14:59 UTC (permalink / raw) To: pgsql-sql PostgreSQL 9.3.x I am looking for really good documentation on how to do the following. Use Case I have a web application that will be storing into a table large blocks of HTML web content. Users will then want to search these fields for phrases. What is the best strategy for handling this in PostgreSQL? What would the SQL look like? What data type should the web content field be in the table? Is there a way to set up the SQL so that matches are best match to least accurate match? Etc... Thanks, Lance Campbell<http://illinois.edu/person/lance; Software Architect Web Services at Public Affairs 217-333-0382 [University of Illinois at Urbana-Champaign logo]<http://illinois.edu/; Attachments: [image/png] image001.png (1.4K, ../../B75CD08C73BD3543B97E4EF3964B7D701FC6EC81@CITESMBX1.ad.uillinois.edu/3-image001.png) download | view image ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: best strategy for searching large text fields @ 2014-10-31 15:17 Julien Cigar <jcigar@ulb.ac.be> parent: Campbell, Lance <lance@illinois.edu> 0 siblings, 0 replies; 2+ messages in thread From: Julien Cigar @ 2014-10-31 15:17 UTC (permalink / raw) To: Campbell, Lance <lance@illinois.edu>; +Cc: pgsql-sql On Fri, Oct 31, 2014 at 02:59:48PM +0000, Campbell, Lance wrote: > PostgreSQL 9.3.x > I am looking for really good documentation on how to do the following. > > Use Case > I have a web application that will be storing into a table large blocks of HTML web content. Users will then want to search these fields for phrases. What is the best strategy for handling this in PostgreSQL? > > What would the SQL look like? > What data type should the web content field be in the table? > Is there a way to set up the SQL so that matches are best match to least accurate match? > Etc... > FTS is the way to go: http://www.postgresql.org/docs/9.3/static/textsearch-intro.html > > > > Thanks, > > Lance Campbell<http://illinois.edu/person/lance; > Software Architect > Web Services at Public Affairs > 217-333-0382 > [University of Illinois at Urbana-Champaign logo]<http://illinois.edu/; > > -- Julien Cigar Belgian Biodiversity Platform (http://www.biodiversity.be) PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-10-31 15:17 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-10-31 14:59 best strategy for searching large text fields Campbell, Lance <lance@illinois.edu> 2014-10-31 15:17 ` Julien Cigar <jcigar@ulb.ac.be>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox