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

问题描述

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

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

谢谢。

解决方案

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

或

• H2
  
  

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

  
  
  

  H2的开发人员做了一个很好的性能评估：
  
  http://www.h2database.com/html/performance.html

  
  

  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.

  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).

  Thank you.

  解决方案

  Either

  • 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.

  or

  • 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.

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

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