Web application to manage CSA (Community Supported Agriculture), ACP (Agriculture Contractuelle de Proximité) or Solawi (Solidarische Landwirtschaft) organizations.
This patch switches from a single PostgreSQL database, using schemas for tenant
isolation, to one separate SQLite database per tenant.
This is a major change that affects the whole application. It is a step towards
a simpler architecture with less external dependencies.
This also provides a better isolation between tenants, and allows to easily
backup and restore individual tenants.
The database switch is done by leveraging the ActiveRecord Horizontal Sharding
feature, which allow to dynamically switch the database connection based on the
current tenant.
This patch switches from a single PostgreSQL database, using schemas for tenant isolation, to one separate SQLite database per tenant.
This is a major change that affects the whole application. It is a step towards a simpler architecture with less external dependencies.
This also provides a better isolation between tenants, and allows to easily backup and restore individual tenants.
The database switch is done by leveraging the ActiveRecord Horizontal Sharding feature, which allow to dynamically switch the database connection based on the current tenant.