blocks|key|1238526|text|我已经在SQLite+(通过DISQLite3)在FeedDemon中使用了几个月了，我强烈推荐它--它非常快速和稳定。正如哈维尔所说，库的文档可能很薄，但是SQLite本身的文档非常好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1238527|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I've been using SQLite (via DISQLite3) in FeedDemon for several months, and I highly recommend it - it has been extremely fast and stable. As Javier said, the docs for the library may be thin, but the docs for SQLite itself are very good.

blocks|key|239148|text|我使用Firebird+2.1+Embedded，我对它非常满意，我喜欢这样的事实:数据库的大小实际上是无限的(使用>4+GB的数据库进行测试，并且可以工作)，而且数据库文件与Firebird+Server兼容，因此我可以使用标准工具进行数据库管理和检查。发行版包括删除exe文件夹中的几个文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239149|不支持来自多个程序的同时访问，但来自多个线程的同时访问是支持的(只要您确保在任何给定时刻只有一个“连接”操作正在进行)。|239150|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I'm using Firebird 2.1 Embedded and I'm quite happy with it.I like the fact that the database size is practically unlimited (tested with > 4 GB databases and it works) and that the database file is compatible with the Firebird Server so I can use standard tools for database management and inspection. Distribution consists of dropping few files in your exe folder.

Simultaneous access from multiple programs is not supported but simultaneous access from multiple threads is (as long as you ensure that only one 'connect' operation is in progress at any given moment).

blocks|key|881703|text|我在很多项目中都使用了SQlite3+(但是来自C/C%2B%2B和Objective)。它非常小--没有任何依赖--数据库在一个文件中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|881704|它是Mac开发人员的首选数据库，因为它是由CoreData和iPhone直接支持的--因此有一个庞大的用户群(更不用说所有其他用户了)。|881705|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I have used SQlite3 for a lot of projects (but from C/C++ and Objective-C). It's extremely small -- no dependencies whatsoever -- database is in a single file.

It's the db of choice for Mac developers because it's directly supported by CoreData and on the iPhone -- so there is a big user base (not to mention all of the other users).

blocks|key|239246|text|我在许多项目中都使用了DBISAM。它是完全嵌入的，甚至不需要外部DLL。与你列出的其他人不同，它是商业性的。但是，有很多很棒的特性，并且有很好的文档和支持。它有一个接班人，但我还没有试过。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|239247|entityMap|0|LINK|mutability|MUTABLE|url|http://www.elevatesoftware.com/|1^0|B|6|0|2B|3|1|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@$A|N|B|O|1|P]|$A|Q|B|R|1|S]]|C|$]]|$1|D|3|-4|5|6|7|T|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|K]]]]

I've used <a href="http://www.elevatesoftware.com/" rel="noreferrer">DBISAM</a> on a number of projects. It is completely embedded without even a need for an external DLL. Unlike the others you listed it is commercial. A lot of great features though and very well documented and supported. The have a <a href="http://www.elevatesoftware.com/" rel="noreferrer">successor</a> to it that I haven't tried yet though.

