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

问题描述

我打算开发一个小型 (Java) 应用程序来管理我的财务.我相信我需要使用嵌入式数据库，但我对这个问题没有经验.我试图查看一些可用的产品，但我无法决定哪个更适合我.H2、HSQLDB、德比 和 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 使用，经过测试且稳定.它很容易使用.如果要编辑数据库数据，只需打开文件并编辑插入语句即可.

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