Hi @lizlam! Super delayed reply here, but thanks again for all this. Helpful comments about both Web and API sides – you’re not the only one feeling the learning curve with the DB model(s) and GraphQL! I think that’s going to be something we continue to improve over the long term regarding both DX and tutorials, docs, etc.
re: DB Models
Couple things here – although we can be slow to reply (or sometimes super fast), don’t hesitate to create new topics in “Troubleshooting” with code snippets and asking for help. Did you ever get this one working correctly?
Secondly, a great resource for this is the Prisma Data Model documentation. This is the specific documentation for the
re: DB local and on Heroku
Since I started off with sqlite, I didn’t realize I needed to change the DB source, delete/redo my migrations and set $DATABASE_URL. Is there a way to maintain my sqlite env for local development?
^^ Hmm, that actually shouldn’t have been the case at all. The only setting to add should have been the Netlify Deploy ENV var. In your root
package.json, you should see
"netlify-plugin-prisma-provider": "^0.3.0" --> this will allow you to use SQLite locally and then, during Netlify build, handle all the changes required by Migrations, etc. to use Postgres. There’s a chance you caught our Tutorial between some changes (there have been a lot). But the current “Deployment” section is up to date with a simplified process.
Cloudspire, Roll for the Galaxy, Tetrarchia, Tiny Epic Galaxies and good ole’ fashion Backgammon
Rad! Lots of new ones and now on my list