HolismHolding / Issues

1 stars 0 forks source link

Migrate to Postgress #192

Open Nefcanto opened 4 months ago

Nefcanto commented 4 months ago

Because it's the first open-source database:

https://db-engines.com/en/ranking

Nefcanto commented 4 months ago

https://www.statista.com/statistics/809750/worldwide-popularity-ranking-database-management-systems/

Nefcanto commented 4 months ago

Tests are done with Postgres https://www.techempower.com/benchmarks/#section=data-r22&hw=ph&test=fortune

Nefcanto commented 2 months ago

Arrays to replace our CSV architecture (which has caused a lot of headaches in keeping them updated).

Nefcanto commented 1 month ago

It does not have multiple engines (InnoDB, MyISAM, ...). Thus less confusion and more simplicity root-leaf gradient towards leaves.

Nefcanto commented 1 week ago

More and more examples use Postgres out of the box:

https://www.keycloak.org/server/containers

The following Containerfile creates a pre-configured Keycloak image that enables the health and metrics endpoints, enables the token exchange feature, and uses a PostgreSQL database.