有什么原因不应该在生产中使用h2数据库? [英] Are there any reasons why h2 database shouldn't be used in production?

问题描述

我最近正在考虑开发一个使用h2数据库作为其主要数据库的应用程序(因为它是JBoss附带的)，但是我对此感到有些担心.我在一些地方(主要是讨论板)读到，在生产中不应使用h2.是否有特定原因?

I am recently considering making an application that uses h2 database as its main database (because it comes with JBoss), but I am bit worried about that. I have read in a few places (discussion boards mainly) that one should not use h2 in production. Are there specific reasons for that?

推荐答案

不使用H2(或HSQLDB或Derby)进行生产的主要原因是:

The main reasons not to use H2 (or HSQLDB, or Derby) for production are:

• 严重错误的可能性:与大"数据库相比，Oracle，IBM DB 2，MS SQL Server，MySQL，PostgreSQL，Java数据库相对较新，因此可能不那么稳定(有错误).请注意，这适用于所有较新的产品，包括NoSQL数据库和大"数据库的新发行版.通常，测试的产品越多，发生错误的可能性就越小.当然，这取决于您的使用案例是否有必要为此优势支付费用(可能很多钱).在任何情况下，例如在硬件故障的情况下，您都需要备份数据.

• Probability of critical bugs: compared to the 'big' databases Oracle, IBM DB 2, MS SQL Server, MySQL, PostgreSQL, the Java databases are relatively new and therefore possibly not as stable (have bugs). Please note this is true for all newer products, including NoSQL databases, and new releases of the 'big' databases. Generally, the more a product is tested, the less the probability of bugs. Of course it depends on your use case whether it makes sense to pay (possibly a lot of money) for this advantage. In any case you will need to backup the data, in case of hardware failure for example.

缺少功能和优化功能:大"数据库针对特殊用例具有更多功能和优化功能.是否需要这些功能取决于您.

Missing features and optimizations: the 'big' databases have more features and optimizations for special use cases. Whether or not you need those features is up to you.

商业支持:更容易获得对更大数据库的支持.请注意， H2也可提供商业支持. HSQLDB还提供了商业支持. IBM曾经为Apache Derby(当然是IBM Cloudscape)提供支持，但我相信它们已经停止了.

Commercial support: it's easier to get support for bigger databases. Please note commercial support is available for H2 as well. HSQLDB also provides commercial support. IBM used to provide support for Apache Derby (well, IBM Cloudscape), but I believe they stopped.

这篇关于有什么原因不应该在生产中使用h2数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！