blocks|key|882035|text|让我们看看，快速比较：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|882036|SQLite：|882037|数据库中的动态键入|unordered-list-item|882038|跨平台文件|882039|运行在Windows、Linux、Mac等操作系统上。|882040|公共领域|882041|支持事务|882042|依赖文件系统安全，不包括自己的安全性。|882043|嵌入火鸟：|882044|在数据库中进行强键入|882045|并非所有SQL数据类型都受支持。|882046|882047|​|882048|882049|只在Windows上运行Firebird嵌入式|882050|内嵌的Firebird文件的格式与服务器的完整版本相同。|882051|可以将嵌入Firebird的文件复制到非Windows服务器以供使用|882052|882053|882054|可以在修改后的MPL中获得(“我们的东西是我们的，必须保持自由，你的东西是你的，你不需要释放它”)|882055|支持事务、触发器等。|882056|嵌入式MySQL：|882057|对SQL特性的支持取决于文件格式。|882058|(IIRC)跨平台文件|882059|GPL除非你支付版税|882060|运行在Windows，Linux，Mac上|882061|在开源人群中非常受欢迎|882062|即使是嵌入式数据库也有其优点和弱点。你将需要权衡这些优点和弱点与你所做的决定。|882063|entityMap^0|0|0|0|0|0|0|0|0|0|1|1|0|0|1|1|1|1|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1U|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|1V|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|1W|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1X|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|1Y|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1Z|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|20|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|21|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|22|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|23|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|24|8|@]|9|@]|A|$]]|$1|Z|3|H|5|F|7|25|8|@]|9|@]|A|$]]|$1|10|3|11|5|F|7|26|8|@]|9|@]|A|$]]|$1|12|3|13|5|F|7|27|8|@]|9|@]|A|$]]|$1|14|3|15|5|F|7|28|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|29|8|@]|9|@]|A|$]]|$1|17|3|Y|5|6|7|2A|8|@]|9|@]|A|$]]|$1|18|3|19|5|F|7|2B|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|F|7|2C|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|2D|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|F|7|2E|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|F|7|2F|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|F|7|2G|8|@]|9|@]|A|$]]|$1|1K|3|1L|5|F|7|2H|8|@]|9|@]|A|$]]|$1|1M|3|1N|5|F|7|2I|8|@]|9|@]|A|$]]|$1|1O|3|1P|5|6|7|2J|8|@]|9|@]|A|$]]|$1|1Q|3|-4|5|6|7|2K|8|@]|9|@]|A|$]]]|1R|$]]

Let's see, quick comparison:

SQLite:

<ul>
<li>dynamic typing in the database</li>
<li>cross-platform files</li>
<li>runs on Windows, Linux, Mac, etc.</li>
<li>public domain</li>
<li>supports transactions</li>
<li>relies on file system security, does not include own security</li>
</ul>

Firebird embedded:

<ul>
<li>strong typing in the database

<ul>
<li>not all SQL datatypes are supported</li>
</ul></li>
<li>cross-platform files

<ul>
<li>Firebird embedded only runs on Windows</li>
<li>Files from Firebird embedded are in the same format as the full server version</li>
<li>Files from Firebird embedded can be copied to a non-Windows server for use</li>
</ul></li>
<li>available under a modified MPL ("what's ours is ours and must remain free, what's yours is yours and you don't have to release it")</li>
<li>supports transactions, triggers, etc.</li>
</ul>

MySQL embedded:

<ul>
<li>support for SQL features depends on file format</li>
<li>(IIRC) cross-platform files</li>
<li>GPL unless you pay royalties</li>
<li>runs on Windows, Linux, Mac</li>
<li>incredibly popular with the open source crowd</li>
</ul>

Even embedded databases have their strengths and weaknesses. You'll need to weigh those strengths and weaknesses against what you're doing to decide.

blocks|key|886290|text|Firebird+embedded是我们的第一选择，因为没有代码更改，带有嵌入式数据库的单个用户Delphi应用程序可以迁移到基于多用户服务器的部署中，而不会牺牲任何高端功能(如存储过程、触发器、视图等)。而且它是一个真正的免费数据库，在这个过程中并不会对您的代码进行GPL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|886291|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Firebird embedded is our #1 choice because with no code changes, a single user Delphi app with embedded database can be migrated to a multi-user server based deployment without sacrificing any of the high end features (such as stored procedures, triggers, views, etc.). And its a TRUE free database and doesn't GPL your code in the process.

blocks|key|239864|text|强烈建议在使用数据库和Delphi时使用AnyDAC+--然后您可以选择无缝地针对FB或SQLite。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239865|我更喜欢FB的嵌入式应用程序。汤姆|239866|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Strongly recommend to use AnyDAC when working with Databases and Delphi - then you can choose to target FB or SQLite seamlessingly.

My preference would be for FB for embedded apps.
Tom

