• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

full text with JSF and Mysql

 
fabio alonso
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Folks,

I need to implement a full text search.

Searching for the GUJ right here, seen as alternatives: hibernate search, lucene, the actual mysql 5.6 (although still in testing, this version supports Norva on InnoDB fulltext)

But there is no conclusion reached. My reality is, JSP, MySQL, JSF

Do you have any suggestions for reading, or something similar article covering this my reality? so I can understand ..

Thankfully
 
Tim Holloway
Saloon Keeper
Posts: 18300
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Lucene is probably the most popular full-text indexing and search system in the Java universe. We use it on the JavaRanch.

Hibernate Search uses the Lucene engine. I've used it with the PostgreSQL database as part of a JPA-architecture webapp.

There's really nothing JSF-specific about any of these search components, though.
 
Brendan Healey
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
One strategy I've seen mentioned is that you can run InnoDB & MyIsam in some sort of a parallel setup, just
storing the ids & data you need to search on in MyIsam. Very interesting to hear that they've got something
going into 5.6 for InnoDB, it sounds like waiting a bit is going to be easiest. There's also a product called
Sphinx that gets mentioned alongside Lucene for this sort of thing.

Regards,
Brendan.
 
fabio alonso
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Brendan Healey wrote:One strategy I've seen mentioned is that you can run InnoDB & MyIsam in some sort of a parallel setup, just
storing the ids & data you need to search on in MyIsam. Very interesting to hear that they've got something
going into 5.6 for InnoDB, it sounds like waiting a bit is going to be easiest. There's also a product called
Sphinx that gets mentioned alongside Lucene for this sort of thing.

Regards,
Brendan.


So.

In fact, accepts full text mysql 5.6 innodb tables .. but is still in beta testing

Regards,
Juliano
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic