tag:blogger.com,1999:blog-35868762.post2216445244065909157..comments2023-05-16T07:56:56.864-07:00Comments on Dead Programmer Society: In Search Of SearchRon Evanshttp://www.blogger.com/profile/06754261780924273552noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-35868762.post-12819972406956987922008-05-23T09:03:00.000-07:002008-05-23T09:03:00.000-07:00No offense taken, it is a legit question! There we...No offense taken, it is a legit question! There were a few reasons why PostgreSQL tsearch full-text search seemed like a more difficult approach:<BR/>- Although there is a Rails plugin for Postgres called <A HREF="http://code.google.com/p/acts-as-tsearch/" REL="nofollow">acts_as_tsearch</A> it is in a very early stage of development, and does not support the latest Postgres 8.3 release which is where tsearch is built-in.<BR/><BR/>- The client is not running the 8.3 release anyhow, which means that the TSearch capability would need to be installed on the database cluster, which we do not have direct access to (being a shared cluster which is part of a managed hosting service).<BR/><BR/>- The full text syntax of pgsql to just write SQL to perform the search is rather ugly, and would probably be even harder to maintain, than what is generated for Sphinx.<BR/><BR/>- It is nice to pretend that we have database independent codeRon Evanshttps://www.blogger.com/profile/06754261780924273552noreply@blogger.comtag:blogger.com,1999:blog-35868762.post-42335854631652977042008-05-22T17:53:00.000-07:002008-05-22T17:53:00.000-07:00OK, maybe that sounded a little obnoxious. Not int...OK, maybe that sounded a little obnoxious. Not intentional. Let me rephrase. I'm curious to know why you went through all that trouble instead of using PostgreSQL's built in search. I could understand why you wouldn't want to use MySQL's (various limitations described in MySQL docs). But PostgreSQL's seems pretty good. Is it deficient in some way I'm not aware of? I'm wondering because I'm building an app that requires search and sizing up options.Unknownhttps://www.blogger.com/profile/12675724296883613718noreply@blogger.comtag:blogger.com,1999:blog-35868762.post-45435237190419481242008-05-22T15:42:00.000-07:002008-05-22T15:42:00.000-07:00Why didn't you just use PostgreSQL's built-in full...Why didn't you just use PostgreSQL's built-in full text search functionality?Unknownhttps://www.blogger.com/profile/12675724296883613718noreply@blogger.com