全文搜索和Python [英] Full text searching and Python

问题描述

有人可以帮我解决一些支持Python的全文搜索引擎的建议吗？

现在我们有一个MySQL数据库，我想添加一个全文搜索引擎索引某些文本的能力这个数据库中的表。该文本数据将被Web应用程序用于在数据库中搜索相应的记录。例如，在客户表中索引客户姓名信息，使用Web应用程序进行全文搜索以获取客户的MySQL记录。

我在Lucene，Swish-E和MongoDB以及其他几家公司看过（简要），但我不确定对我来说考虑什么是一个不错的选择几件事情：

• 我不是一个Java人（尽管我已经编程了很长时间），


• 我们只想搜索相对较小的一组数据，我们正在寻找MySQL数据库中的文本索引，


• 并希望该索引能够以半实时方式更新。

任何提示，提示或指针都将不胜感激！ nofollow的>嗖。我听说它不能很好地扩展（可能现在已经修复了），但对于小集合，它可能会有用。

对于可扩展的解决方案，请考虑使用具有 PyLucene 或Jython的Lucene。

Can someone help me out with some suggestion for a full-text searching engine that supports Python?

Right now we have a MySQL database in place and I'd like to add the ability to have a full-text search engine index some of the text in some of the tables in this database. This text data would be used by a web application to search for the corresponding records in the database. For instance, index the customer name information in our customer table, full text search that with the web application to get the MySQL record for the customer.

I've looked (briefly) at Lucene, Swish-E and MongoDB, and few others, but I'm not sure what would be a good choice for me considering a couple of things:

• I'm not a Java guy (though I've been programming for a long time),
• we only want to search a relatively small set of data,
• we're looking to index text in a MySQL database,
• and would like that index to be updated in semi-realtime.

Any hints, tips or pointers would be greatly appreciated!

解决方案

Have a look at Whoosh. I've heard it doesn't scale up terribly well (maybe that's fixed now) but for small collections, it might be useful.

For a scalable solution, consider using Lucene with PyLucene or Jython.

这篇关于全文搜索和Python的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！