有什么理由不应该在生产中使用 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屋！