plate0 / platezero

Recipe Manager, Organizer, Creator
https://platezero.com
5 stars 2 forks source link

Redo database schema for simplicity and graphql #399

Closed ethanmick closed 2 years ago

ethanmick commented 2 years ago

This is going to remove many features from PlateZero and really bring it back to the core focus of storing recipes, updating them and writing notes for yourself for next time.

This new database is going to use Graphile as a GraphQL layer to automatically create the schema. We will still use JWT tokens to manage user authentication. We will use Postgres Roles and security access layers to manage what the user can do.

Create two schemas, one public and one private. GraphQL can only access the public schema. Further we use the authorization to limit what the user can do.

Start layering in comments, which turn into GraphQL documentation.

This has the basis of registering a user and authentication/authorization.

Update to Postgres 13.

vercel[bot] commented 2 years ago

This pull request is being automatically deployed with Vercel (learn more).
To see the status of your deployment, click below or on the icon next to each commit.

🔍 Inspect: https://vercel.com/ethanmick-pro/platezero/FQdi2Qdgyw5Xwd2NVee9SNy9qE5t
✅ Preview: https://platezero-git-ethanmick-graphql-ethanmick-pro.vercel.app