What's the best approach for creating an embedded Postgresql to be used in production?

• otj-pg-embedded

  6 665 6.4 Java

  Java embedded PostgreSQL component for testing

  

The DB is not usually huge and shouldn't scale, so we thought it's fine to use an embedded DB. Since we're already using Postgresql it makes sense to use Postgres as the embedded DB, but I noticed Spring boot doesn't seem to support it like H2, after searching further online I've found a repo https://github.com/opentable/otj-pg-embedded that uses docket containers approach to "embedd" the db to our java code.

• sqlite-jdbc

  21 2,682 9.1 Java

  SQLite JDBC Driver

There is https://github.com/xerial/sqlite-jdbc, a full packaged sql lite for Java. We use it in production apps to store local user profile data. It works, is stable.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project