Skip to main content

Posts

Showing posts from February, 2019

Is H2 database reliable?

An obvious answer to this question is 'Yes'. The reason is H2 has still continued outperforming. As of 2021, H2 is a superb database. We use it in all of our standalone applications since 4 years and we see it minimizes a gap between SQLite and MySQL. It performs as fast as or faster than MySQL. Where H2 is suitable?     Standalone applications     Intranet/LAN applications     Java specific deployments     Embedded as well as Server Mode Why is it better than SQLite?     More data types than SQLite.     Boolean datatype support. Which is not available in SQLite.     SQLite performance went down in a specific case when number of rows increases above 50,000 for around 15 column table (more or less). We did not find that issue with H2. It kept performing as usual.     Even if it appears like single file similar to SQLite, H2 is encrypted. It ...