Fulltext Search
Apache Lucene - PHP Implementation VS Java version
I have indexed more than 7GB of data which consists of large PDF files, IMAP mailboxes, Text files, DOC files, etc.
DBSight - The Ultimate Faceted Database Search
I recently came accross such a product that’s worth mentioning here. I was able to set it up on my pc in less than 3 minutes. It comes with a very easy to use web interface. It makes use of JDBC to retrieve data from virtually any database. You can specify an SQL query to specify the search able records.