diff options
| author | Joe Carstairs <65492573+Sycamost@users.noreply.github.com> | 2023-11-29 18:15:14 +0000 |
|---|---|---|
| committer | Joe Carstairs <65492573+Sycamost@users.noreply.github.com> | 2023-11-29 18:15:14 +0000 |
| commit | 9ced895772ebecb2fa330ae2eecd42060abf2a7b (patch) | |
| tree | b08b6a08fd39a11eaef2a2e2b92a661ad00247b0 /README.md | |
| parent | 960b019a018c2faf8da1c4a4ade6c12b3c21e5bd (diff) | |
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 25 |
1 files changed, 23 insertions, 2 deletions
@@ -101,8 +101,8 @@ Follow this guidance alongside the [general guidance](#general-guidance). ## Infrastructure -The deployment infrastructure for the website is in four parts: the domains, the SSL certificates, -the hosting, and the CI/CD. +The deployment infrastructure for the website is in five parts: the domains, the SSL certificates, +the hosting, the CI/CD and the database. ### Domains @@ -151,3 +151,24 @@ deploy, and you've checked that everything looks good on [make a Pull Request to merge deployment-staging into deployment-production](https://github.com/Sycamost/lallans-wabsteid-astro/compare/deployment-production...deployment-staging). Once that Pull Request is approved by a code owner, merge it in and it should update production in under five minutes. + +### Database + +We have a database. It is a +[Postgres database hosted on Vercel](https://vercel.com/docs/storage/vercel-postgres/quickstart). + +It has two tables: + +- subscriptions + - id: VARCHAR(255) + - email_address: VARCHAR(255) +- dev_subscriptions + - id: VARCHAR(255) + - email_address: VARCHAR(255) + +One table is there so that users can look up their subscriptions, and thereby +retrieve the subscription ID so that they can amend or cancel their subscription. +The second table is there to test out the Postgres integration in staging +with dummy data. + +The easiest way to view, update, create and delete tables is on the Vercel dashboard. |