What is the most important difference between H2 and PostgreSQL

During the software implementation, it is always difficult for us to decide which one of the database should we use as the technology stack. Especially for the database. So what is the mainly difference between H2 and PostgreSQL.
1 answer

The mainly difference, which help to decide the selecting decision for the software design is the embedded mode. H2 supports this kind of the mode while PostgreSQL doesn't support it. Further H2 is platform independent and mostly used for the small application and PostgreSQL only supports some kind of the OS.


There is detailed comparison and more features is provided, can be useful as well: System Properties Comparison H2 vs. PostgreSQL

Anastasiia Ulianova - Sun, 12/10/2017 - 00:20 :::