blocks|key|239357|text|我使用Sybase的，但我也是研发管理人员，所以这篇文章是有偏见的。:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239358|我们有本地的Delphi、TTable和TQuery组件，用于WIN32、VCL和VCL.NET。除了对WIN32的支持之外，直接表访问还使它在许多其他WIN32产品中独树一帜。Advantage支持大型表(仅受记录数量的限制，20亿)，并且有一个免费的本地引擎，这对于开发PC和不需要客户机/服务器功能的小客户端站点来说是很好的。切换到具有单个连接属性的客户端/服务器，没有其他更改。|239359|我们有大量的客户端，因此访问Delphi之外的数据也非常容易(.NET数据提供程序、ODBC、OLE+DB、PHP、Perl、JDBC等)。|239360|主要产品网站：http://www.advantagedatabase.com+Developer网站：http://devzone.advantagedatabase.com|offset|length|239361|entityMap|0|LINK|mutability|MUTABLE|url|http://www.advantagedatabase.com/|1|http://devzone.advantagedatabase.com/^0|0|0|0|7|W|0|1G|10|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$H|X|I|Y|1|Z]|$H|10|I|11|1|12]]|A|$]]|$1|J|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]]]

I use Sybase's Advantage Database Server, but I'm also the R&amp;D Manager, so this post is biased. :)

We have native Delphi TTable and TQuery components for both WIN32 VCL and VCL.NET. Direct table access in addition to SQL support makes Advantage unique among many of the other Delphi offerings. Advantage supports large tables (only limited by the number of records, 2 billion) and has a free local engine, which is nice for development PCs and for small customer sites that don't require client/server functionality. Switch to client/server with a single connection property, no other changes.

We have a ton of clients so accessing the data outside of Delphi is also very easy (.NET data provider, ODBC, OLE DB, PHP, Perl, JDBC, etc).

Main Product Web Site: <a href="http://www.advantagedatabase.com" rel="noreferrer">http://www.advantagedatabase.com</a>
Developer's Web Site: <a href="http://devzone.advantagedatabase.com" rel="noreferrer">http://devzone.advantagedatabase.com</a>

blocks|key|239702|text|这真的取决于你需要什么。对于单用户应用程序，火鸟嵌入式或SQLite可能是最好的选择(价格是正确的)。另一方面，如果您需要支持大量的多个用户，您可能应该使用普通Firebird而不是嵌入式版本(服务器安装简单，所以这里不会有太多问题)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239703|如果你需要中间的一些东西，对于一个温和的多用户应用程序来说，一个扁平的数据库会更好。我发现组件Absolute绝对数据库比DBISAM、NexusDB或VistaDB更适合我的需求。|offset|length|239704|它的占用空间相对较小(没有DLL)，它是一个单一文件数据库(对我来说是必须的)，支持Unicode、BLOB压缩、加密，而技术限制似乎给平面数据库留下了深刻印象。此外，在我需要支持的时候，也有几次支持是好的。|239705|对于缺点，我注意到它不支持嵌套事务，但除此之外，我没有问题。|239706|entityMap|0|LINK|mutability|MUTABLE|url|http://componentace.com/absolute_database_features.htm^0|0|19|F|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

