Task: Merge all databases into one
This page documents a task in the Infrastructure cleanup story. It captures the goal, current status, acceptance, and any notes or results.
Goal
Eliminate the ores_admin + ores_template dedicated databases; rely on RLS for test isolation.
Status
| Field | Value |
|---|---|
| State | DONE |
| Parent story | Infrastructure cleanup |
| Now | Completed 2026-02-11. |
| Waiting on | None. |
| Next | None. |
| Last touched | 2026-02-11 |
Acceptance
ores_admin+ores_templatedatabases removed.- Two-phase database creation:
create_database.sql(superuser, infrastructure) thensetup_schema.sql(ores_ddl_user, schema + data). - Utility functions relocated under
create/utility/withores_utility_prefix; available in every ORES database.
Plan
Captured during execution; cleared into the parent story on close.
Notes
Template-cloning was an early choice that the multi-tenant + RLS work made obsolete.
Result
Single-database deployment story; least-privilege schema setup.