在 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屋！