It really depends what you need. For single-user applications, Firebird Embedded or SQLite are probably best choices (and price is right). On the other end, if you need support for large number of multiple users, you should probably use regular Firebird instead of Embedded version (server is simple to install so you won't have much problems here).

And if you need something in between, for a moderate multi-user application, one of flat databases would be better. I found that <a href="http://componentace.com/absolute_database_features.htm" rel="noreferrer">ComponentAce's Absolute Database</a> better choice for my needs than DBISAM, NexusDB or VistaDB.

It leaves relatively small footprint (no DLLs), it's a single-file db (a must for me), supports Unicode, BLOB compression, crypting, and technical limits seem impressing for a flat database. Moreover, support was good in few occasions when I needed it.

For cons, I have noticed it doesn't support nested transactions, but other than that, I had no problems.

blocks|key|886335|text|至于尺寸，没有比SQLite更好的了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|886336|当您提到缺乏文档时，我想这是DISQLite3的文档。SQLite文档是相当完整的|offset|length|886337|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlite.org/^0|0|R|8|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

As for size, nothing beats SQLite.

when you refer about lack of documentation, i guess it's doc for DISQLite3. The <a href="http://www.sqlite.org" rel="nofollow noreferrer">SQLite docs</a> are quite complete

blocks|key|239382|text|(嵌入式)+firebird的问题是，数据库不能驻留在网络驱动器上。此外，在只读驱动器(CD/DVD)上很难有一个数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239383|有关这些限制的一些黑客，请参阅Delphi：贴士|offset|length|239384|entityMap|0|LINK|mutability|MUTABLE|url|http://delphi.wikia.com/wiki/Firebird_tipps^0|0|M|2|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

The problem with (embedded) firebird is, that the database cannot reside on a network drive. Also, it is difficult to have a database on a read only drive (CD/DVD).

For some hacks around these limitations see the Delphi Wiki:
<a href="http://delphi.wikia.com/wiki/Firebird_tipps" rel="nofollow noreferrer">http://delphi.wikia.com/wiki/Firebird_tipps</a>

blocks|key|881887|text|看看NexusDB。在过去已经非常成功地使用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|881888|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Take a look at NexusDB. Have used very successfully in the past.

blocks|key|239539|text|NexusDB提供了从嵌入式到完全客户机/服务器/远程的全方位功能。我相信SQL2003也是兼容的。我在一些项目中使用它，到目前为止我非常高兴，而且它可以在如此广泛的“规模”中工作，这是一个很大的好处(不需要为扩展的应用程序学习另一个DB，等等)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239540|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

NexusDB offers the full range from embedded, to full client/server / remote. Also SQL2003 compliant, I believe. I'm using it on a few projects, and am very pleased so far, and the fact that it can work in such a wide range of "scales" is a big plus (not having to learn another DB for scaled-up apps, etc).

blocks|key|239923|text|看看这个嵌入式数据库的比较：http://sql-db.cz.cc/，它可能会有帮助。以上产品主要有:+Advantage、DBISAM、Firebird、more，还有Accuracer、A波罗、ElevateDB、NexusDB、TurboDB等。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|239924|entityMap|0|LINK|mutability|MUTABLE|url|http://sql-db.cz.cc/^0|E|K|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Look at this embedded database comparison: <a href="http://sql-db.cz.cc/" rel="nofollow">http://sql-db.cz.cc/</a>, it can be helpful. Most of abovementioned products are presented there: Advantage, DBISAM, Firebird, MS SQL Server, and much more: Accuracer, Apollo, ElevateDB, NexusDB, TurboDB.

blocks|key|1238468|text|我倾向于组件Ace的绝对DB。虽然它是一种商业产品($)，但它是坚固的，易于使用，占用空间小，而且有很好的文档记录。如果您正在寻找一个庞大的多用户应用程序，这不是一条路可走，但如果您的多用户需求是轻(或不存在)，这是一个坚实的选择。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1238469|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I am partial to Component Ace's Absolute DB. Although a commercial product ($), it is solid, easy to use, small footprint and well documented. If you are looking for a huge multi-user application, this is not the way to go, but if your multi-user needs are light (or non-existent) this is a solid option.

blocks|key|1238564|text|我正在使用和ADO组件。效果很好。您可以使用命令行运行Server安装，以向用户隐藏复杂性。还可以通过文件名分发加载的数据库。有数以百万计的SQL服务器用户，因此任何问题的解决方案都很容易在内部找到：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1238565|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I'm using SQL Server Express and the ADO components. Works great. You can run the SQL Server Express install with commandline to hide the complexities from the users. You can also distribute a database that you load by filename. There are millions of SQL server users so solutions to any problems are easily found in the intertubes :-)

blocks|key|1238639|text|我做了一个网络搜索，为我的Delphi应用程序找到一个快速的数据库包。我希望它完全包含在可执行文件中，不需要外部DLL或库。我最初是通过AidAim找到Accuracer的。他们发布了他们的数据库有多快，甚至进行了比较和其他类似的软件包，以“证明”他们的观点。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1238640|我想要相信他们的说法，但我想我应该搜索更多的网页，以找到其他软件包的时间。我很惊讶地发现，在特尔斐论坛上的帖子中，有人问要使用哪个数据库，其中有14种不同的建议。其中一个响应者已经做了他自己的时间比较，并发现Accuracer与其他几个比较页面相比相当慢，而Accuracer+(方便地)没有在他们自己的比较页面中。|1238641|这篇文章，再加上我的后续网络研究，让我倾向于DISQLite3，这是一种基于开源SQLite程序的产品，但增强了在Delphi中的工作速度，开销非常小，并且使用了基于命令的调用--这我很喜欢。它正在积极开发，不久将有一个正式的Delphi2009版本，尽管目前的版本显然将在D2009下工作。|1238642|Addenum:+DISQLite3版本2.0.0，发布于11月17日，支持D2009。|1238643|entityMap|0|LINK|mutability|MUTABLE|url|http://www.accuracer.com/articles/single-file-delphi-database_tests100.php|1|http://coding.derkeiler.com/Archive/Delphi/borland.public.delphi.thirdpartytools.general/2007-01/msg00231.html|2|http://www.yunqa.de/delphi/doku.php/products/sqlite3/index|3|http://www.sqlite.org/^0|2K|H|0|0|1A|9|1|0|M|9|2|12|A|3|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]|$A|19|B|1A|1|1B]]|C|$]]|$1|H|3|I|5|6|7|1C|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]|R|$5|M|N|O|C|$P|S]]|T|$5|M|N|O|C|$P|U]]|V|$5|M|N|O|C|$P|W]]]]

I did a websearch to find a fast database package for my Delphi Application. I wanted it to be completely contained in the executable with no external DLLs or libraries required. I originally found Accuracer by AidAim. They had posted <a href="http://www.accuracer.com/articles/single-file-delphi-database_tests100.php" rel="nofollow noreferrer">how fast their database was and even gave comparisons</a> with other similar packages to “prove” their point.

I wanted to believe their claims but I thought I’d search the web a bit more to find timings of other packages. I was very surprised to find <a href="http://coding.derkeiler.com/Archive/Delphi/borland.public.delphi.thirdpartytools.general/2007-01/msg00231.html" rel="nofollow noreferrer">a post at the Delphi discussion forums</a> where a person asked what database to use, and there were 14 different suggestions. One of the responders had done his own timing comparisons and had found Accuracer to be quite slow compared to several others, which Accuracer had (conveniently) left out of their own comparison page. 

The post, plus additional followup web research by me, led me to lean toward <a href="http://www.yunqa.de/delphi/doku.php/products/sqlite3/index" rel="nofollow noreferrer">DISQLite3</a>, a product based on <a href="http://www.sqlite.org/" rel="nofollow noreferrer">the Open Source SQLite program</a>, but with enhancements to work in Delphi very quickly, with very small overhead, and with command-based calls - which I like. It is actively under development and will soon have an official Delphi 2009 version, although apparently the current version will work under D2009.

Addenum: DISQLite3 Version 2.0.0, released Nov 17, supports D2009.

blocks|key|882158|text|我知道may是一个比较糟糕的数据库(希望在这里被击落)，但是如果只需要少量的数据，不管怎么说，如果使用MS+office，它可能会有优势。对我来说，这是一种比csv文件更灵活地存储程序数据的方法，这是科学代码的一种常见方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|882159|您可以通过delphi代码创建access+db，而无需使用ado+&+odbc驱动程序安装ms+office+(可能需要有一个初始的.accdb文件而不需要从那时起复制表，我不记得这个细节了。不确定许可情况会这样做。|882160|可以将.accdb扩展名更改为其他内容&文件密码受到保护(在一定程度上)，因此如果需要的话，它对用户的访问不会立即变得明显。我知道一些商业开发人员做这个方法，并自己复制它。发现它更容易设置比sqlite，但可能是因为我已经使用ado+&+access在过去。|882161|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I know MS access is a comparatively crap db (and expect to be shot down in flames here), but if only small data is needed it may have advantages if ms office is used anyway. For me it was a way to store program data with more flexibility than csv files which is a common approach for scientific code.

You can create an access db from delphi code without having ms office installed using ado &amp; odbc driver (might be necesary to have an initial .accdb file without tables to copy from then populate, I can't remember this detail. not sure licensing situation doing this. 

The .accdb extension can be changed to something else &amp; the file password protected (to a limited degree) so its not immediately obvious to users its access if that's desired. 
I know a few commercial developers do this method &amp; copied it myself. Found it easier to setup than sqlite, but maybe because I'd already used ado &amp; access in the past.

blocks|key|239232|text|我用过ScimoreDB。它有它的怪癖，因为他们给予它免费的版税，它有它在数据类型和一些安装问题上的怪癖。这是在C#项目上进行的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239233|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I have used ScimoreDB. It has its quirks as they give it royalty free and it has its quirks in data types and with some installation issues. This was on a C# project.

blocks|key|239536|text|如果嵌入式是绝对必须的，请看DBISAM。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239537|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If embedded is an absolute must, look at DBISAM.

blocks|key|1238712|text|kbMemTable是一个很好的候选人。在内存中运行，速度快，多线程。曾经是自由的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1238713|Components4Developers|offset|length|1238714|entityMap|0|LINK|mutability|MUTABLE|url|http://www.components4developers.com/^0|0|0|L|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

kbMemTable is a good candidate. Runs in memory, fast, multi-threadding. Used to be free.

<a href="http://www.components4developers.com/" rel="nofollow noreferrer">Components4Developers</a>

blocks|key|886468|text|我在不同的场合使用过DBISAM和kbMemTable。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|886469|我喜欢DBISAM的地方是它有很好的特性，而且通常非常可靠。我在大型数据库、全文搜索、只读模式、CGI和许多其他情况下都使用过它.|886470|不过，与基于kbMemTable或SQLite的组件相比，它相当大。而且每个数据库都不能有一个文件(甚至是表)--取决于情况，这是一个主要的缺点。|886471|kbMemTable是很小的，对于少量的数据是很好的。当然，因为它在内存中运行，所以它必须是少量的数据。|886472|我在几个桌面应用程序上采取的另一个选择是使用TWriter/TReader将数据直接从/转到对象层次结构。到目前为止，这是最小的选项，而且与使用数据库相比速度快得离谱。数据文件也很小。|886473|但是，它有各种各样的缺点--如果您想要添加/更改字段，就必须编写版本控制代码，除非是内存中的字段--它甚至更复杂，根本不支持多用户，等等。|886474|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

I have used DBISAM and kbMemTable on different occasions.

What I like about DBISAM is that it has great features, and is usually very reliable. I have used it in large databases, full-text search, read-only mode, CGIs and many other situations. 

It is fairly large compared to kbMemTable or SQLite based components, though. And you can't have a single file per database (or even table) - depending on the situation, that is a major disadvantage.

kbMemTable is tiny and it's great for small amounts of data. Since it runs in memory, it has to be a small amount of data, of course.

One other option I've taken on a couple of my desktop apps is dumping the data directly from/to my object hierarchy using TWriter/TReader. This is by far that smallest option, and is absurdly fast compared to using a database. The data files are tiny, too.

It has all kinds of drawbacks, though - you have to code versioning in if you might want to ever add/change fields, unless it's in-memory it is even more complicated, no multi-user support at all, etc.

blocks|key|1238867|text|火鸟嵌入也是我们的第一选择。以及与之配套的统一Interbase+v2.0套件。一个伟大而稳定的解决方案！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1238868|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Firebird embedded is our #1 choice as well. And the suite Unified Interbase v2.0 with it. A great and stable solution!

blocks|key|240029|text|我有一个数据库，我必须在10天内每20秒记录5个字段数据。3字段为整数，1字段为双(时间)，1字段为string5。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|240030|由于我的组件，我仍然在使用Delphi6+srv2。较新的delphi版本在组件上非常糟糕，我不得不花费数千美元来重建组件库。因此，delphi+6仍然是最好的实际商业应用程序，从来没有版本的德尔菲提出了许多问题。在许多方面，如USB或comport读数等.在以前的版本从未上市之前，他们就发布了更新版本。|240031|我已经用Delphi6设置了一个代码，它在一个表中附加了43200条记录以供测试，因为我将在应用程序中部署该表，而它有43200条记录。我将在DBChart上显示所有数据。|240032|测试结果在下面的数据库中，通过插入命令填充包含43200条记录的表。|240033|Dbisam+=34秒，
ElevateDb+=11秒，
AbsoluteDB+=45秒，
SQLlite+=+32分钟，
火鸟=+12分钟，
MSSQL12+localDB+=+28分钟
简易桌=8分钟，
BDE+=阻塞，|blockquote|240034|我没有测试过甲骨文，黑鱼，sysbase，nexsusDb等。但他们似乎也会很慢。我已经连接到DBChart，只有elevateDb和absoluteDB在可例外的时间内在DBchart上加载了43200条记录，比如7~10秒。其他都花了几分钟。因此，速度较慢的数据库总是需要编程技巧才能在一些实际工作中取得成功。|240035|我还测试了他们的搜索速度，通过查找命令，不幸的是，基于服务器的数据库总是速度较慢。|240036|MSSQL和SQLLite3很难管理到德尔菲，这让我很累。|240037|这是我的测试结果|240038|最后，我决定使用AbsoluteDB、Dbisam和Dbisam。我把剩下的都扔出电脑了。|240039|升级软件不支持在运行时需要额外代码来管理的recno功能。这使得数据库速度变慢，其他的错误是与电梯软件是自动字段。没有办法重设它。因此，我没有选择的电梯软件，即使它是最快的数据库。他们说了很多好的功能，但实际上我们使用了多少功能。他们只留下了最重要的函数不受支持，但修复了许多不必要的功能。而且，自8年以来，似乎也没有任何优势。|240040|如果你想用自己的眼睛看，请试着看..。|240041|我在考虑两个绝对DB或DBisam4|240042|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|16|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|17|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|18|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|19|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1A|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1B|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1C|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1D|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1E|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|11|$]]

I have a database that I have to record 5 field data for every 20 sec for 10 days.. 3 field are integer , 1 field is double ( time ) and 1 field is string[5]. 

I am still using Delphi6 srv2 because of my components. Newer delphi versions are terrible at components that I have to spend thousands of dollars of money to rebuild my component library. Therefor delphi 6 is still best for real commertial applications that never version of delphis give many problems. At many points such as USB or comport readings so on... they release newer ones before previous versions never sit on market. 

I have setup a code with Delphi6 what appends 43200 records at a table for test because I will deploy the table in application while it has 43200 records. I will shown all the data on DBChart. 

Test result is below databases filled the tables by insert command with 43200 records

<blockquote>
 Dbisam = 34 sec, 
 ElevateDb = 11 sec, 
 AbsoluteDB = 45 sec, 
 SQLlite = 32 Minute, 
 Firebird = 12 min, 
 MSSQL12 localDB = 28 Minute, 
 Easy table = 8 minute, 
 BDE = Blocked ,
</blockquote>

I havent tested oracle , blackfish , sysbase, nexsusDb etc.. but it seems they will also very slow. I have connected with DBChart and only elevateDb and absoluteDB has loaded 43200 records on DBchart in exceptable time such as 7~10 secs. Other all taken minutes. So slower databases always needs coding tricks to succeed in some real jobs.. 

I have tested their search speed as well by locate command that unfortunatly the server based databases are always slower in. 

MSSQL and SQLLite3 are extremely difficult to manage in to delphi that they made me very tired. 

These are my test results 
At the end I decided to use AbsoluteDB, Dbisam and Elevate. I have thrown the rest off the PC .

Elevate software doesnt support recno function that requires extra codes at runtime to manage. This makes the database slower Other bug is with Elevate software is autoinc fields. There is no way to reset it . Therefore I have not chosen the Elevat software even it is the fastest database. They say many good functions but how many of them we use it in fact . They just left the most important functions not supported but fixed many many unnecessary functions. and it seems since 8 years there is no any advantage either. 

If you want to see with your own eye pls just try and see.. 

I am thinking between two now absolute DB or DBisam4

blocks|key|1238885|text|火鸟一路走来。一切都做得很好，到目前为止，2.1版本非常可靠。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1238886|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Firebird all the way. Does pretty well everything and so far version 2.1 is very solid.

blocks|key|239767|text|FireBird提供了扩展到多用户的机会，如果您需要并发(如果您的应用程序是多线程的)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239768|SQLite是无可比拟的，如果您只需要单用户访问，没有其他数据库接近它在任何方面，无论是性能，方便，SQL支持或稳定性。|239769|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

FireBird offers the opportunity to scale up to multi-users sometime down the line, or if you need concurrency (if your application goes multi-threaded).

SQLite is quite unrivaled if you only need single-user access, no other database comes close to it on any aspect, be it performance, convenience, SQL support or stability.

blocks|key|886535|text|Firebird真的很棒，占用的空间也很小，所以您可以使用嵌入式，它可以为许多用户升级，unicode失败吗?我使用devart组件与delphi+2009和FIB+%2B为delphi+6/7+(他们的版本2009年和unicode还没有准备好太坏)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|886536|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Firebird is really awsome and has a small footprint so you can use embedded
and it can be scaled upward for many users
and does unicode faily well
I use devart components with delphi 2009
and FIB plus for delphi 6/7 (their version for 2009 and unicode is not ready yet too bad)

blocks|key|1238946|text|嗯，没有人推荐BDE+-我不知道这是为什么;-)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1238947|BlackFishSQL是另一种可能，尽管我还没有进行深入的测试。|1238948|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Hmmm, no one has recommended the BDE - I wonder why that is ;-)

