Java嵌入式数据库比较 [英] Java Embedded Databases Comparison

问题描述

我打算开发一个小型（Java）应用程序来管理我的财务。我相信我需要使用嵌入式数据库，但我没有这方面的经验。我尝试查看一些可用的产品，但我无法决定哪一个会更适合我。 H2 ， HSQLDB ， Derby 和 Berkeley DB 似乎是很好的候选人，但我仍然看不到他们如何相互比较。

I intend to develop a small (Java) application for managing my finances. I believe I need to use an embedded database, but I have no experience regarding this issue. I tried to look at some of the available products, but I can't decide which one would be more suitable for me. H2, HSQLDB, Derby and Berkeley DB seem to be good candidates, but I still don't see how they compare to each other. I appreciate your help comparing them and helping me decide which one to use.

我打算对我的应用程序使用Hibernate（除非你推荐使用DBMS提供的API）但我还希望能够使用SQL浏览工具（修改模式和更改数据）轻松地编辑数据库。

I intend to use Hibernate for my application (unless you would recommend using DBMS-provided API), but I also want to have the ability to edit the database easily using a SQL browsing tool (modifying schema and changing data).

谢谢。

推荐答案

• HSQLDB - 由OpenOffice使用，测试和稳定。它很容易使用。如果要编辑数据库数据，您只需打开该文件并编辑insert语句。

• HSQLDB - Used by OpenOffice, tested and stable. It's easy to use. If you want to edit your db-data, you can just open the file and edit the insert statements.

或

• H2 - 说的更快（由开发人员，最初设计hsqldb也是）

• H2 - Said to be faster (by the developer, who originally designed hsqldb, too)

你使用哪一个取决于你，取决于您需要多少性能和稳定性。

Which one you use is up to you, depending how much performance and how much stability you need.

H2的开发人员做了一个很好的性能评估：

http://www.h2database.com/html/performance.html

The developer of H2 has put up a nice performance evaluation:
http://www.h2database.com/html/performance.html

这篇关于Java嵌入式数据库比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！