Hear us Roar
Article:
 |
|
MySQL FULLTEXT Searching
|
| Subject: |
|
This can be easily done via DBSight |
| Date: |
|
2007-03-28 17:27:22 |
| From: |
|
chrislusf
|
|
|
I just need 2 SQLs:
select * from blog_entries
select * from blog_categories where categoryID = ?
Then I can use DBSight to create a Lucene based full text search.
Please take a look at this
http://wiki.dbsight.com/index.php?title=Create_Lucene_Database_Search_in_3_minutes
You can create a full-text database search service, return results as HTML/XML/JSON. It uses the Lucene directly in java, but can be easily used with Ruby, PHP, or any existing database web applicatoins.
You can easily index, re-index, incremental-index. It's also highly scalable and easily customizable.
The best thing is, it's super easy. You can create a production-level search in 3 minutes.
|
|
| |
