在Delphi中使用嵌入式数据库进行全文搜索 [英] Full text search with embedded DB in Delphi

问题描述

我们正在创建一个开源的 Twitter客户端 ，并且正在寻找具有最小足迹的嵌入式数据库，可与Delphi一起使用，并且可以很好地满足全文搜索（我知道， t去小脚印非常好）。理想情况下，它应该是免费的或开源的（要求我知道）。

We are creating an open source Twitter client and are looking for an embedded DB with the smallest footprint possible that works with Delphi and that lends itself well to full text search (I know that doesn't go with small footprint very well). Ideally it should be free or open source too (demanding I know).

我倾向于 SQLite ，但我以前没有使用过，不知道是否支持全文搜索，或者它与Delphi一起使用。我之前已经使用过 DBISAM ，然后嵌入全文搜索，但不是免费的。 Firebird 是我们考虑的另一种选择。

I am leaning toward SQLite, but I have not used it before and don't know if it supports full text search, or how well it works with Delphi. I've used DBISAM before and it is embedded with full text search, but not free. Firebird is another option we considered.

可能有一个组合，使这项工作。您将如何使用它，如何评价1）足迹，2）全文搜索，3）免费/开源。

There might be a combination that makes this work. What would you use, and how does it rate for 1) Footprint, 2) Full text search, 3) Free/Open source.

更新：感谢大家的建议。

UPDATE: Thanks to everyone for your suggestions. So many good choices to choose from.

推荐答案

我使用 DiSQLite 。它具有FTS支持和许多其他功能。他们有免费版和专业版。我相信免费版也是FTS。我试过很多Delphi的SQLite实现，这是我见过的最好的。它直接编译到应用程序中，因此没有外部DLL。

I've had a lot of success using DiSQLite. It has FTS support and a ton of other features. They have a Free version and a Professional version. I believe the Free version does FTS as well. I've tried many of the SQLite implementations for Delphi and this is the best one I've seen. It compiles straight into your application so there are no external DLLs.

我已经看了很多免费的库，在Delphi中嵌入式数据库，许多不再被支持，从来没有被发布，或者只在Delphi5中工作。

I've looked at a lot of the free libraries out there for embedded databases in Delphi and many are not supported anymore, never got released, or only work in Delphi5.

这篇关于在Delphi中使用嵌入式数据库进行全文搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！