BlackFishSQL is another possibility, although I haven't tested in depth as yet.

blocks|key|1239240|text|当涉及到嵌入式数据库时，第一个问题是:它是多用户吗？实际上，谁需要一个不允许多个连接(读和写)到它的数据库？我已经(强烈地)尝试了所有提到的数据库，并且只找到了一个真正以它应有的方式工作的数据库。那就是Accuracer。唯一的遗憾，准确的是，这是一个三人乐队和长期缺乏适当的支持。它在开发中也主要是静态的，因为我们在years.Not中没有看到真正的特性，因为只有一个人真正开发了它。看来他们是靠老名望生活的。用户的赞扬反映了这一点(通常是10年前的评论)。对于单一的用户体验，我建议绝对数据库。至于主要的玩家，我推荐微软的Server。甲骨文已经成为一个臃肿的软件，并且正在慢慢地消失。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1239241|ps在精确性上的好处是，它们的嵌入式数据库功能就像完善的服务器。当rest正常工作时，它只锁定当前记录。数据库不错。可惜，它是停滞的。|1239242|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

when it comes to embedded databases the first question is : is it multiuser ?
Actually,who needs a database that does not allow multiple connections (read&amp;write) to it ? 
I have tried (intensly) all mentioned databases and found only one that actually functions the way it should. And that is Accuracer.
The only pity with accuracer is that its a three man band and chronic lack of proper support. It also is mainly static in development as we have seen no real features in years.Not surprising since only one person actually develops it. It seems they are living on old fame. Users praise reflect that (usually 10 years old comments). 
For a single user experience I would recommend Absolute Database. 
As for major players I would recommend SQL Server from Microsoft. Oracle has become a bloatware and is slowly dying out. 

ps 
what is nice in accuracer is that their embedded database functions just like full blown server. It locks only current record if its in use while the rest functions normally. Nice database. Pity only it is stagnant.

I am creating a desktop app in Delphi and plan to use an embedded database. I've started the project using SQlite3 with the DISQLite3 library. It works but documentation seems a bit light. I recently found Firebird (yes I've been out of Windows for a while) and it seems to have some compelling features and support.

What are some pros and cons of each embedded db? Size is important as well as support and resources. What have you used and why?

Which embedded database to use in a Delphi application?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我正在创建一个桌面应用程序在Delphi和计划使用嵌入式数据库。我使用SQlite3和DISQLite3库启动了这个项目。它工作，但文档似乎有点轻。我最近发现了Firebird (是的，我已经离开Windows一段时间了)，它似乎有一些引人注目的特性和支持。每个嵌入式数据库的优缺点是什么？规模是重要的，支持和资源也很重要。你用了什么?为什么？

问在Delphi应用程序中使用哪个嵌入式数据库？
EN

回答 29

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Delphi应用程序中使用哪个嵌入式数据库？EN

回答 29

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Delphi应用程序中使用哪个嵌入式数据库？
EN